---
id: "metabase"
type: "component"
kind: "bi-service"
provider: "default"
category: "data"
docs: "https://www.metabase.com/docs/latest/permissions/row-and-column-security"
url: "https://localhost:3000/catalogue/components/metabase"
---

# Metabase

Open-source BI tool for questions, dashboards and SQL over connected databases.

| | |
|---|---|
| Provider | [default](https://localhost:3000/catalogue?provider=default) |
| Kind | [BI service](https://localhost:3000/catalogue/kinds/bi-service) |
| Category | Data |
| Official docs | [https://www.metabase.com/docs/latest/permissions/row-and-column-security](https://www.metabase.com/docs/latest/permissions/row-and-column-security) |

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `applicationDatabase` | enum | `h2`, `postgres`, `mysql` | no | "h2" | inherited |
| `capacityMode` | enum | `shared`, `dedicated` | no | — | inherited |
| `edition` | enum | `oss`, `pro`, `enterprise` | no | "oss" | inherited |
| `embeddedReports` | boolean | — | no | false | **false** |
| `managed` | boolean | — | no | false | **false** |
| `publicSharing` | boolean | — | no | — | **true** |
| `queryCaching` | boolean | — | no | false | inherited |
| `refreshesPerDay` | integer | — | no | — | inherited |
| `rowLevelSecurity` | boolean | — | no | — | **false** |

Bold values are the ones this component pins.

## Rules that apply · 0

No rule selects this kind or its category.

## Other products of the same kind · 25

- [Quick BI](https://localhost:3000/catalogue/components/alibaba-quick-bi.md) `alibaba-quick-bi` — alibabacloud
- [Amazon Quick Sight](https://localhost:3000/catalogue/components/aws-quicksight.md) `aws-quicksight` — aws
- [Power BI](https://localhost:3000/catalogue/components/azure-power-bi.md) `azure-power-bi` — azure
- [Power BI Embedded](https://localhost:3000/catalogue/components/azure-power-bi-embedded.md) `azure-power-bi-embedded` — azure
- [Amplitude](https://localhost:3000/catalogue/components/amplitude.md) `amplitude` — default
- [Generic BI service](https://localhost:3000/catalogue/components/bi-service.md) `bi-service` — default
- [Cube](https://localhost:3000/catalogue/components/cube.md) `cube` — default
- [Evidence](https://localhost:3000/catalogue/components/evidence.md) `evidence` — default
- [Kibana](https://localhost:3000/catalogue/components/kibana.md) `kibana` — default
- [Lightdash](https://localhost:3000/catalogue/components/lightdash.md) `lightdash` — default
- [Matomo](https://localhost:3000/catalogue/components/matomo.md) `matomo` — default
- [Mixpanel](https://localhost:3000/catalogue/components/mixpanel.md) `mixpanel` — default
- [PostHog](https://localhost:3000/catalogue/components/posthog.md) `posthog` — default
- [Power BI Report Server](https://localhost:3000/catalogue/components/power-bi-report-server.md) `power-bi-report-server` — default
- [Redash](https://localhost:3000/catalogue/components/redash.md) `redash` — default
- [Apache Superset](https://localhost:3000/catalogue/components/superset.md) `superset` — default
- [Tableau Server](https://localhost:3000/catalogue/components/tableau.md) `tableau` — default
- [Looker (Google Cloud core)](https://localhost:3000/catalogue/components/google-looker.md) `google-looker` — gcp
- [Data Studio (Looker Studio)](https://localhost:3000/catalogue/components/google-looker-studio.md) `google-looker-studio` — gcp
- [Cognos Dashboards Embedded](https://localhost:3000/catalogue/components/ibm-cognos-dashboards.md) `ibm-cognos-dashboards` — ibm
- [IBM watsonx BI](https://localhost:3000/catalogue/components/ibm-watsonx-bi.md) `ibm-watsonx-bi` — ibm
- [Oracle Analytics Cloud](https://localhost:3000/catalogue/components/oci-analytics-cloud.md) `oci-analytics-cloud` — oci
- [Oracle Fusion Data Intelligence](https://localhost:3000/catalogue/components/oci-fusion-data-intelligence.md) `oci-fusion-data-intelligence` — oci
- [OpenSearch Dashboards](https://localhost:3000/catalogue/components/oci-opensearch-dashboards.md) `oci-opensearch-dashboards` — oci
- [OCI Resource Analytics](https://localhost:3000/catalogue/components/oci-resource-analytics.md) `oci-resource-analytics` — oci

## Use it in a design

```yaml
nodes:
  - { id: "metabase", component: "metabase" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# Metabase: open-source BI tool for questions, dashboards and SQL over connected databases.
# "Public links": public sharing is enabled by default and admins turn it off in Settings.
# "Row and column security" (formerly data sandboxing) is a Pro/Enterprise feature that is not
# in the open-source edition and must be configured; the application database defaults to H2.
schemaVersion: "1"
type: "component"
id: "metabase"
kind: "bi-service"
provider: "default"
docs: "https://www.metabase.com/docs/latest/permissions/row-and-column-security"
defaults:
  managed: false
  publicSharing: true
  rowLevelSecurity: false
  embeddedReports: false
properties:
  edition:
    type: "enum"
    values: ["oss", "pro", "enterprise"]
    default: "oss"
  applicationDatabase:
    type: "enum"
    values: ["h2", "postgres", "mysql"]
    default: "h2"
  queryCaching:
    type: "boolean"
    default: false
```

Human page: https://localhost:3000/catalogue/components/metabase