Clickhouse
Clickhouse
To use Clickhouse with StreamZero you will need to add the following Python libraries:
clickhouse-driver==0.2.0
clickhouse-sqlalchemy==0.1.6
If running StreamZero using Docker Compose, add the following to your ./docker/requirements-local.txt
file:
clickhouse-driver>=0.2.0
clickhouse-sqlalchemy>=0.1.6
The recommended connector library for Clickhouse is sqlalchemy-clickhouse.
The expected connection string is formatted as follows:
clickhouse+native://<user>:<password>@<host>:<port>/<database>[?options…]clickhouse://{username}:{password}@{hostname}:{port}/{database}
Here’s a concrete example of a real connection string:
clickhouse+native://demo:demo@github.demo.trial.altinity.cloud/default?secure=true
If you’re using Clickhouse locally on your computer, you can get away with using a native protocol URL that uses the default user without a password (and doesn’t encrypt the connection):
clickhouse+native://localhost/default
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.
Last modified November 13, 2023: init (cb2a58c)