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 parameter | Environment variable |
|---|---|
user |
DATACONTRACT_REDSHIFT_USERNAME |
password |
DATACONTRACT_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. :::
