How We Pushed CDC into Postgres

Snowflake developed a new "Data Mirroring" feature for Postgres that reimagines change data capture (CDC) by pushing changes directly from Postgres into Apache Iceberg tables in Snowflake, rather than relying on traditional pull-based replication. This push-based approach, powered by a new Postgres extension called snowflake_cdc, simplifies replication into a reliable, low-cost process with low latency and transactional consistency by eliminating the need for external infrastructure to manage complex failure scenarios. The feature handles schema changes, snapshots, and transaction boundaries automatically within Postgres itself, transforming data replication from a fragile, complex operation into a streamlined, clockwork process.