Skip to main content

ClickHouse dialect for SQLAlchemy.

Installation

The package is installable through PIP:

pip install sqlalchemy-clickhouse

Usage

The DSN format is similar to that of regular Postgres:

>>> import sqlalchemy as sa
>>> sa.create_engine('clickhouse://username:password@hostname:port/database')
Engine('clickhouse://username:password@hostname:port/database')

It implements a dialect, so there’s no user-facing API.

Testing

The dialect can be registered on runtime if you don’t want to install it as:

from sqlalchemy.dialects import registry
registry.register("clickhouse", "base", "dialect")

Release files for sqlalchemy-clickhouse 0.1.5.post0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlalchemy-clickhouse 0.1.5.post0
File Size Uploaded
sqlalchemy-clickhouse-0.1.5.post0.tar.gz 13.3 kB Details

Release files / sqlalchemy-clickhouse-0.1.5.post0.tar.gz

Download URL sqlalchemy-clickhouse-0.1.5.post0.tar.gz
Size 13.3 kB
Tags Source
SHA-256 checksum
How to use checksums
7144dbd07b50d309df12a1206c2cbacda74b646780bd705f6e4e1c07d5b08169
BLAKE2b-256 checksum
How to use checksums
351b9aa149641bd35a9a860c8a25de150db49d42cd51cd20f0ab3e9cf3348f54
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via Python-urllib/2.7
Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page