Lightdash

Lightdash is an open-source BI platform and Looker alternative for teams using dbt. It connects to a dbt project so teams can define metrics once, keep business logic with their dbt models, and let business users explore predefined metrics instead of writing SQL.

Metrics and dimensions are declared in YAML alongside dbt, with dimensions automatically created from dbt models and dbt descriptions and metadata synced into the BI interface. Users can build charts and dashboards, inspect underlying records, drill down, use table calculations, view model lineage, share by URL, schedule Slack or email deliveries, and roll back chart version history.

Lightdash is available as a free self-hosted service or as managed Lightdash Cloud. It can run locally with an installation script, deploy with one click on Render, or run in production on Kubernetes using community Helm charts.