Google ads, breaking 3 tables for invalid data type

Troubleshooting
,
#1
  • 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

#2

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

#3

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
#4

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?