How Snowflake Turned Postgres Replication into Clockwork

How We Pushed CDC into Postgres

Snowflake's Postgres service introduces data mirroring, a new feature that pushes changes directly from Postgres into Iceberg tables, eliminating fragile connectors and complex failure modes. By using a Postgres extension for change data capture and transactional apply on the Snowflake side, replication becomes a self-maintaining process with low lag and high performance. The article details the engineering behind this push-based approach, including timeline management, transactional boundaries, and live views.