Amazon Redshift

https://aws.amazon.com/redshift/

Amazon Redshift is a fully managed data warehouse service.

Installation

Required packages: sqlalchemy-redshift

Drivers

psycopg2Recommended

redshift_connector

PyPI Package: psycopg2

redshift+psycopg2://{username}:{password}@{host}:5439/{database}

Authentication Methods

IAM Credentials (Cluster)

IAM Credentials (Serverless)

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Troubleshooting

Common error messages you may encounter when connecting to or querying Amazon Redshift, along with their causes and solutions.

Authentication1 error

Connection4 errors

Help improve this documentation by editing the engine spec:

Edit redshift.py