Understanding CDC for Snowflake to Postgres Integration

Summary

User is inquiring about how Change Data Capture (CDC) works in the context of integrating Snowflake as a source and Postgres as a destination, specifically regarding data deletion not reflecting in Postgres when using incremental-deduped-history.


Question

https://airbytehq.slack.com/archives/C021JANJ6TY/p1681941353967729

Hello everyone,
Hello <@U052Z92RDCN>, and <@U04L9HF3N65>,
I am recently working for the same purpose, wherein I have source as snowflake and destination as postgres. When I do the deletion of data in snowflake that is not getting reflected in postgres, provided I too am using the incremental-deduped-history.

Can you please help me know how CDC works, and how would it solve the issue?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['cdc', 'snowflake', 'postgres', 'incremental-deduped-history', 'data-deletion']