Redshift (Source)

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy

Reads data from Amazon Redshift via the Data API.

Configuration

source:
  kind: redshift_source
  cluster_identifier: my-cluster
  database: analytics
  db_user: admin
  region: us-east-1

Field	Default	Description
cluster_identifier		Redshift cluster identifier
workgroup_name		Serverless workgroup (alternative to cluster)
database	(required)	Database name
db_user		Database user (for cluster mode)
tables		List of tables to read
region		AWS region

Namespace: redshift.{database}.{table_name}

CLI

skippr connect source redshift-source \
  --cluster-identifier my-cluster \
  --database analytics \
  --db-user admin \
  --tables public.customers,public.orders \
  --region us-east-1

Flag	Description
--cluster-identifier	Redshift cluster ID (or use --workgroup-name for Serverless)
--workgroup-name	Serverless workgroup name
--database	Database name
--db-user	Database user
--tables	Comma-separated list of tables
--region	AWS region

Authentication

Authentication uses the AWS default credential chain.

• AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY
• IAM roles, instance profiles, or task roles
• AWS SSO or shared config profiles

Permissions or Network Requirements

The AWS principal needs permission to use the Redshift Data API resources you reference, and the Redshift database user needs read access to the selected tables. The runner must also be able to reach the regional Redshift API endpoint.

Troubleshooting

Symptom	Fix
authentication or API errors	Verify the AWS credential chain, region, and cluster or workgroup identifiers.
query returns no rows	Check the selected tables and confirm the database user can read them.

Next steps

• Pair this source with a destination from Destination Connectors.
• See How It Works for the end-to-end pipeline flow.

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy