Amazon Redshift dialect for SQLAlchemy.
- psycopg2 >= 2.5
- SQLAlchemy 0.8
The DSN format is similar to that of regular Postgres:
from sqlalchemy import create_engine
engine = create_engine("redshift+psycopg2://[email protected]:5439/database")
Currently, constraints and indexes return nothing when introspecting tables. This is because Redshift implements version 8.0 of the PostgreSQL API.