What you need
- A Zwiron account — start free trial
- PostgreSQL with logical replication / WAL CDC prerequisites (see PostgreSQL connector)
- A Snowflake account and destination credentials (see Snowflake connector)
- Hosted mode if Postgres/Snowflake are reachable from the internet, or an agent in your VPC
Steps
1. Choose Hosted or Agent
- Hosted — Zwiron runs the pipeline. Allowlist egress IPs if your Postgres firewall requires it.
- Agent — place the agent next to Postgres when row data must stay in your network. See When to use the agent.
2. Create connections
- Create a Connection for PostgreSQL (source).
- Create a Connection for Snowflake (destination).
- Test both connections from the dashboard.
3. Create the pipeline
- Follow Your First Pipeline.
- Pick PostgreSQL → Snowflake.
- Select tables to sync.
- Choose sync mode:
- CDC for continuous change capture (preferred for near-real-time warehouses)
- Incremental when you have a reliable cursor column
- Full Refresh for small tables or one-time loads
4. Schedule and run
Set a schedule, start the job, and watch monitoring for throughput and errors.5. Trust what landed
After sync:- Browse inventory in the Data Catalog
- Attach Data Quality checks
- Optionally run pipeline validation