lightdash/lightdash
Lightdash
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.
Features
- AI-Powered Data Assistants - Provides conversational AI agents for querying data and building dashboards without writing SQL.
- Natural Language Querying Interfaces - Translates plain-language questions into structured queries using a semantic layer and large language model.
- Business Metrics - Allows data teams to define business metrics and dimensions in YAML files to centralize analytics logic.
- Natural Language to SQL - Allows users to query the data warehouse using natural language through AI agents in the UI or Slack.
- Data Visualization Dashboards - Enables creation of interactive dashboards and data applications from a centralized semantic model with AI assistance.
- dbt Model Importers - Synchronizes dbt models and metrics across the analytics stack using a shared context layer.
- SQL-Based Semantic Layer - Centralizes metric and dimension definitions so queries retrieve consistent, governed data without direct SQL access.
- YAML Metric Definitions - Allows data teams to define business metrics and dimensions in YAML files for version-controlled analytics logic.
- Metric & Dimension Definitions - Centralizes metric and dimension definitions as version-controlled YAML files for governed analytics.
- BI Content Pipelines - Automates validation and deployment of analytics changes through version-controlled pipelines and preview environments.
- Analytics as Code Workflows - Treats business intelligence changes as code with version control and CI/CD pipelines.
- BI Content Pipelines - Treats business intelligence changes as code with version control, CI/CD pipelines, and preview environments.
- Dashboard Access Controls - Embeds dashboards into external applications and controls data access with roles, permissions, and row-level security.
- Role-Based Access Control - Enforces data visibility restrictions using roles, permissions, and row-level security rules at the semantic layer.
- Data Explorers - Enables users to explore data by filtering, segmenting, and drilling into predefined metrics without writing SQL.
- Embedded Analytics - Provides an SDK to embed dashboards and charts into external web applications.
- Scheduled Report Deliveries - Sends automated data exports to Slack or email on a configurable schedule.
- Data Lineage - Maintains central definitions for data assets and traces queries back to official sources with full version history.
- Preview Environments - Creates temporary, isolated analytics environments for reviewing BI changes before merging to production.
- Dashboard Sharing - Creates interactive visualizations from defined metrics and distributes them via URLs, scheduled Slack messages, or email.
- Dashboard Embedding - Provides an SDK for embedding interactive dashboards into external web applications.
- Business Intelligence - Open source analytics built on dbt.
- Metrics Stores - Metrics layer for BI.
- Instrumente pentru dezvoltatori - Open source Looker alternative with deep dbt integration.
