Hello, I am experiencing an issue with Airbyte cor...
# ask-community-for-troubleshootingn
Nathan Gold
05/18/2023, 2:52 PMHello, I am experiencing an issue with Airbyte correctly copying data from my organizations Postgres DB to BigQuery. It seems that not all of the records that I would expect to be copied are being copied over (originally we were missing 1 record, and after our automated sync just ran again we are now missing more than 2,000 records). We had thought that the sync would have solved our issue, however, it appears to not have. In addition, before we tried to run this sync, we noticed that older records which had been written to BigQuery before from Airbyte were being altered in a way that we could not understand. These were not records that should have been updated at all. Any assistance here would be greatly appreciated. @Divine
k
kapa.ai
05/18/2023, 2:52 PMA message from kapa.ai
kapa.ai
05/18/2023, 2:53 PMHmm, I don't know enough to give you a confident answer yet. However, I can provide some general troubleshooting steps based on the information extracts. 1. Ensure that you're looking at the correct table in the destination and not a temporary table [source](https://docs.airbyte.com/troubleshooting/running-sync). 2. Check if the basic normalization toggle is set to true in the connection settings. If it's false, you might see a JSON file instead of columns [source](https://docs.airbyte.com/troubleshooting/running-sync). 3. Make sure Airbyte and the connectors are updated to their latest versions [source](https://docs.airbyte.com/troubleshooting/running-sync). 4. If you're using incremental sync, ensure that you have the correct cursor field and primary key set [source](https://airbyte.com/tutorials/incremental-data-synchronization). 5. Check if there are any known issues with the Postgres and BigQuery connectors in the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte/issues). If these steps don't resolve your issue, I recommend reaching out to the Airbyte community on their [Slack](https://slack.airbyte.io) or [forum](https://discuss.airbyte.io) for further assistance.