ClickHouse

To use ClickHouse with Superset, you will need to add the following Python library:

  1. clickhouse-connect>=0.6.8

If running Superset using Docker Compose, add the following to your ./docker/requirements-local.txt file:

  1. clickhouse-connect>=0.6.8

The recommended connector library for ClickHouse is clickhouse-connect.

The expected connection string is formatted as follows:

  1. clickhousedb://<user>:<password>@<host>:<port>/<database>[?options…]clickhouse://{username}:{password}@{hostname}:{port}/{database}

Here’s a concrete example of a real connection string:

  1. clickhousedb://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 http protocol URL that uses the default user without a password (and doesn’t encrypt the connection):

  1. clickhousedb://localhost/default