Google ads, breaking 3 tables for invalid data type

  • Is this your first time deploying Airbyte: No
  • OS Version / Instance: Ubuntu 20.04
  • Memory / Disk: 8Gb / 100 GB ssd
  • Deployment: Docker
  • Airbyte Version: 0.35.61-alpha
  • Source name/version: airbyte/source-google-ads: 0.1.34 (latest)
  • Destination name/version: airbyte/destination-bigquery: 1.0.5 (latest)
  • Step: normal sync.
  • Description: some fields are getting invalid data type, all 3 as Bad INT64 value, i don’t know if only our company is having this issue, but i’m willing to help with code.

Completed with 3 errors and 0 warnings:

Database Error in model campaign_labels (models/generated/airbyte_tables/airbyte_google_ads/campaign_labels.sql)
Bad int64 value: Destinos - B
compiled SQL at …/build/run/airbyte_utils/models/generated/airbyte_tables/airbyte_google_ads/campaign_labels.sql

Database Error in model ad_group_labels (models/generated/airbyte_tables/airbyte_google_ads/ad_group_labels.sql)
Bad int64 value: Centro-Oeste
compiled SQL at …/build/run/airbyte_utils/models/generated/airbyte_tables/airbyte_google_ads/ad_group_labels.sql

Database Error in model ad_group_ad_labels (models/generated/airbyte_tables/airbyte_google_ads/ad_group_ad_labels.sql)
Bad int64 value: URL Redirect
compiled SQL at …/build/run/airbyte_utils/models/generated/airbyte_tables/airbyte_google_ads/ad_group_ad_labels.sql

logs-255 google ads.txt (1.6 MB)

Are you willing to submit a PR?

Yes

Can you share one example from each stream from the raw tables? This will help us identify quicker the fields with wrong data type.

All fields label.name are strings and in airbyte they are maped as INT64,
can we fix this?

ad_group_labels

{   "ad_group_label.resource_name":"custome95163927",
   "label.resource_name":"customers/8927",
   "ad_group.resource_name":"customers/835",
   "label.name":"Centro-Oeste" #error here but all fields are string
},
{
   "ad_group_label.resource_name":"custo566",
   "label.resource_name":"customers/5366",
   "ad_group.resource_name":"customers/535",
   "label.name":"Ativar dps"
}

campaign_labels

{
   "campaign_label.resource_name":"customers/5361",
   "label.resource_name":"customers/561",
   "campaign.resource_name":"customers/538",
   "label.name":"Destinos - B" #error here but all fields are string
}

ad_group_ad_labels

{
   "ad_group_ad_label.resource_name":"customers/888971",
   "ad_group_ad.ad.resource_name":"customers/83",
   "label.resource_name":"customers/871",
   "label.name":"URL Redirect" # same error
}
1 Like

Sorry the long delay in the reply @bruno-nirello thanks for sharing the sample. It’s safe to update, are you willing to send a PR?