Hi everyone, I’m using Airbyte to sync data from my PostgreSQL database to my BigQuery data warehouse once every night. This morning, I see that the data of yesterday are not in my warehouse, even though the sync is shown as successful. I’ve try to resync, to reset the data, to resync again but nothing moves in my DWH, and I get only succeeded message in Airbyte. Does someone know what I can do to get back to a working refresh state? 🙏

I'm sorry to hear that you're experiencing issues with your data sync from PostgreSQL to BigQuery using Airbyte. Based on the information provided in the extracts, there are a few things you could try: 1. Check the Raw Data Tables in BigQuery: After a successful sync, you should be able to see the data in BigQuery. The tables named

airbyte_raw

contain the raw JSON data fetched from the source. They only have three columns:

_airbyte_ab_id

,

_airbyte_emitted_at

,

_airbyte_data

. These tables exist because a core tenet of ELT philosophy is that data should be untouched as it moves through the “E” and “L” stages so that the raw data is always accessible. [source](https://airbyte.com/tutorials/postgres-to-bigquery) 2. Review the Logs: Airbyte provides full log access to help users debug and fix integration problems. You can review the logs to see if there are any errors or issues that might explain why the data isn't appearing in your data warehouse. [source]() 3. Reach out to Support: If you're still having trouble, you might want to reach out to Airbyte's support team. You can do this through their forum or Slack channel. They may be able to provide more specific guidance based on your situation. [source](https://discuss.airbyte.io/t/3390) [source](https://airbytehq.slack.com/archives/C021JANJ6TY/p1667934406090529) Remember, it's important to provide as much information as possible when reaching out for support. This includes your Airbyte version, the versions of your connectors, and any logs or error messages you've encountered.

How can I reach Airbyte support in Slack?