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

Help improve this documentation by editing the engine spec:

Edit redshift.py