Skip to content

Redshift (Source)

Reads data from Amazon Redshift via the Data API.

Configuration

yaml
source:
  kind: redshift
  cluster_identifier: my-cluster
  database: analytics
  db_user: admin
  region: us-east-1
FieldDefaultDescription
cluster_identifierRedshift cluster identifier
workgroup_nameServerless workgroup (alternative to cluster)
database(required)Database name
db_userDatabase user (for cluster mode)
tablesList of tables to read
queryCustom SQL query
regionAWS region

Namespace: redshift.{database}.{table_name}

CLI

bash
skippr connect source redshift-source \
  --cluster-identifier my-cluster \
  --database analytics \
  --db-user admin \
  --tables public.customers,public.orders \
  --region us-east-1
FlagDescription
--cluster-identifierRedshift cluster ID (or use --workgroup-name for Serverless)
--workgroup-nameServerless workgroup name
--databaseDatabase name
--db-userDatabase user
--tablesComma-separated list of tables
--regionAWS region

Authentication uses the AWS default credential chain (env vars, instance profile, SSO).