Hey Guys... I am facing a problem trying to ingest...
# ask-community-for-troubleshootingm
Marcelo Santoro
11/05/2022, 1:07 AMHey Guys... I am facing a problem trying to ingest Google Ads data to Bigquery...
Copy code
Database Error in model customer__data__campaigns (models/generated/airbyte_incremental/google_ads/customer__data__campaigns.sql)Bad int64 value: 0.0Marcelo Santoro
11/05/2022, 1:08 AMIt is happening when I try to use Customer ID and Login Customer ID in the ingestion Configuration....
When I try to use just the Customer ID ... everything works well.
Marcelo Santoro
11/05/2022, 3:54 AMIf anyone faces this problem....
Copy code
I downgraded the connector version from 0.2.3 to 0.2.1u
user
11/07/2022, 12:42 PMGlad you figured it out and thanks for sharing the details!
m
Maarten aan de Stegge
11/07/2022, 2:51 PMSame issue with Airbyte cloudā¦ (introduced with version 0.2.3)
Maarten aan de Stegge
11/07/2022, 3:22 PMMaybe because metrics.conversions and metrics.conversions_value are defined as integer, while Google Ads has these as doubleā¦
Maarten aan de Stegge
11/07/2022, 3:24 PMIn
/connectors/source-google-ads/source_google_ads/schemas/campaigns.jsonu
user
11/07/2022, 4:18 PMHey Maarten! Thanks for sharing the details. This Slack channel is for OSS support only, if you require Cloud support please refer to the support within your Cloud instance :)
m
Maarten aan de Stegge
11/08/2022, 10:13 AMIām just saying that Airbyte cloud, which uses the same connector version, has the same issue. No support needed. But Iāll make sure to never name ācloudā here again. š
s
Sreela Das
02/15/2023, 9:53 PM@Marcelo Santoro Did you ever resolve this issue? Iām facing a similar thing on normalizations in BQ and I canāt figure out how to address it
m
Marcelo Santoro
02/15/2023, 10:31 PMHey @Sreela Das.... this is what worked for me:
Copy code
Downgraded the connector version from 0.2.3 to 0.2.1