Lightdash is an open-source business intelligence platform that treats analytics logic as code. It centralizes metric and dimension definitions in a semantic layer, allowing data teams to define business metrics in YAML files version-controlled alongside data models. This approach ensures consistent, governed data access without requiring users to write SQL.
Lightdash introduces CI/CD workflows for BI content, enabling teams to validate, test, and deploy analytics changes through automated pipelines and isolated preview environments. Its natural language query interface allows users to ask questions in plain English, translated into structured queries via AI agents. The platform also provides an embeddable analytics SDK for integrating dashboards into external applications, and enforces role-based access control with row-level security.
Beyond these differentiators, Lightdash supports building interactive dashboards and data applications from the centralized semantic model, self-service metric exploration with filtering and drill-down, scheduled report delivery to Slack or email, and full data lineage tracking. It integrates deeply with dbt to synchronize models and metrics across the analytics stack.