Hello - We have an issue with an AirByte pipeline.
Our current setup:
• AirByte deployed on a VM on GCP
• AirByte talks to a SQL Server VM in Azure
• CDC is enabled on a bunch of tables in SQL Server VM
• Pipeline writes data to a BQ dataset in incremental + dedup mode
The Problem:
• A couple of tables have data mismatch
• These tables have FLOAT, Char and varchar columns, and the UPDATES are not propagating to the target tables
• The missing data is also not found on SCD tables or even _tmp tables as well.
• No Errors in the sync logs found
Is this a known issue with the SQL Server connector?