Skip to main content

Amazon Redshift Dialect for sqlalchemy

Project description

Amazon Redshift dialect for SQLAlchemy.

https://travis-ci.org/graingert/redshift_sqlalchemy.png?branch=master

Requirements

  • psycopg2 >= 2.5

  • SQLAlchemy 0.8

Usage

The DSN format is similar to that of regular Postgres:

from sqlalchemy import create_engine

engine = create_engine(“redshift+psycopg2://username@host.amazonaws.com:5439/database”

Notes

Currently, constraints and indexes return nothing when introspecting tables. This is because Redshift implements version 8.0 of the PostgreSQL API.

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlalchemy-redshift-0.1.2.tar.gz (5.6 kB view hashes)

Uploaded Source

Built Distribution

sqlalchemy_redshift-0.1.2-py2.py3-none-any.whl (7.6 kB view hashes)

Uploaded Python 2 Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page