What's new at Data Integration

Loading data into BigQuery now supports partition-aware and cluster-aware MERGE loading for more efficient incremental data synchronization.

This enhanced Merge loading mode enables:

• Cost efficiency: A native DECLARE / SET pattern enables partition pruning and cluster column equality, reducing scan costs by 70–99% on large workloads.
• Optimized CDC: The connector performs partial column updates to minimize write overhead for Change Data Capture (CDC).
• Automatic schema evolution: New columns are added automatically without requiring table recreation or risking data loss.

This update doesn't require any update on your end - if you are already loading to BigQuery using the Merge mode you should start seeing the benefits on your BigQuery bill with no additional work.