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. Bruin does this in one platform: ingestion, SQL and Python pipelines, quality checks, lineage, and an AI data analyst that answers in Slack, Microsoft Teams, and the browser.
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.