[ Bug ] For PostgreSQL it get's wrong database name

[Alex-Ivanov777]

If one uses Airflow connection to PostgreSQL database then airflow-dbt-python uses name of connection as database name instead of database name defined in Airflow connection.

[andreaslang]

I actually run just into the same issue and found the solution looking through the code.

At the heart of it the problem is in the fact that what is "schema" in the postgres connection would usually be the database name.

In the code what is called schema in the connection is mapped to dbt schema, but you can provide dbname in the connection extra.

So your secret value will look like this

{"conn_type":"postgres","extra":"{\"dbname\":\"my_db\"}, ..."