Skip to main content

Metabase

Metabase is an open source business intelligence tool. It lets you ask questions about your data, and displays answers in formats that make sense, whether that's a bar graph or a detailed table.

Your questions can be saved for later, making it easy to come back to them, or you can group questions into great looking dashboards. Metabase also makes it easy to share questions and dashboards with the rest of your team.

docker run -p 3000:3000 --name metabase metabase/metabase

https://www.metabase.com/docs/latest/users-guide/01-what-is-metabase.html

https://www.metabase.com/docs/latest/getting-started.html

https://www.metabase.com/learn

https://github.com/metabase/metabase

Joins in Metabase

Embedding​

Embedding overview

Types​

Demo​

Metabase | See what’s possible with embedded analytics

Parameters for signed embeds​

Parameters are pieces of information that are passed between Metabase and your website via the embedding URL. You can use parameters to specify how Metabase items should look and behave inside the iframe on your website.

Types of parameters​

Parameters can be signed or unsigned.

Signed parameters, such as filter names and values, must be added to your server code.

Unsigned parameters, such as appearance settings, should be added directly to your iframe’s src attribute.

Parameters for signed embeds

Plugins / Tools​

# clickhouse

export METABASE_DOCKER_VERSION=v0.47.2
export METABASE_CLICKHOUSE_DRIVER_VERSION=1.2.2

mkdir -p mb/plugins && cd mb

curl -L -o plugins/ch.jar https://github.com/ClickHouse/metabase-clickhouse-driver/releases/download/$METABASE_CLICKHOUSE_DRIVER_VERSION/clickhouse.metabase-driver.jar

docker run -d -p 3000:3000 \
  --mount type=bind,source=$PWD/plugins/ch.jar,destination=/plugins/clickhouse.jar --network="host" \
  metabase/metabase:$METABASE_DOCKER_VERSION

Metabase has no built-in DuckDB support, but a community driver (duckdb.metabase-driver.jar) exists — drop it into the Metabase plugins directory, restart, then point a new database connection at the local .db file path. See DuckDB § PostgreSQL Integration for a pattern that syncs Postgres (e.g. RDS) into DuckDB nightly and serves Metabase off of that.

GitHub - nobuyo/metastasis: DaC(Dashboard as Code) for Metabase. ⭐ 5

Dashboards​

Filters​

Agents​