[source-google-ads] Regression in custom queries data load
- 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
Bewertung
Dieses Issue wurde noch nicht bewertet.