You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "alexandrebunn (via GitHub)" <gi...@apache.org> on 2023/05/12 18:20:27 UTC

[GitHub] [airflow] alexandrebunn opened a new issue, #31260: Missing of valid example for sql_alchemy_connect_args parameter

alexandrebunn opened a new issue, #31260:
URL: https://github.com/apache/airflow/issues/31260

   ### 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:
   
   ```text
   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
   
   - [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [airflow] phanikumv commented on issue #31260: Missing of valid example for sql_alchemy_connect_args parameter

Posted by "phanikumv (via GitHub)" <gi...@apache.org>.
phanikumv commented on issue #31260:
URL: https://github.com/apache/airflow/issues/31260#issuecomment-1548091663

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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [airflow] hussein-awala closed issue #31260: Missing of valid example for sql_alchemy_connect_args parameter

Posted by "hussein-awala (via GitHub)" <gi...@apache.org>.
hussein-awala closed issue #31260: Missing of valid example for sql_alchemy_connect_args parameter
URL: https://github.com/apache/airflow/issues/31260


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [airflow] hussein-awala commented on issue #31260: Missing of valid example for sql_alchemy_connect_args parameter

Posted by "hussein-awala (via GitHub)" <gi...@apache.org>.
hussein-awala commented on issue #31260:
URL: https://github.com/apache/airflow/issues/31260#issuecomment-1550341861

   Airflow passes the provided arguments in this conf to the method `create_engine`  through the argument `connect_args`:
   https://github.com/apache/airflow/blob/514112c9a214a32e1e42f4a36f03d29afe332821/airflow/settings.py#L217-L222
   
   For ex, if you want to add a timeout, you can provide: `sql_alchemy_connect_args='{"timeout": 30}'`
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [airflow] boring-cyborg[bot] commented on issue #31260: Missing of valid example for sql_alchemy_connect_args parameter

Posted by "boring-cyborg[bot] (via GitHub)" <gi...@apache.org>.
boring-cyborg[bot] commented on issue #31260:
URL: https://github.com/apache/airflow/issues/31260#issuecomment-1546116512

   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.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org