Ameya
04/06/2022, 4:27 PM0.35.56-alpha with postgres source connector 0.4.9 with CDC to replicate to bigquery as the destination.
We’re observing the same replication problem as - https://github.com/airbytehq/airbyte/issues/8830, where if a row is deleted in source, the destination continues to display the row in the replicated table. The <table_name>_scd shows _is_airbyte_active column which reflects the deletion, which indicates that there’s a bug in the transformation logic that builds the main table.
This is a blocker for us and would be happy to open a PR, if pointed in the right direction. Any advice?Ari Bajo (Airbyte)
04/06/2022, 4:31 PMAmeya
04/06/2022, 4:34 PMAri Bajo (Airbyte)
04/06/2022, 4:35 PM