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.

Lightdash

What is Lightdash?

Categories & Use Cases