Amazon Redshift dialect for SQLAlchemy.
The package is available on PyPI:
pip install sqlalchemy-redshift
The DSN format is similar to that of regular Postgres:
>>> import sqlalchemy as sa
>>> sa.create_engine('redshift+psycopg2://[email protected]:5439/database')
Engine(redshift+psycopg2://[email protected]:5439/database)
See the docstring for RedshiftDDLCompiler in dialect.py for more detail.