Missing of valid example for sql_alchemy_connect_args parameter

[alexandrebunn]

What do you see as an issue?

We want to add some extra configurations for database connection, for exemplo, connection_timeout, timeout, connection retries attempts, etc. Searching at the documentation we've reached the configuration below:

https://airflow.apache.org/docs/apache-airflow/stable/configurations-ref.html#sql-alchemy-connect-args

There isn't an example of a valid configuration. And when we check the URL referenced airflow fails, I've tried some options but all of then generated the error below during startup:

airflow_web     | TypeError: Invalid argument(s) 'XXX' sent to create_engine(), using configuration PGDialect_psycopg2/QueuePool/Engine.  Please check that the keyword arguments are appropriate for this combination of components.

Solving the problem

Providing a valid configuration.

Anything else

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg[bot]]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

[phanikumv]

Can you give the sample command you've tried, and for which provider? I presume it is for Postgres since you've mention Psycopg.

[hussein-awala]

Airflow passes the provided arguments in this conf to the method create_engine through the argument connect_args:

airflow/airflow/settings.py

Lines 217 to 222 in 514112c

	if conf.has_option("database", "sql_alchemy_connect_args"):
	connect_args = conf.getimport("database", "sql_alchemy_connect_args")
	else:
	connect_args = {}
	engine = create_engine(SQL_ALCHEMY_CONN, connect_args=connect_args, **engine_args)

For ex, if you want to add a timeout, you can provide: sql_alchemy_connect_args = {{"timeout": 30}}