BI & Analytics connector
The Metabase data catalog your whole team can trust.
The Dawiso Metabase connector turns your instance into a searchable data catalog: every collection, question, dashboard and model, with lineage to the database below.
First things first
What is a data connector?
A data connector is the bridge between a tool in your stack and the catalog that gives you a unified view of it. Once a connector is configured, it reaches into the source system on a schedule, reads out the metadata - schemas, tables, dashboards, jobs, ownership, lineage - and represents it inside the catalog. Your actual rows and values stay where they are.
Connectors are the reason a data catalog can answer questions like "which Power BI dashboard depends on this Snowflake table?" or "who owns the orders topic in Kafka?" - automatically, without anyone keeping a spreadsheet up to date.
Three properties separate a good connector from a brittle one: it should be read-only and safe, it should be incremental so a full re-scan isn't required for every refresh, and it should resolve lineage across system boundaries, not just inside one tool.
About the platform
What is Metabase?
Metabase is the open source business intelligence tool used by 90,000+ companies. Built in Clojure with a TypeScript front-end, it ships as a self-hosted Docker image or as Metabase Cloud, and lets non-engineers build questions, dashboards and models on top of any SQL database.
Metabase has lightweight catalog features inside the app. What it does not have is cross-platform lineage, a business glossary, ownership workflows, or a single search across Metabase, Power BI and the warehouse. That's where the Dawiso Metabase data catalog joins the picture: read-only, metadata-only, and cross-platform.
Architecture
How Dawiso connects to Metabase
A small read-only role on the Metabase side. The Dawiso scanner pulls metadata on a schedule. Everything ends up in your catalog, business-readable.
Source
Metabase (self-hosted or Cloud)
- Collections & sub-collections
- Questions & models
- Dashboards & cards
- Registered databases
Dawiso scanner
Read-only metadata
- Schema & object discovery
- Dependency resolution
- SQL flow parsing (optional)
- Sampling on opt-in
Catalog
Dawiso platform
- Searchable metadata
- Lineage & ownership
- Business glossary
- Policy & classifications
Connection details
- Protocol
- Metabase REST API
- Authentication
- API key (recommended) or service-user credentials
- Lineage
- Question-to-dashboard-to-source-database relationships resolved from Metabase metadata (object-level data lineage)
Setup
Connect Metabase in 4 steps
- 01
Create a service user
In Metabase Admin Settings > People, invite a service user (e.g. Dawiso Reader). Add it to a dedicated group such as DawisoGroup. Save the password if no email is configured.
- 02
Grant collection view permissions
In Permissions > Collection permissions, give the group View access to every collection you want catalogued. For full lineage, the Administrators group works too.
- 03
Generate an API key (recommended)
Under Settings > Authentication > API Keys, create a key (e.g. DawisoKey) and assign it to the service-user group. Copy the key; it is shown once.
- 04
Connect in Dawiso
Add the Metabase server URL (self-hosted or metabaseapp.com), choose API key or credentials, list the collections to ingest, and run scheduled ingestion.
Capabilities
What you get with the Metabase connector
-
Question & dashboard catalog
Every question, dashboard and model across every collection is searchable, with owners, source database and the SQL that powers each question.
-
Object-level data lineage
Trace any Metabase dashboard card through its question to the Postgres, MySQL or BigQuery database that feeds it.
-
Model & SQL library
Centralize Metabase models and reusable SQL so the same revenue definition is not rewritten as a saved question in five different collections.
-
Usage & adoption
See which dashboards get opened, which gather dust, and who the power users are. Retire what nobody opens with evidence.
-
Ownership & certification
Mark questions and dashboards as certified, deprecated or under review. The owner is visible directly in the catalog alongside Metabase permissions.
-
Self-hosted or Cloud
One connector for Metabase Cloud and self-hosted Docker, so an open source stack ends up in the same governed catalog as Snowflake.
Business value
Why teams turn on the Metabase connector
- −65%
Fewer duplicate questions
Analysts find the certified question in Dawiso instead of rewriting the same SQL into a new saved question in another collection.
- 10×
Faster impact analysis
Before altering a source table, see exactly which Metabase questions, dashboards and models depend on it. Seconds, not days.
- Open source
Catalog without lock-in
Dawiso catalogs Metabase the same way it catalogs Snowflake or Power BI, so an open source BI choice does not become a governance gap.
Ready to catalog your Metabase?
Set up the connector in an afternoon. See your first lineage graph the same day.
Frequently asked questions
Does Metabase have a data catalog?
What is a data catalog used for?
What permissions does Dawiso need in Metabase?
Does Dawiso copy Metabase data?
Self-hosted Metabase or Metabase Cloud?
API key or username and password?
Explore more connectors
Metabase is one of 30+ connectors. Bring your whole stack into the catalog.
-
Data Warehouse Snowflake -
Data Lakehouse Databricks -
Business Intelligence Power BI -
Business Intelligence Tableau -
Data Warehouse Google BigQuery -
Data Warehouse Amazon Redshift