Overview

You can connect Luabase to Metabase to build dashboards. You’ll need a Metabase instance that has the Clickhouse driver installed (Metabase Cloud doesn’t currently support it).

<aside> 💡 This integration is only available on paid accounts, please contact [email protected] for pricing

</aside>

Spinning up Metabase

If you don’t already have a Metabase instance running, you can set one up using this Docker container on Dockerhub. We don’t like adding superfluous tools to our stack, but in this case, Zeet is well worth it. Zeet helps you run open source apps on your own cloud account (e.g. AWS, GCP, etc.). To set up Metabase with Zeet, connect your cloud account then:

  1. Create new → App

    Untitled

  2. Select the “bjeanes/metabase-clickhouse” Docker Image

    Untitled

  3. Click “Deploy now”!

  4. After the deployment finishes (takes < 2 minutes), click “Visit Active Deployment”

Setting up Luabase in Metabase

  1. Set up a username and password for Metabase then search for “Clickhouse” in “Add your data”

    Untitled

  2. Add your team’s credentials. These can be found in “Settings” (cog icon on right sidebar) in Luabase. Host is ` Be sure to use port 8443 and check “Use a secure connection (SSL)”.

    Untitled

  3. Write some SQL, here’s an example to get you started

    select 
date_trunc('day', (block_timestamp))  as dt, 
count(1) as transactions
from ethereum.transactions as t
where t.block_timestamp >= '2022-01-01'
group by date_trunc('day', (block_timestamp)) 
order by date_trunc('day', (block_timestamp)) desc

    Untitled