Google Ads synchronization to Big Query (staging)

Connector Questions & Issues
, ,
1

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.

2

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

4

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.