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 RedshiftDDLCompiler documentation for details on Redshift-specific features the dialect supports.
0.4.0 (2015-11-17)
Change the name of the package to sqlalchemy_redshift to match the naming convention for other dialects; the redshift_sqlalchemy package now emits a DeprecationWarning and references sqlalchemy_redshift. The redshift_sqlalchemy compatibility package will be removed in a future release. (Issue #58)
Fix a bug where reflected tables could have incorrect column order for some CREATE TABLE statements, particularly for columns with an IDENTITY constraint. (Issue #60)
Fix a bug where reflecting a table could raise a NoSuchTableError in cases where its schema is not on the current search_path (Issue #64)
Add python 3.5 to the list of versions for integration tests. (Issue #61)
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
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.4.0.tar.gz
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 40db786d6928f9b6279ef45d3ea915f00738247a99ba38a8beab6735eba9eeca |
|
| MD5 | 1351ae60a5caa9f8fbe26fc317768c87 |
|
| BLAKE2b-256 | 2048bd2a358da7fa9b94730772f18bde9925ae64b3d1acded5402accf584b819 |
Hashes for sqlalchemy_redshift-0.4.0-py2.py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 549931aabd9db64352c3a92ec152c0e7de9159052f8373055ab760b78af33e73 |
|
| MD5 | 8ed14146e6266b3033a20cd69c73dbd2 |
|
| BLAKE2b-256 | f28191f7968932acd0a4eead254422472d2e9e597eac5ab2ba88cb0f9590a565 |
