Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi, anyone have issues with the Google Ads connector 0.2.1 -&gt; BQ denormalized 1.2.4 with GCS staging ?
```BigQueryError{reason=invalidQuery, location=query, message=Field ad_group_criterion_final_urls has incompatible types. Configured schema: string. Avro file: record}```
Is this a bug on the source connector?

<@U01MMSDJGC9> turned this message into Zendesk ticket <https://airbyte7538.zendesk.com/agent/tickets/2793 | 2793> to ensure timely resolution!

Can you share the complete file log <@U02EMC5UPUY>?

```"ad_group_criterion.final_mobile_urls": {
      "type": ["null", "string", "array"]
    },
    "ad_group_criterion.final_urls": {
      "type": ["null", "string", "array"]
    },```
I think the schema might be missing the child node of `items` for the array seen in other array type field.
example:
```"ad_group.targeting_setting.target_restrictions": {
      "type": ["null", "array"],
      "items": {
        "type": "string"
      }
    },```

logs-28.txt

Tried reverting back to different versions of the connector and still getting the same error.
`0.1.44`
`0.1.42`

<@U02EMC5UPUY> can you disable the staging and test without it

sure, ill test it with standard insert and get back to you.

Screen Shot 2022-10-15 at 10.11.28 AM.png

seems like its the same error using standard insert

logs-55.txt

seems like similar fields are in two different streams which will cause the error when trying to sync them
`display_topics_performace_report`
`display_keyword_performace_report`

Sorry I missed this, do you still need help here?

logs-220 (1).txt

Yes. Using the latest google ads connector 0.2.3 I am still seeing the same error coming from the two streams mentioned. Here is the latest log from the run.

```Caused by: com.google.cloud.bigquery.BigQueryException: Field ad_group_criterion_final_urls has incompatible types. Configured schema: string. Avro file: record```


seems like an error in the schema fields for the two streams?
```Field{name=ad_group_criterion_final_urls, type=STRING, mode=NULLABLE, description=null, policyTags=null} ```
 should be `mode=REPEATED` if the field is of record type?

```Stack Trace: java.lang.RuntimeException: Failed to upload data from stage testing/ws_3_s_13_GOOGLE_ADS_display_keyword_performance_report/2022/10/25/13/39a51fb1-b141-4bd8-8d01-695b569c532d/```
Are you using staging? could you try without it?

I did and it was the same error <https://airbytehq.slack.com/archives/C021JANJ6TY/p1665843145666369?thread_ts=1665614243.534569&amp;cid=C021JANJ6TY|here> along with the log.