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:https://[email protected]:5439/database')
Engine(redshift+psycopg2:https://[email protected]:5439/database)
See the RedshiftDDLCompiler documentation for details on Redshift-specific features the dialect supports.