dabla opened a new issue, #46434: URL: https://github.com/apache/airflow/issues/46434
### Apache Airflow Provider(s) elasticsearch ### Versions of Apache Airflow Providers apache-airflow-providers-elasticsearch==6.0.0 ### Apache Airflow version 2.10.4 ### Operating System Linux ### Deployment Other 3rd-party Helm chart ### Deployment details _No response_ ### What happened Today we tried to use the Elasticsearch connection type (e.g. ElasticsearchSQLHook ) through the SQLExecuteQueryOperator. You would expect it to work as the ElasticsearchSQLHook extends the DbApiHook, unfortunately it doesn't as it is missing some implementations. ### What you think should happen instead I would expect the Elasticsearch connection type to work with the SQLExecuteQueryOperator, as it supports executing SQL statements. ### How to reproduce Just use the SQLExecuteQueryOperator with the Elasticsearch connection type. ### Anything else We've patched the ElasticsearchSQLHook in our Airflow installation to make it work, so I'll create a PR for this to make it work. ### Are you willing to submit PR? - [x] 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
