⚡️ Lightdash

The open source Looker alternative

Website • Watch demo • Docs

Lightdash is a BI tool that is fully integrated with your dbt project, allowing you to define metrics alongside your data models.

Features

🙏 Familiar interface for your users to self-serve using pre-defined metrics
👩‍💻 Declare dimensions and metrics in yaml alongside your dbt project
🤖 Automatically creates dimensions from your dbt models
📖 All dbt descriptions synced for your users
📊 Simple data visualisations for your metrics
🚀 Share your work as a URL or export results to use in any other tool

You can also check out our future plans for the product in our roadmap.

1-click deploy

Deploy your own hosted Lightdash instance with Heroku (free account available).

Deploy for dbt projects on dbt cloud

Deploy for dbt projects on github

Get started

Start learning Lightdash:

Play with a UI demo (no setup)
Setup your own lightdash with demo data (run locally with docker)
Setup Lightdash with your existing local dbt project (requires your own dbt project)
Setup Lightdash with your existing cloud dbt project (requires your own dbt project on dbtCloud)

Community Support

Join our community if you need help, want to chat or have any other questions for us:

Discourse - Discussion forums and updates from the Lightdash team
Twitter - For all the latest Lightdash news

About Lightdash

Lightdash removes the gap between your data transformation layer and your data visualization layer. It enables data analysts and engineers to control all of their business intelligence (data transformations/business logic as well as data visualization) in a single place.

Lightdash integrates with your dbt project and gives a framework for defining metrics and specifying joins between models all within your existing dbt YAML files. The data output from your dbt project is then available for exploring and sharing in Lightdash.

No more scattered, duplicated metrics across multiple tools.
No more time spent trying to maintain data changes in both dbt and and your data viz tools.
No more context lost between your data transformation and your data visualization layer.

Run the demo

Get started with a demo dbt project and launch Lightdash on your machine:

git clone --recurse-submodules https://github.com/lightdash/lightdash
cd lightdash/examples/full-jaffle-shop-demo
docker compose up

Open lightdash at https://localhost:8080

Run with your own dbt project

You must be using dbt version 0.20.0 or above

BigQuery users should read the additional docs here

cd path/to/your/dbt/project # e.g. /Users/katie/my-project-repo/dbt

export DBT_PROJECT_DIR=${PWD}
export DBT_PROFILES_DIR=${HOME}/.dbt
export LIGHTDASH_PORT=8080

docker run -it -p "${LIGHTDASH_PORT}:8080" -v "${DBT_PROJECT_DIR}:/usr/app/dbt" -v "${DBT_PROFILES_DIR}:/usr/app/profiles" lightdash/lightdash

Open lightdash at https://localhost:8080

Installation from source

You can check the instructions in our contribution guidelines

Docs

Have a question about a feature? Or maybe fancy some light reading? Head on over to our Lightdash documentation to check out some tutorials, reference docs, FAQs and more.

Reporting bugs and feature requests

Want to report a bug or request a feature? Open an issue.

Contributors ✨

Thanks goes to these wonderful people (emoji key):

_{Rahul Jain} 📖	_{Oliver Laslett} 💻 📖 🐛 🎨	_{Katie Hindson} 🐛 📖 🎨 💻	_{Hamzah Chaudhary} 📖	_{Harry Grieve} 📖	_{Dominik Dorfmeister} 🎨	_amin-nejad 🐛
_{Mitja Potočin} 💻	_{Jose Rego} 💻 🎨 📖 🐛	_Rahul 🐛 🎨 💻 📖	_{Jeshua Maxey} 🐛	_{Sreejith Madhavan} 🐛	_skame 🐛 🎨	_sgoley 📖
_djayatillake 🎨	_Mukesh 🔣 🐛	_{Andreia Freitas} ⚠️ 📖