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?

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.