Lightdash

Lightdash is an open-source, AI-enabled business intelligence platform designed for teams that use dbt as their transformation layer. It connects directly to your existing dbt project, allowing you to define metrics, dimensions, and business logic once in code and reuse them consistently across dashboards, reports, and ad-hoc analysis. By leveraging your dbt models and semantic layer, Lightdash reduces metric duplication, misalignment, and manual SQL work.

Core capabilities include interactive dashboards, drill-down analysis, self-serve exploration, and AI-assisted querying that helps users generate and refine questions in natural language. Lightdash supports version control, Git-based workflows, and environment management, so analytics logic can be reviewed, tested, and deployed alongside the rest of your data stack. Role-based access control, row-level security, and centralized metric definitions help maintain data governance and trust.