Lightdash appeared in 2021 as an open-source BI tool built specifically for dbt users. The founders — former Spotify and Typeform data professionals — saw that dbt had transformed how data teams build and manage transformations, but the last mile of analytics still required separate BI tools that couldn’t natively understand dbt’s semantic layer.
The platform connects directly to your dbt project and reads your models, metrics, and documentation. When an analyst explores data in Lightdash, they’re working with the same definitions that the data team maintains in code. Metrics defined in dbt YAML files show up automatically in the explore interface. Column descriptions, tags, and ownership information carry through without duplication.
The explore interface lets users build queries visually — select dimensions, pick metrics, add filters, and generate charts without writing SQL. Results can be saved as charts, organized in dashboards, or scheduled for email delivery. For users who want SQL, a raw query mode is available alongside the visual builder.
Lightdash runs as a self-hosted application or through their managed cloud service. The self-hosted option appeals to data teams at companies with strict data governance requirements — your BI tool runs inside your infrastructure, and query results never leave your network.
The project gained traction quickly in the dbt community because it solved a genuine pain point. Other BI tools could connect to dbt-generated tables but couldn’t leverage the semantic layer that dbt projects carefully maintain. Lightdash treats dbt as a first-class citizen rather than just another database connection. The open-source project has attracted thousands of GitHub stars and an active community of contributors building integrations, chart types, and deployment configurations.
