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.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.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 381c9d865ea857d3f0e5c6e1d85777d521a8b423f3c2d5edb65e5d57cb4d798a |
|
MD5 | e8dc3728a3b32088899cc26828eb5244 |
|
BLAKE2b-256 | d8d5b70fcd4400cc27ad162352549cd8709015ddb47216e84bb278ef233d2d94 |
Hashes for sqlalchemy_redshift-0.3.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f0e2a05a38983748374a4d90b7527ef4ab1ac5385b69fde440f9d35a139fff4f |
|
MD5 | 21afdf1ed0e3b75f7711cf1435267408 |
|
BLAKE2b-256 | c1e69b3fc2eea92a8f68633cfe0ae5ce3f614cc7e192057924aea5b0642a3bed |