Hello guys, we have a Postgres to bigquery connect...
# ask-community-for-troubleshooting
p
Hello guys, we have a Postgres to bigquery connection with CDC enabled. After the initial and a few syncs, data is not propagated correctly to bigquery. Got data count mismatch on the destination side. let's say the source table has 1700 rows but Bigquery tables have only 1670 rows. Has anyone run into this?
k
A message from kapa.ai
Hmm, I don't know enough to give you a confident answer yet. However, I can provide you with some resources that might help you troubleshoot the issue: 1. [Airbyte's Change Data Capture (CDC) Replication Tutorial](https://airbyte.com/tutorials/incremental-change-data-capture-cdc-replication): This tutorial provides an overview of CDC replication and how to set it up with Airbyte. 2. [Airbyte Documentation on Postgres Source](https://docs.airbyte.com/integrations/sources/postgres): This documentation provides information on configuring the Postgres connector with CDC and its considerations. 3. [Forum Discussion on BigQuery Destination using Incremental Append](https://discuss.airbyte.io/t/2127): This forum discussion might provide some insights into similar issues faced by other users. You can also consider posting your question on the [Airbyte Forum](https://discuss.airbyte.io) or [Airbyte Slack](https://airbytehq.slack.com) to get more specific help from the community and the Airbyte team.