Google Ads synchronization to Big Query (staging)

Hi all, any general advice (max start date, Block size) on connections settings Google Ads → Google Cloud Storage ? The connection is confirmed but fails during synchronization.

  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: Debian 10
  • Memory / Disk: you can use something like 16Gb
  • Deployment: Docker
  • Airbyte Version: 0.35.67
  • Source name/version: Google Ads 0.1.34
  • Destination name/version: Big Query 1.1.0
  • Step: Sync
  • Description: The connection is set up correctly (source tables are available, the connection is confirmed by the UI). It downloads the data - slowly - but fails with the error “Normalization process wasn’t successful” or “Normalization failed”. I do however get results in Big Query with some empty Google Ads tables.

It seems to be that only specific tables are blocking the flow :

  • [ad_group_ad_labels]
  • [ad_group_labels]
  • [campaign_labels]

Not sure I understand the problem. I have a concurrent connection with MySQL source and no problems there.

Hi @NicolasCartelis,
The sync logs will probably expose the root cause of this problem. Do you mind sharing these?