sqlalchemy-redshift 0.2.0

Amazon Redshift Dialect for sqlalchemy

Amazon Redshift dialect for SQLAlchemy.

Installation

The package is available on PyPI:

pip install sqlalchemy-redshift

Usage

The DSN format is similar to that of regular Postgres:

>>> import sqlalchemy as sa
>>> sa.create_engine('redshift+psycopg2://[e-mail]:5439/database')
Engine(redshift+psycopg2://[e-mail]:5439/database)

See the docstring for RedshiftDDLCompiler in dialect.py for more detail.

0.2.0 (2015-09-04)

• Use SYSDATE instead of NOW(). Thanks bouk. (Issue #15)

• Default to SSL with hardcoded AWS Redshift CA. (Issue #20)

• Refactor of CopyCommand including support for specifying format and compression type. (Issue #21)

• Explicitly require SQLAlchemy >= 0.9.2 for ‘dialect_options’. (Issue #13)

• Refactor of UnloadFromSelect including support for specifying all documented redshift options. (Issue #27)

• Fix unicode issue with SORTKEY on python 2. (Issue #34)

• Add support for Redshift DELETE statements that refer other tables in the WHERE clause. (Issue #35). Thanks haleemur <https://github.com/haleemur> _.

• Raise NoSuchTableError when trying to reflect a table that doesn’t exist. (Issue #38).

0.1.2 (2015-08-11)

• Register postgresql.visit_rename_table for redshift’s alembic RenameTable. Thanks bouk. (Issue #7)

0.1.1 (2015-05-20)

• Register RedshiftImpl as an alembic 3rd party dialect.

0.1.0 (2015-05-11)

• First version of sqlalchemy-redshift that can be installed from PyPI