5-minute Tutorials
Streaming Query Replication of PostgreSQL To Snowflake
Below is a 5-minute tutorial to test Streaming Query Replication from Postgres to Snowflake
Step 1: CREATE Postgres and Snowflake Peers
Step 2: Create and populate tables on the Postgres PEER
Below script helps creates and populate pgbench_history
with dummy data on your PostgreSQL peer.
Step 3: Create pgbench_history table on the destination (snowflake) PEER
Step 4: Kick off MIRROR with 8 threads and 50000 rows per partition
Step 5: Monitor the MIRROR
You can connect to localhost:8085
to gain full visibility into the different jobs and steps that PeerDB performs under the hood to manage the MIRROR.
Step 6: Validate the MIRROR
In 1-2 minutes the MIRROR should complete syncing data. Now validate the data on both postgres and snowflake peers. Number of rows should match