GreatExpectationsOperator is overriding database name with schema

[qwertyyuiop01]

hello,

Usecase: Database name is different from schema names and multiple schemas are available..

1. Trying to connect to redshift db name: main (using conn_id and database name is passed in airflow UI) is failing when schema= "login" or data_asset_name="schema.table_name" is passed as parameter to GreatExpectationsOperator

Error: connection failed for database login.

2. If schema is not passed as parameter or with data_asset_name then seeing

InvalidSchemaName: schema "main" does not exist

[mpgreg]

Same thing happens with postgres.

[mpgreg]

Need to update regarding the change to postgres hook. apache/airflow#26744. Schema should be passed as option in the uri. Such as:

AIRFLOW_CONN_POSTGRES_DEFAULT='postgresql://postgres:postgres@host:5432/postgres?options=-csearch_path%3Dpublic'