Skip to main content

Amazon Redshift

Required extra

This connection requires the redshift extra. See Installation.

Test data in Amazon Redshift (both provisioned clusters and Redshift Serverless). Redshift is reached over the PostgreSQL wire protocol via the ibis Postgres backend, using username/password authentication.

Server​

servers:
  - server: redshift
    type: redshift
    host: my-workgroup.123456789012.us-east-1.redshift-serverless.amazonaws.com
    port: 5439
    database: dev
    schema: analytics

Environment variables​

Connection parameterEnvironment variable
userDATACONTRACT_REDSHIFT_USERNAME
passwordDATACONTRACT_REDSHIFT_PASSWORD
note

IAM-based authentication (region / access key / role ARN) is not currently supported for Redshift, because ibis connects through the generic Postgres backend rather than a Redshift-specific driver.