BigQuery Data Transfer Service Launches Data Source Change Log for Schema Updates

The BigQuery Data Transfer Service data source change log provides updates on changes to data source schemas and schema mappings. Users can search for specific data sources like Google Ads API or Facebook Ads API, or for specific table names or values to find relevant changes.

January 2025 - Google Ads API

Google Ads transfers will update the Google Ads API from version v16 to v18. This update will change column values for newly transferred data in the affected tables.

Target Dates:

• Start Date: 20 January 2025
• Delivery Date: Pending

Affected Tables and Columns:

1. Table: p_ads_Campaign_customer_id

   • Column: campaign_advertising_channel_type
     • Old Value (v16): DISCOVERY
     • New Value (v18): DEMAND_GEN

2. Table: p_ads_Ad_customer_id

   • Column: ad_type
     • Old Values (v16):
       • DISCOVERY_MULTI_ASSET_AD
       • DISCOVERY_CAROUSEL_AD
       • DISCOVERY_VIDEO_RESPONSIVE_AD
     • New Values (v18):
       • DEMAND_GEN_MULTI_ASSET_AD
       • DEMAND_GEN_CAROUSEL_AD
       • DEMAND_GEN_VIDEO_RESPONSIVE_AD

3. Table: Asset

   • Column: asset_type
     • Old Value (v16): DISCOVERY_CAROUSEL_CARD
     • New Value (v18): DEMAND_GEN_CAROUSEL_CARD

Query Update Instructions

To ensure queries work after the update, modify SQL queries to select both old and new values. For example, replace:

WHERE asset_type='DISCOVERY_CAROUSEL_CARD'

with:

WHERE 
  asset_type='DISCOVERY_CAROUSEL_CARD' 
  OR asset_type='DEMAND_GEN_CAROUSEL_CARD'