Skip to main content

Amazon Redshift

:::info 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.