At a glance
| Database connectors | BigQuery, PostgreSQL, Redshift, Snowflake, Databricks, Trino, ClickHouse, DuckDB (MotherDuck or DuckLake), Athena; others through Trino |
| Dashboards | Dashboards of charts built on dbt-defined metrics |
| Reporting | Scheduled reports and alerting (Cloud Pro) |
| Embedding | iframe and React SDK, paid add-on (per load or per embed worker) |
| Semantic layer or modeling | Metrics and dimensions in dbt YAML or standalone Lightdash YAML |
| Deployment | Self-hosted (Kubernetes and Helm, PostgreSQL, S3-compatible storage) or Lightdash Cloud (EU or North America) |
| Licensing | MIT core; enterprise directory under a separate licence; licence key for self-hosted enterprise features |
Lightdash fits analytics teams whose models and metrics already live in dbt and who want BI that reuses those definitions instead of a second semantic layer. Self-hosting is free but needs Kubernetes, PostgreSQL and object storage; the managed Cloud Pro plan is a flat USD 3,000 a month, so it is priced for teams rather than individuals.
Overview
Lightdash is a BI application that reads a semantic layer from your project: dimensions, metrics, joins, descriptions and access rules defined alongside dbt models, or in standalone Lightdash YAML pointed at a warehouse. Users explore those metrics, build charts and dashboards, and schedule deliveries; analysts can also query in SQL. The README describes this governed layer as a "context layer".
Its licence file places the code under MIT, except the packages/backend/src/ee directory, which has its own enterprise licence. The self-hosting guide uses Kubernetes with Helm, a PostgreSQL database for Lightdash metadata (separate from your warehouse) and S3-compatible object storage; a headless browser for image exports is optional. Lightdash Cloud is the managed option.
Key features
- Dimensions and metrics defined in dbt model YAML (or standalone Lightdash YAML) and exposed for exploration
- Joins, descriptions, caching and access rules defined in the same governed layer
- Charts and dashboards built from the explore interface, plus SQL querying
- Scheduled reports and alerting (listed on Cloud Pro)
- Embedding through iframe and a React SDK, sold as an add-on
- AI agents and an MCP server listed on Cloud Pro
Pros and cons
Pros
- Reuses dbt models and metric definitions instead of a second modelling layer
- Permissive MIT licence for the core
- Cloud Pro includes unlimited users at a flat monthly price
- Free self-hosted edition with the core BI features
Cons
- Most value assumes a dbt project or equivalent YAML definitions
- Self-hosting needs Kubernetes, PostgreSQL and object storage
- Cloud Pro at USD 3,000 a month is a significant floor for small teams; SSO, SAML and SCIM are listed on Enterprise
- Embedding is a separately priced add-on
Pricing
The open source edition is free to self-host with core BI features and community Slack support; enterprise features on self-hosted deployments need a licence key. Listed on Lightdash's pricing page (USD symbol shown): Cloud Pro USD 3,000 per month with unlimited users, hosted in the EU or North America; Enterprise custom, cloud or on premises. Embedding is an add-on: first 1,000 loads free then USD 0.05 per load, or USD 790 per month for 100k loads per embed worker. A 21-day free trial starts when you first connect and compile a dbt project.
Pricing checked on the vendor's official page on 7 November 2026. Prices change; confirm before buying.
Who it is best for
Analytics engineering teams that model data in dbt and want governed self-service BI on top of the same definitions.
Who should look elsewhere
- Teams without dbt or a modelling workflow who want quick dashboards on raw tables: see the best open source BI tools.
Verdict
Lightdash is a strong match for dbt-centred teams, because metrics are defined once next to the models and reused in BI. Outside that workflow it has less to offer, and both self-hosting effort and the Cloud Pro price floor should be weighed against simpler tools.
Frequently asked questions
Does Lightdash require dbt?
It is designed around dbt: metrics and dimensions are usually defined in dbt model YAML. The README also describes defining them in standalone Lightdash YAML pointed at your warehouse.
Is Lightdash open source?
The core is under the MIT licence. Code in the packages/backend/src/ee directory has a separate enterprise licence, and enterprise features on self-hosted deployments need a licence key.
How much does Lightdash Cloud cost?
Lightdash lists Cloud Pro at USD 3,000 per month with unlimited users and custom-priced Enterprise (November 2026). Self-hosting the open source edition is free.
Sources
- Lightdash pricing
- Lightdash on GitHub
- Lightdash licence
- Lightdash: self-hosting
- Lightdash: connecting a project
Checked November 2026.
How we research reviews and what star ratings mean: our editorial method.