Skip to main content

Amazon Redshift Dialect for sqlalchemy

Project description


Amazon Redshift dialect for sqlalchemy.

.. image::

* pysocpg2 >= 2.5
* SQLAlchemy 0.8

DSN format is simpilar to that of regular postgres:

from sqlalchemy import create_engine

engine = create_engine("redshift+psycopg2://"


Currently, contraints and indexes return nothing when intropecting tables. This comes from the redshift implementation of the postgresql api == 8.0

Project details

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page