Amazon Redshift Dialect for sqlalchemy
Project description
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://username@host.amazonaws.com:5439/database') Engine(redshift+psycopg2://username@host.amazonaws.com:5439/database)
See the docstring for RedshiftDDLCompiler in dialect.py for more detail.
0.3.1 (2015-10-08)
Fix breakages to CopyCommand introduced in 0.3.0: Thanks solackerman. (Issue #53)
When format is omitted, no FORMAT AS … is appended to the query. This makes the default the same as a normal redshift query.
fix STATUPDATE as a COPY parameter
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)
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)
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for sqlalchemy-redshift-0.3.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 163977655e754fbd6ac253c6436339dfcac64f1889ed043414d2f582ae9ce83e |
|
MD5 | 9c84f66bde0d7e0d318c8477c820baba |
|
BLAKE2b-256 | f2796752be9f1c04597e3e618434640a5caa6281f9eceb455e1f84ac0f830f30 |
Hashes for sqlalchemy_redshift-0.3.1-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1b70ddc327d65810970b3161cc3e90252f170f97a57240db8def3bfa78b36816 |
|
MD5 | 82ecf5b3a5448c76bf4a4e88fb2668b2 |
|
BLAKE2b-256 | 58a88a36cd9b94943fe9d03cb3c813bb01ebee47d94846e1065ce378ae7d3fd1 |