Skip to main content
Donate to the Python Software Foundation or Purchase a PyCharm License to Benefit the PSF! Donate Now

Amazon Redshift Dialect for sqlalchemy

Project description

redshift_sqlalchemy
==================

Amazon Redshift dialect for sqlalchemy.

.. image:: https://travis-ci.org/binarydud/redshift_sqlalchemy.png?branch=master

Requirements
-------------
* pysocpg2 >= 2.5
* SQLAlchemy 0.8


Usage
-----
DSN format is simpilar to that of regular postgres:

from sqlalchemy import create_engine

engine = create_engine("redshift+psycopg2://username@host.amazonaws.com:5439/database"

Notes
-----

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