sqlalchemy-redshift 0.3.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.3.0 (2015-09-29)

• Fix view support to be more in line with SQLAlchemy standards. get_view_definition output no longer includes a trailing semicolon and views no longer raise an exception when reflected as Table objects. (Issue #46)
• Rename RedShiftDDLCompiler to RedshiftDDLCompiler. (Issue #43)
• Update commands (Issue #52)
  • Expose optional TRUNCATECOLUMNS in CopyCommand.
  • Add all other COPY parameters to CopyCommand.
  • Move commands to their own module.
  • Support inserts into ordered columns in CopyCommand.

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. Thanks haleemur. (Issue #35)
• 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