ingestr recipes/Load a specific sourceData Engineer

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, Google Chat, WhatsApp, Discord, Telegram, email and the browser.

Get ingestr on GitHub How ingestr works

Command

ingestr ingest

Defined 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.