✨ Lightdash Flashcards
Open-source BI built on dbt — explore metrics from your SQL models
💡 What is Lightdash?
An open-source BI tool that reads your dbt project and lets you explore, visualize, and share metrics straight from your models.
🧱 dbt-Native
Connects directly to your dbt repo; treats dbt models as semantic building blocks for charts, dashboards, and metrics.
📊 Metrics Layer
Define metrics (e.g., revenue, active_users) once in dbt and reuse them consistently across reports.
🔎 Explorer
Drag-and-drop dimensions and measures to build ad-hoc queries without writing SQL.
🧪 Semantic Validations
Respects dbt tests and lineage; surfaces errors so broken models don’t quietly propagate to dashboards.
🗂️ Spaces & Dashboards
Organize content into spaces, build dashboards with filters, tiles, and drill-through to details.
🔄 Schedules & Alerts
Schedule dashboard deliveries to Slack/Email and set alerts on thresholds or metric changes.
🔐 Permissions
Project-level roles, space permissions, and content ownership keep analytics governed and safe.
⚙️ Warehouse Support
Works with the same warehouses your dbt uses (Snowflake, BigQuery, Redshift, Postgres, Databricks, etc.).
🧭 Lineage & Docs
Leverages dbt docs and lineage to show where each metric comes from and how it’s built.
🚀 Deployment
Self-host via Docker/K8s or use Lightdash Cloud; Git-backed projects fit neatly into CI/CD workflows.
🎯 Common Use Cases
Self-serve BI for product and ops teams, KPI dashboards, revenue analytics, cohort and funnel exploration.