Going to re:Invent this December? Come party with us and The Chainsmokers ->->

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!

Other integrations

Get started with ClickHouse Cloud for free

We'll get you started on a 30 day trial and $300 credits to spend at your own pace.