Source Stripe: bad request 400 for stream promotion_codes

Hello , I am trying to sync data from Stripe to BQ (Standard Inserts).

Only some data is synced and when I checked logs I saw an error message multiple times

[0m > 09:19:17.259653 [error] [MainThread]: 404 Not found: Table xxxx-realm-122345:stripe_data._airbyte_raw_disputes was not found in location US

This is weird because some tables have data in them within the same dateset.

Thanks in Advance

Can you share the complete logs? Because this line only says the dbt wasn’t able to find the table BUT the connector could failed about reason → stop sync → ask dbt to run and throw this error to you.
Also use the template gave to you, this helps the team a lot identify known issues. Like what vrsion of connector are you using? This can help others users looking to the same problem in the future found the solution.

Stripe Connector Version : 0.1.32
logs-14.txt (2.9 MB)
Uploaded logs as well.

Thanks in Advance

The correct error from the sync is:

Traceback (most recent call last): File "/airbyte/integration_code/main.py", line 13, in <module> launch(source, sys.argv[1:]) File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 127, in launch for message in source_entrypoint.run(parsed_args): File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py", line 118, in run for message in generator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 123, in read raise e File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 114, in read yield from self._read_stream( File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 159, in _read_stream for record in record_iterator: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py", line 248, in _read_full_refresh for record in records: File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 373, in read_records response = self._send_request(request, request_kwargs) File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 337, in _send_request return backoff_handler(user_backoff_handler)(request, request_kwargs) File "/usr/local/lib/python3.9/site-packages/backoff/_sync.py", line 110, in retry ret = target(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/backoff/_sync.py", line 110, in retry ret = target(*args,**kwargs) File "/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py", line 299, in _send response.raise_for_status() File "/usr/local/lib/python3.9/site-packages/requests/models.py", line 960, in raise_for_status raise HTTPError(http_error_msg, response=self)requests.exceptions.HTTPError: 400 Client Error: Bad Request for url: https://api.stripe.com/v1/promotion_codes?limit=100&created%5Bgte%5D=1648771200

You can find more informatino here https://stripe.com/docs/api/errors could you try to run this endpoint using curl?

400 - Bad Request The request was unacceptable, often due to missing a required parameter.

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.