How do I load data from Redshift into my warehouse?
Connect to a Redshift cluster with a source URI that includes user, password, host, port, and database name. Reference a table as schema.table and copy its rows into a warehouse table.
Command
ingestr ingestDefined in
CLI
Works with
Redshift to any ingestr destination
What you get
Table readsSSL connectionsincremental loads
How it works in code
ingestr ingest \
--source-uri "redshift://myuser:mypassword@redshift-cluster.abc123.us-east-1.redshift.amazonaws.com:5439/analytics?sslmode=require" \
--source-table 'public.customers' \
--dest-uri "$SNOWFLAKE_URI" \
--dest-table 'raw.redshift_customers'Run ingestr ingest and ingestr loads the Redshift data into your warehouse.
Related use cases
Load a specific source
Replicate a Postgres database into Snowflake
How do I replicate a Postgres database into Snowflake?
Load a specific sourceReplicate 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?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.