...
A special column in the target data table is also assigned a unique Transaction ID, generated for each batch. In relation to this, a batch status table is utilized to indicate the batch status for the unique Transaction ID.
GCP BigQuery Agent Workflow
...