How we pushed CDC into Postgres, and turned replication into clockwork
Summary
Snowflake's engineering blog explains data mirroring for Postgres using change data capture (CDC) to push changes into Iceberg and apply them in Snowflake transactionally. It details the architecture, including the snowflake_cdc extension, per-table change logs, a meta log, and live views, to achieve low-lag, transactional replication between Postgres and Snowflake.