Lightdash
What is Lightdash?
Lightdash is an open-source Business Intelligence (BI) and Semantic Layer platform designed for modern data engineering and analytics teams. The platform turns data warehouse models—defined either via dbt projects or native YAML configuration—into a governed metric layer powering visual dashboards, conversational AI agents, custom data applications, and embedded analytics.
Key Capabilities
- BI as Code Workflow: Enables teams to define metrics, dimensions, joins, and dashboards in code repository files, allowing analytics updates to be previewed via command-line interface (CLI), validated in CI/CD pipelines, and reviewed in pull requests.
- dbt & Native Context Layer: Integrates natively with dbt semantics and standalone YAML schemas, defining centralized business metrics, row-level access permissions, and query caching policies once across the organization.
- Conversational Analytics & AI Agents: Deploys conversational agents that query the governed context layer rather than generating raw table guesses, preserving metric definitions and returning inspectable SQL execution paths.
- Embedded Analytics SDK: Provides a client SDK supporting customer-facing application embedding with configurable user attributes, row-level security (RLS), and tenant isolation.
- Developer Tools & Protocols: Supports local and pipeline development through the Lightdash CLI, Model Context Protocol (MCP) servers, and Git integrations.
Audience & Use Cases
- Audience: Analytics engineers, data platform engineers, business intelligence developers, and data-driven business users.
- Use Case: Codifying business metrics alongside dbt models, delivering self-service BI dashboards, embedding customer-facing analytics into SaaS products, and providing AI agents with governed SQL query paths.
Technical Specifications
- Supported Data Warehouses: Snowflake, Google BigQuery, Amazon Redshift, Databricks, PostgreSQL, Trino, and ClickHouse.
- Technology Stack: TypeScript monorepo utilizing React, Mantine, Vite, Node.js, Express, Knex, and PostgreSQL.
- Deployment Options: Managed Lightdash Cloud SaaS or self-hosted container deployments via Docker and Helm/Kubernetes.
- Vendor Claims: According to the vendor, Lightdash enables analytics teams to manage BI assets with software engineering workflows (Git, CI, and PRs) while serving self-service dashboards and AI query agents.
Categories & Use Cases
Technical Details
| Mobile Application | No |
|---|
FAQs
What is Lightdash?
Lightdash is an open-source Business Intelligence (BI) and Semantic Layer platform designed for modern data engineering and analytics teams. The platform turns data warehouse models—defined either via dbt projects or native YAML configuration—into a governed metric layer powering visual dashboards, conversational AI agents, custom data applications, and embedded analytics.