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

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

Dashboards

Filters

Dashboard filters

SQL parameters

Embedding Metabase: Setting up customer-facing analytics - YouTube

Metabot

  • No longer supported

minusx.ai | AI Data Scientist