[GitHub] [airflow] dabla opened a new issue, #32046: Why isn't there an OdbcOperator?

["dabla (via GitHub)" <gi...@apache.org>]

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

   ### Description
   
   We would like to have an OdbcOperator so that we can easily execute SQL statements without the need of defining methods in our DAG using the OdbcHook.
   
   ### Use case/motivation
   
   We would like to have an OdbcOperator, we're already writing our own one as a POC based on the BaseSQLOperator and also willing to contribute it to the Airflow project, unless there is an alternative or are there any plans to support OdbcHooks right off the SQLOperator?
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a 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] boring-cyborg[bot] commented on issue #32046: Why isn't there an OdbcOperator?

["boring-cyborg[bot] (via GitHub)" <gi...@apache.org>]

boring-cyborg[bot] commented on issue #32046:
URL: https://github.com/apache/airflow/issues/32046#issuecomment-1600569041

   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

[GitHub] [airflow] pankajkoti commented on issue #32046: Why isn't there an OdbcOperator?

["pankajkoti (via GitHub)" <gi...@apache.org>]

pankajkoti commented on issue #32046:
URL: https://github.com/apache/airflow/issues/32046#issuecomment-1600580081

   hi @dabla,
   
   There is an [airflow.providers.common.sql.operators.sql.SQLExecuteQueryOperator](https://github.com/apache/airflow/blob/79eac7687cf7c6bcaa4df2b8735efaad79a7fee2/airflow/providers/common/sql/operators/sql.py#L189) which extends the BaseSQLOperator and is the recommended way for running SQL queries.
   
   Docs link: https://airflow.apache.org/docs/apache-airflow-providers-common-sql/stable/operators.html#execute-sql-query 
   
   This I believe will allow you to run SQL queries for ODBC type connections too. Can you please use that and check if something is missing there? 


-- 
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] potiuk closed issue #32046: Why isn't there an OdbcOperator?

["potiuk (via GitHub)" <gi...@apache.org>]

potiuk closed issue #32046: Why isn't there an OdbcOperator?
URL: https://github.com/apache/airflow/issues/32046


-- 
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