Postgres CDC to Snowflake

​

What you need

• A Zwiron account — start free trial
• PostgreSQL ready for your sync mode — see PostgreSQL connector
• Snowflake credentials — see Snowflake connector
• Hosted if both ends are reachable from the internet (allowlist egress IPs on Postgres if needed), or an agent when Postgres stays private

​

Steps

​

1. Choose Hosted or Agent

• Hosted — nothing to install; allowlist egress IPs if Postgres has a firewall
• Agent — install next to Postgres when the database is private — When to use the agent

​

2. Create connections

1. Create a connection for PostgreSQL (source)
2. Create a connection for Snowflake (destination)
3. Test both in the dashboard

​

3. Create the pipeline

1. Follow Your first pipeline
2. Select PostgreSQL → Snowflake and the tables to sync
3. Sync mode:
   • CDC — continuous change capture
   • Incremental — when you have a reliable cursor column
   • Full Refresh — small tables or one-time loads

​

4. Schedule and run

​

5. After sync (optional)

• Data catalog
• Data quality
• Pipeline validation

​

Related

• PostgreSQL connector
• Snowflake connector
• Hosted vs agent
• Postgres → Snowflake