Metabase

NEW: We have recently contributed to version 0.9.0 of metabase-clickhouse-driver which includes bug fixes and a support for the latest JDBC driver

Installation

We recommend running Metabase as a Docker container. Alternatively, you can also use the Metabase JAR. We present below the two options:

Run as a Docker container

mkdir -p mb/plugins && cd mb
curl -L -o plugins/ch.jar https://github.com/clickhouse/metabase-clickhouse-driver/releases/download/0.9.0/clickhouse.metabase-driver.jar
docker run -d -p 3000:3000 \
  --mount type=bind,source=$PWD/plugins/ch.jar,destination=/plugins/clickhouse.jar \
  --name metabase metabase/metabase:v0.44.6

Run using Metabase JAR

• Download a fairly recent Metabase binary release (jar file) from the Metabase distribution page.

• Download the ClickHouse driver jar from this repository's Releases page

• Create a directory and copy the metabase.jar to it. In that directory create a sub-directory called plugins and copy the ClickHouse driver jar to the plugins directory.

• Make sure you are the in the directory where your metabase.jar lives and run MB_PLUGINS_DIR=./plugins; java -jar metabase.jar.

• For example (using Metabase v0.44.6 and ClickHouse driver 0.9.0):

  mkdir -p mb/plugins && cd mb
  curl -o metabase.jar https://downloads.metabase.com/v0.44.6/metabase.jar
  curl -L -o plugins/ch.jar https://github.com/clickhouse/metabase-clickhouse-driver/releases/download/0.9.0/clickhouse.metabase-driver.jar
  MB_PLUGINS_DIR=./plugins; java -jar metabase.jar
  

Connect to ClickHouse Cloud

• Start (or restart) Metabase and access it at http://hostname:3000, click on "Add a database" and select "ClickHouse".

• Enter the connection details of your ClickHouse Cloud service and click "Save" (make sure to check the "Use secure connection" option).

• Start building data visualizations against your ClickHouse tables!