Issue with Amazon Ads data retrieval after Airbyte update

Summary

User is experiencing issues retrieving reports from Amazon Ads since May 30th after an Airbyte update. The error messages indicate a 400 Client Error: Bad Request when trying to download the report.


Question

Hi there, I have been using Airbyte Cloud and noticed that I have not been able to retrieve reports from Amazon Ads since May 30th.
Since there were no execution errors, it took me a while to realize that the data retrieval was failing.
I saw that a <https://github.com/airbytehq/airbyte/pull/38737|new version> was released on May 29th, and I wonder if this could be the cause. Could you please look into this?
Below are the errors I am encountering:

2024-06-19 16:05:03 source > Giving up _download_report(...) after 5 tries (requests.exceptions.HTTPError: 400 Client Error: Bad Request for url: <https://offline-report-storage-us-west-2-prod.s3.us-west-2.amazonaws.com/7ed7825c-1da8-4a3d-8366-5035da26ed6b-1718813033167/report-7ed7825c-1da8-4a3d-8366-5035da26ed6b-1718813033167.json.gz?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEIf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLXdlc3QtMiJIMEYCIQCI5f%2BX9o5bQbqnBeyjAnSu3UJrG05ErfZ%2Fo1reIC4XOQIhAPJjMUw%2FfA7xnLSciRhq0bsbD85WrWrQ%2Bssfk9jmAZSzKuEFCDAQAhoMNDA5Mzc1MTI1MTE2IgzicHTMMJAnlcCGZv8qvgX89rA5NJrZ3%2Fe1TN84JAcHwvNJ%2FnyDEY1TQ2pyhfaHwYeJJNwCOvsKvtERPWbSmLXQw3QbpztDFOEOcsaXG58W2D6WCo28cEi5MyZnkvx%2Beov9NkWUhCmTuUteuOfDPKg78ndo7ovsz0uwLaGDN%2F4pNbQnH%2FSDtBzXSGUKf%2BKbtfUf3hToJmzAQo2dlGCDHQVB2JHxjAPvY9W7t%2BrQJX1VZRqHV7G6QVrYhDQqQwaH9qd66d3UArYgG%2BBWoV7xODsGzQuyWTZY..>)
2024-06-19 16:05:03 source > Backing off _try_read_records(...) for 5.9s (source_amazon_ads.streams.report_streams.report_streams.ReportGenerationFailure: 400 Client Error: Bad Request for url: <https://offline-report-storage-us-west-2-prod.s3.us-west-2.amazonaws.com/7ed7825c-1da8-4a3d-8366-5035da26ed6b-1718813033167/report-7ed7825c-1da8-4a3d-8366-5035da26ed6b-1718813033167.json.gz?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEIf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLXdlc3QtMiJIMEYCIQCI5f%2BX9o5bQbqnBeyjAnSu3UJrG05ErfZ%2Fo1reIC4XOQIhAPJjMUw%2FfA7xnLSciRhq0bsbD85WrWrQ%2Bssfk9jmAZSzKuEFCDAQAhoMNDA5Mzc1MTI1MTE2IgzicHTMMJAnlcCGZv..>)```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1718853778762979) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["amazon-ads", "data-retrieval", "airbyte-update", "400-client-error", "bad-request"]
</sub>