Experiments >

Clickhouse + Metabase setup

Experiment #20122nd June, 2021by Joshua Nussbaum

I’ve been messing around with an analytics project using Clickhouse.

Clickhouse is really good at storing tons of data points and being able to querying them efficiently. It even understands the MySQL and PostgresSQL protocol, so you can using existing drivers.


To analyze the data I wanted to try Metabase, but the docker container didn’t have a clickhouse driver, so it took a little futzing around to make it work.



#!/usr/bin bash

# install clickhouse locally
sudo apt install clickhouse-server clickhouse-client

# download latest driver for metabase+clickhouse
mkdir metabase-plugins
wget https://github.com/enqueue/metabase-clickhouse-driver/releases/download/0.7.5/clickhouse.metabase-driver.jar -P metabase-plugins/

# boot container, mapping plugin dir and exposing current host as `host.docker.internal`
docker run -d -p 3000:3000 
  --mount type=bind,source=$(pwd)/metabase-plugins,destination=/plugins 
  --name metabase metabase/metabase

# open metabase in browser
google-chrome http://localhost:3000

# follow setup wizard
# - choose `clickhouse` as the driver
# - use `host.docker.internal` as the host

You can verify if the container has access by running curl within the container:

> docker exec -it metabase curl host.docker.internal:8123
view all experiments

Stay tuned in

Learn how to add more experimentation to your workflow