Lightdash - An open source alternative to Looker built using dbt. Made for analysts

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.

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}? ?