Q: Automatic schedular triggered after bigquery table load It's about to Trigger automatically schedular after bigquery table get loaded.
In Brief:
I don't want to use weekly schedule Query , that are manual task, I want this to make it automatically trigger the Schedular when table get loaded to the Bigquery table.
Currently I'm using manual weekly schedule query, I want that the query triggers automatically without any Manual things.
I am Just trying to think about logic but not getting koi.

A: Airflow doesn't provide an external trigger in the dag, but you can create your dag and trigger it from a cloud function once the table is loaded, this cloud function send a POST http request to Airflow API to trigger a new run with all the params your dag needs to process the data.
To trigger the cloud function, you can check this answer which explain how to use eventarc to listen your bigquery logs from cloud watch, filter them and trigger cloud function run.
To trigger the dag run, you can check the Airflow API doc and the API security doc in order to allow cloud function to send requests to the API.
