Lightdash (BI on dbt metrics)
Lightdash is an open-source business-intelligence tool that turns dbt models and their metric definitions into explorable dashboards, so metrics live in version-controlled code rather than the BI tool. This page describes its data model and privacy posture even-handedly, without ranking it against other BI tools.
What this means
Lightdash reads a dbt project and exposes its models, dimensions, and metric definitions as an explorable BI catalog, so the metrics in dashboards come from version-controlled dbt code rather than ad-hoc tool settings.
This keeps metric definitions reviewable and reusable, aligning the BI layer with the transformation layer.
Data model and posture
The model is dbt-centric: dimensions and metrics declared in dbt drive what Lightdash can explore, and queries run against the warehouse the dbt project targets.
Because it queries that warehouse, access is governed by warehouse grants, and the open-source nature lets teams self-host. Privacy posture depends on warehouse permissions and deployment choices rather than a vendor default.
- BI built from dbt models and metrics
- Metric definitions live in version control
- Queries run in the dbt-target warehouse
- Open-source, self-hostable
How it appears in analytics and logs
Lightdash in a stack means dimensions and metrics defined in dbt drive the BI layer, so dashboard definitions are version-controlled and queries run in the warehouse dbt targets.
Diagnostic use case
Use Lightdash when you want BI dashboards defined from your dbt project, so metric logic stays in code review and the same definitions power exploration.
What WebmasterID can help detect
WebmasterID event data modeled in dbt can be surfaced in Lightdash; the BI layer is downstream of both collection and warehouse modeling.
Common mistakes
- Defining metrics in the BI tool instead of dbt, losing version control.
- Assuming Lightdash stores data rather than querying the warehouse.
- Ignoring warehouse grants when sharing dashboards.
Privacy and accuracy notes
Lightdash queries the warehouse dbt builds on, so warehouse grants govern access to underlying data. This is educational, not legal advice.
Related pages
- Evidence (code-based BI reports)
Evidence is an open-source business-intelligence framework where reports are written as Markdown files containing SQL queries and templated charts, then built into a static data application. It treats BI as version-controlled code. This page describes its data model and privacy posture even-handedly, without ranking it against other BI tools.
- dbt and the analytics stack
dbt (data build tool) is a transformation framework that runs SQL SELECT statements as version-controlled models inside your data warehouse, turning raw loaded tables into clean, documented, tested datasets. It handles the 'T' in ELT — it does not move data in or visualize it. It adds software-engineering practices (testing, lineage, docs) to analytics SQL.
- Metabase open-source BI
Metabase is an open-source business-intelligence tool that connects to databases and warehouses, letting users build questions, dashboards, and charts without necessarily writing SQL. It is self-hostable, with a managed cloud option. This page describes its data model and privacy posture even-handedly, without ranking it against other BI tools.
- WebmasterID docs
Event data you can model in dbt and explore in BI.
Sources and verification notes
- Lightdash — DocumentationOpen-source BI docs on dbt-driven metrics and self-hosting.
Last reviewed 2026-06-24. Facts are checked against primary/official sources where available; uncertain specifics are marked “Data not yet verified” rather than guessed.