hussein-awala commented on issue #30288: URL: https://github.com/apache/airflow/issues/30288#issuecomment-1483818219
If you want to use `SqlSensor` with BigQuery, you should use a connection of type `gcpbigquery`, in this case the `SqlSensor` will initiate an instance from `BigQueryHook` which extends `DbApiHook`. But when you provide a connection of type `google_cloud_platform`, the sensor will use `GoogleBaseHook`. This connection can be used to communicate with GCP API, or in the sensors and operators created in the provider `google`. For now, the only way to initiate and use the correct hook in the other providers is providing a connection from the exact type defined in the hook and not a connection defined in the parent of the hook class. -- 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]
