How do I replicate a Postgres database into Snowflake?
Give ingestr a Postgres source URI and a Snowflake destination URI and it copies the table across. Use the merge strategy on a key to keep Snowflake in sync without full reloads.
Command
ingestr ingestDefined in
CLI
Works with
Postgres to Snowflake
What you get
Database replicationmerge strategyincremental key
How it works in code
$ ingestr ingest \
--source-uri $POSTGRES_URI --source-table 'public.orders' \
--dest-uri $SNOWFLAKE_URI --dest-table 'raw.orders' \
--incremental-strategy merge --incremental-key updated_atRun ingestr ingest and ingestr keeps the Snowflake table in sync with Postgres.
Related use cases
Load a specific source
Replicate a database incrementally
How do I keep a database table in sync without full reloads (CDC-style)?
Load a specific sourceLoad Google Sheets into your warehouse
How do I load a Google Sheet into my warehouse?
Load a specific sourceLoad Stripe data into your warehouse
How do I load Stripe data into my warehouse?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.