...
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
| Note | ||
|---|---|---|
| ||
Due to the nature of BigQuery, the order of insertion of the UDR data into the BigQuery table is done out of sequence and will appear as such in the target table. Sorting will have to be done from BigQuery itself. |
...