Deploy a BI Layer Straight from Your dbt Project

If you've ever built a data transformation pipeline with dbt, you know the drill: you model your data, test it, document it... and then you hand it off. Someone else, usually in a BI tool, rebuilds the logic you just perfected to create charts and dashboards. It creates a frustrating gap between the single source of truth you built and the metrics stakeholders actually see.

What if you could skip that last, messy handoff? What if your dbt project could directly become a live BI layer, where the metrics you define in YAML automatically turn into a shareable analytics interface? That's the promise of Lightdash.

What It Does

Lightdash is an open-source BI platform that connects directly to your dbt project. It reads your dbt models, your schema.yml files, and your metric definitions, and turns them into a live, web-based analytics tool. Essentially, it adds a visualization and exploration layer on top of your dbt core, without requiring you to redefine your business logic.

You define metrics (like total_revenue, weekly_active_users) alongside your dbt models using simple YAML. Lightdash picks those up and makes them available as dimensions and measures in a no-code UI where your team can build charts, dashboards, and run ad-hoc queries.

Why It's Cool

The magic here is in the tight integration. This isn't just another BI tool with a dbt connector. It's built around the dbt workflow.

• Metrics are Defined in Code: Your metrics live in your dbt YAML files, next to your table definitions. They're version-controlled, tested, and documented alongside your models. No more "which dashboard is using the correct revenue formula?"
• Self-Serve, But Governed: Analytics engineers and data developers set up the trusted data models and core metrics. Business users can then explore and build dashboards from that curated foundation, without writing SQL or risking incorrect joins.
• It's Just SQL: Lightdash generates and runs SQL directly on your data warehouse (it supports Snowflake, BigQuery, Redshift, etc.). There's no intermediary processing layer, so performance is predictable and you're using the compute you already pay for.
• Open Source & Extensible: You can host it yourself, customize it, and see exactly how it works. The community is active, and it feels like a tool built for the modern data stack, not just bolted onto it.

How to Try It

The fastest way to see Lightdash in action is to use their cloud offering. You can connect a sample dbt project or your own in a few clicks.

1. Go to