chalk-sqlalchemy-redshift

What it is and what it does

This package is a SQLAlchemy dialect that translates SQLAlchemy's ORM and expression language into Redshift-compatible SQL. It acts as a bridge between your Python application and Amazon Redshift clusters, allowing you to define tables, run queries, and manage schemas using SQLAlchemy's familiar API instead of raw SQL.

The dialect handles Redshift-specific features like materialized views, spectrum support, and Redshift data types (GEOMETRY, SUPER, HLLSKETCH, TIMETZ). It requires either psycopg2 or redshift_connector as a separate installation to actually connect to Redshift; the dialect itself provides only the SQL translation and connection configuration. Recent versions support SQLAlchemy 1.4.x and 2.0.x, and Python 3.8 through 3.12.

Use it for:

• Define and manage Redshift tables using SQLAlchemy ORM models instead of raw DDL statements.
• Run parameterized queries and aggregations against Redshift using SQLAlchemy's expression language.
• Reflect existing Redshift schemas into Python objects for introspection and dynamic query building.
• Integrate Redshift as a data warehouse backend in a larger Python application using SQLAlchemy's session and connection pooling.
• Support Alembic migrations for Redshift schema changes with column comment support.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides a SQLAlchemy dialect for Amazon Redshift, enabling ORM and SQL expression language support against Redshift clusters via psycopg2 or redshift_connector.

Yes, with conditions. The package is permissively licensed and has low install friction. However, the current version (0.8.15.dev0) is a development release with no changelog entries, and the last stable release was 425 days ago. If you need Redshift support in SQLAlchemy, this is the standard dialect, but verify that the development release is stable for your use case or pin to a stable release. You must separately install psycopg2 or redshift_connector.

Install

chalk-sqlalchemy-redshift on PyPI

pip install chalk-sqlalchemy-redshift

uv add chalk-sqlalchemy-redshift

poetry add chalk-sqlalchemy-redshift

Installing chalk-sqlalchemy-redshift

Before you install

Low install friction with only two runtime dependencies (SQLAlchemy and packaging). Maintenance status is aging—last release was 425 days ago and the current version is a development release (0.8.15.dev0), though the repository remains active with a recent commit on 2025-06-15.

License in practice

MIT license is permissive, allowing commercial and private use with minimal restrictions.

Quickstart

pip install chalk-sqlalchemy-redshift

import sqlalchemy as sa
engine = sa.create_engine('redshift+psycopg2://username@host.amazonaws.com:5439/database')
with engine.connect() as conn:
    result = conn.execute(sa.text('SELECT 1'))

Requires either psycopg2, psycopg2-binary, psycopg2cffi, or redshift_connector to be installed separately; the dialect does not include a driver.

Verify before relying

• Whether the 0.8.15.dev0 development release is stable enough for production use or if a stable 0.8.14 release should be preferred.
• Current compatibility status with recent SQLAlchemy versions beyond what the changelog explicitly documents.
• Whether redshift_connector is now the recommended driver over psycopg2 for new projects.

Package facts

Evidence: chalk_sqlalchemy_redshift-0.8.15.dev0-py3-none-any.whl

Tags

More Front-Ends packages