The open-source Looker alternative.

Website โ€ข Watch demo โ€ข Docs

Enable everybody in your company to answer their own questions using data

connect your dbt project –> add metrics into dbt –> share insights with your team

If you’re a fan, star the repo โญ๏ธ (we plant a tree for every GitHub star we get ๐ŸŒฑ).

Come join the team, we’re hiring.

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
  • ๐Ÿงฎ Table calculations make it easy to dig into your data, on the fly
  • ๐Ÿ•ต๏ธโ€โ™€๏ธ Lineage lets you see the upstream and downstream dependencies of a model
  • ๐Ÿ“Š Simple data visualisations for your metrics
  • ๐Ÿ‘ทโ€โ™‚๏ธ Save charts & build dashboards to share your insights with your team
  • ๐Ÿš€ Share your work as a URL or export results to use in any other tool

Something missing? Check out our open issues to see if what you’re looking for already exists (and give it a ๐Ÿ‘). Otherwise, we’d love it if you’d open a new issue with your request ๐Ÿ˜Š

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

Sign up to Lightdash Cloud

You can avoid the hassle of hosting and configuring Lightdash yourself byย signing up to the waitlist for Lightdash Cloud Beta . We’ll let you know once we’re ready to bring you on board ๐Ÿ™‚

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:

  • GitHub – 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

๐Ÿ—‚ Keep all of your business logic in one place.

We let you define your metrics and dimensions directly in your dbt project, keeping all of your business logic in one place and increasing the context around your analytics.

No more deciding which of the four different values for total revenue is the right one (you can thank us later ๐Ÿ˜‰).

๐Ÿค Build trust in your data.

We want everyone at your company to feel like they can trust the data. So, why not show them that they can?

We bring the context you want around data quality into your BI tool so people know that they can trust the data.

๐Ÿงฑ Give users meaningful building blocks to answer their own data questions.

With Lightdash, you can leave the SQL to the experts. We give your data team the tools they need to build metrics and dimensions that everyone else can use.

So, anybody in the business can combine, segment, and filter these metrics and dimensions to answer their own questions.

๐Ÿ“– Open source, now and forever

Lightdash is built with our community, for our community.

We think that a BI tool should be affordable, configurable, and secure – and being open source lets us be all three ๐Ÿ™‚

๐Ÿค‘ Affordable analytics

Love Looker, but don’t love Looker’s price tag?

With Lightdash, we offer a free self-hosted service (it’s all just open source!), or an affordable cloud-service option if you’re looking for an easy analytics set up.

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.

The Lightdash Forest

We’re planting trees with the help of the Lightdash community.

Tree planting is one of the simplest and most cost-effective means of mitigating climate change, by absorbing CO2 from the atmosphere. So we thought it would be pretty neat to grow a forest while we grow Lightdash.

Want to help us grow our forest?

Just star this repo! We plant a tree for every star we get on Github. โญ๏ธ โžก๏ธ ๐ŸŒฑ

We plant trees with TIST, you can read all about them here: https://program.tist.org/.

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๐Ÿ“– John Keech๐Ÿš‡ Dr. Ernie Prabhakar๐Ÿ› ๐Ÿค”
PriPatel๐ŸŽจ ๐Ÿ› NaomiJohnson๐ŸŽจ ๐Ÿ› Rich Shen๐Ÿ’ป โš ๏ธ ๐Ÿ› David Gasquez๐Ÿค” ๐ŸŽจ xjaner๐Ÿค” Chris Bol๐Ÿค” Anil V๐Ÿค”
rlebrao๐Ÿค” ๐Ÿ› philcarr-tsl๐Ÿ› ๐Ÿ”ฃ HashimsGitHub๐Ÿš‡ Nathalia Buitrago Jurado๐Ÿ“– ๐Ÿ’ป norbag๐Ÿ› Shrpp๐Ÿ› Cuong Vu๐Ÿ›
Takaaki Yoshikawa๐Ÿค” nkotlyarov๐Ÿ› kim monzon๐Ÿค” rverheijenโš ๏ธ ๐Ÿ› Spencer Carrucciu๐Ÿค” Mark Olliver๐Ÿ› gary-beautypie๐Ÿ›
Andrรฉ Claudino๐Ÿ’ป ๐Ÿš‡

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

GitHub

View Github