Open
Description
Connector Name
Google-Ads
Connector Version
2.0.3
What step the error happened?
Updating the connector
Relevant information
Currently when testing the Google-Ads (v2.0.3) source connector and when trying to use Custom GAQL Queries I'm seeing the following error even though my query is only looking at 1 day
my query:
SELECT
click_view.ad_group_ad,
click_view.gclid
FROM click_view
WHERE
segments.date = '2023-12-04'
The same error happens even when filtering using >= and < or DURING TODAY
error_code { query_error: DATE_RANGE_TOO_NARROW } message: "\'segments.date\' start with 2023-12-01 end at 1980-01-01 in WHERE clause must be constrained to a date range of at least 1 day." }
Relevant log output
File "/usr/local/lib/python3.9/site-packages/google/ads/googleads/interceptors/exception_interceptor.py", line 71, in _handle_grpc_failure
raise self._get_error_from_response(response)
google.ads.googleads.errors.GoogleAdsException: (<_InactiveRpcError of RPC that terminated with:
status = StatusCode.INVALID_ARGUMENT
details = "Request contains an invalid argument."
debug_error_string = "UNKNOWN:Error received from peer ipv4:172.253.116.95:443 {grpc_message:"Request contains an invalid argument.", grpc_status:3, created_time:"2023-12-11T12:44:05.435876194+00:00"}"
>, <_InactiveRpcError of RPC that terminated with:
status = StatusCode.INVALID_ARGUMENT
details = "Request contains an invalid argument."
debug_error_string = "UNKNOWN:Error received from peer ipv4:172.253.116.95:443 {grpc_message:"Request contains an invalid argument.", grpc_status:3, created_time:"2023-12-11T12:44:05.435876194+00:00"}"
>, errors {
error_code {
query_error: DATE_RANGE_TOO_NARROW
}
message: "\'segments.date\' start with 2023-12-11 end at 1980-01-01 in WHERE clause must be constrained to a date range of at least 1 day."
}
request_id: "nqt3Tym1rO9382agqKYrdw"
, 'nqt3Tym1rO9382agqKYrdw')
2023-12-11 12:44:05 WARN i.a.w.g.DefaultCheckConnectionWorker(run):110 - Check connection job subprocess finished with exit code 1
2023-12-11 12:44:05 INFO i.a.c.i.LineGobbler(voidCall):149 -
2023-12-11 12:44:05 INFO i.a.c.i.LineGobbler(voidCall):149 - ----- END CHECK -----
2023-12-11 12:44:05 INFO i.a.c.i.LineGobbler(voidCall):149 -Contribute
- Yes, I want to contribute