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 Role (Serverless)

IAM Access Key (Serverless)

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 44/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Extended Aggregate Functions

The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.

MEDIANSTDDEV_SAMPVAR_SAMP

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