/lightdash

An open source alternative to Looker built using dbt. Made for analysts ❤️

Primary LanguageTypeScriptMIT LicenseMIT

The open source Looker alternative


WebsiteWatch demoDocs

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.

Demo

Play with our demo app!

Quick start

1-click deploy

Deploy your own hosted Lightdash instance with Heroku (free account available). Check the documentation page for more details.

Deploy

Run locally

Take advantage of our installation script to easily run Lightdash locally. Check the documentation page for more details.

git clone https://github.com/lightdash/lightdash
cd lightdash
./install.sh 

Getting started

Step 1 - ⚡️ Install Lightdash

Step 2 - 🔌 Connect a project

Step 3 - 👩‍💻 Create your first metric

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
  • Slack - Join the conversation! Get all the latest updates and chat to the devs

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.

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

⚠️ 📖

jb

💻 🐛 🎨

Amy Chen

📖

This project follows the all-contributors specification. Contributions of any kind welcome!