airbytehq / airbytehq/airbyte

[source-google-ads] Regression in custom queries data load

Offen
#70,293 10 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
area/connectors autoteam community connectors/source/google-ads needs-triage team/extensibility type/bug
Vorherrschende Sprache
Python
Sterne
22.1k
Forks
5.3k
PR-Merge-Kennzahlen
PR-Kennzahlen ausstehend

Beschreibung

### Connector Name

source-google-ads

### Connector Version

4.1.0-rc.1+

### What step the error happened?

During the sync

### Relevant information

It appears that on or around this release, https://github.com/airbytehq/airbyte/pull/68030 when using a custom query that queries the change_event object, the `old_resource` and `new_resource` fields are not populated. All other fields populate as expected. An example custom query is below. The destination used is Bigquery and I have tried deleting the destination table and reloading the data with no success.

Running the query with the API Explore tool or via Python SDK returns all values as expected.

```sql
SELECT
change_event.resource_name,
change_event.change_date_time,
change_event.change_resource_name,
change_event.user_email,
change_event.client_type,
change_event.change_resource_type,
change_event.old_resource,
change_event.new_resource,
change_event.resource_change_operation,
change_event.changed_fields
FROM change_event
WHERE change_event.change_date_time DURING YESTERDAY
AND change_event.change_resource_type in ('AD','AD_GROUP','AD_GROUP_AD','AD_GROUP_BID_MODIFIER','AD_GROUP_CRITERION','CAMPAIGN','CAMPAIGN_BUDGET','CAMPAIGN_CRITERION')
ORDER BY change_event.change_date_time DESC
LIMIT 10000
```

### Relevant log output

```shell

```

### Contribute

- [x] Yes, I want to contribute

Beitragsleitfaden

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.