GCP Cloud Composer (Airflow) has been a nightmare. I cannot recommend it. BQ is great.
https://cloud.google.com/composer/docs/how-to/using/triggeri...
I have cases open with the composer team, and I am upgrading the cluster again this weekend, but I have lost hope at this point; I am designing a solution to stop using external triggers.