ying-w opened a new issue, #30288: URL: https://github.com/apache/airflow/issues/30288
### Apache Airflow version 2.5.2 ### What happened Using sqlsensor with bigquery authenticated using secrets backend will fail with error > The connection type is not supported by SqlSensor. The associated hook should be a subclass of `DbApiHook`. Got GoogleBaseHook Overriding the sensor as described [here](https://stackoverflow.com/questions/71037231/) can be used as a workaround. ### What you think should happen instead When using SqlSensor, `GoogleBaseHook` should be coerced into `BigQueryHook`. Google credentials can be used for many different functions. I do understand that there is probably some ambiguity around which sql backend trying to access GCP. ### How to reproduce `from airflow.providers.common.sql.sensors.sql import SqlSensor` and then specify a connection using secrets backend where secrets value starts with `google-cloud-platform://` ### Operating System OS X 13.2.1 ### Versions of Apache Airflow Providers apache-airflow-providers-google==8.11.0 ### Deployment Astronomer ### Deployment details local testing ### Anything else _No response_ ### 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]
