Lightdash instantly turns your dbt project into a full-stack BI platform.

Welcome to Lightdash

Lightdash

Welcome to Lightdash! We're going to try to get you developing, exploring or just browsing your data in no time.

Overview

Getting started

AI Analyst

Adding and managing Tables

How to create dimensions

How to create metrics

Learn how to add joins to your YAML files to connect different models to each other.

How to join tables

Formatting your fields

Using Filters

Interacting with your dashboards

Filtering a Dashboard in the URL

Lightdash allows you to embed your dashboards using expirable URLs and tokens (embed URLs from now on). This is a great way to enable self-serve analytics in your own application and platform by leveraging the insights you've got in Lightdash and making them available to your own users.

How to embed content

Pinning

Add the Slack integration

Use the Slack integration

Scheduled deliveries let you send a dashboard or saved chart, and their results to people via email or Slack - even to people who don't have an account in your Lightdash instance.

Scheduled deliveries

Alerts enable you to receive notifications via email or Slack when the value of a saved chart meets your specified conditions.

Alerts

How to set up Lightdash YAML validation for VS Code

You can roll back to previous versions of charts in Lightdash. In case you make a mistake or simply want to go back to a previous version of a chart you built, you can easily revert back to previous versions of your charts. It's a great way to keep track of changes and revert back to previous versions if needed.

Chart Version History

With Lightdash, you can have a single organization (e.g. Lightdash), and multiple projects within that organization (e.g. Production, Jaffle Shop, etc.)

Creating multiple projects

You can update the default colours used in your organization's charts so that everything you build is on brand.

Customizing the appearance of your project

Promoting content enables you to copy content from one project to another. It's especially useful when working with preview or development projects. You can promote charts created in your development projects to production, so it's easy to test and make changes without the fear of breaking things in production.

How to promote content

Spotlight is a suite of features designed to put Metrics front and center. It simplifies data exploration, making it easy for business users to focus on metrics without dealing with complex tables or time dimensions.

Spotlight

Reference docs are broken down into the categories below.

Lightdash Reference Docs

The Lightdash CLI is the recommended way to develop your Lightdash project. It makes development faster and easier, as well as giving you options for building more powerful automation to manage your Lightdash projects.

Lightdash CLI reference

You can embed Lightdash content in your website or application securely using Lightdash embedding.

Embedding

SCIM Integration

Self-Host Lightdash

Lightdash is open-source and licensed under the MIT license. This means that you are free to self-host Lightdash on your own infrastructure but without any warranty or support from the Lightdash team.

Lightdash Cloud vs. Self-Hosted

Self-host Lightdash using docker compose

Self-Host Lightdash with Restack

Updating Lightdash to the latest version

FAQs

There are a few ways you can get in touch with the team. Here's which one to use depending on your situation:

Contact Us

Introduction

Lightdash API (0.1411.0)

These routes allow users to manage their own user account.

My Account

GetAuthenticatedUser

RegisterUser

Create a new one-time passcode for the current user's primary email.
The user will receive an email with the passcode.

CreateEmailOneTimePasscode

Get the verification status for the current user's primary email

GetEmailVerificationStatus

List the organizations that the current user can join.
This is based on the user's primary email domain and the organization's allowed email domains.

ListMyAvailableOrganizations

Add the current user to an organization that accepts users with a verified email domain.
This will fail if the organization email domain does not match the user's primary email domain.

JoinOrganization

DeleteMe

createWarehouseCredentials

updateWarehouseCredentials

deleteWarehouseCredentials

getLoginOptions

Rotate personal access token

Each user is a member of a single organization. These routes allow users to manage their organization. Most actions are only available to admin users.

Organizations

GetMyOrganization

Creates a new organization, the current user becomes the Admin of the new organization.
This is only available to users that are not already in an organization.

CreateOrganization

UpdateMyOrganization

Deletes an organization and all users inside that organization

DeleteMyOrganization

Gets all projects of the current user's organization

ListOrganizationProjects

Gets all the members of the current user's organization

ListOrganizationMembers

Get the member profile for a user in the current user's organization by uuid

GetOrganizationMemberByUuid

Deletes a user from the current user's organization

DeleteOrganizationMember

Gets the allowed email domains for the current user's organization

ListOrganizationEmailDomains

Updates the allowed email domains for the current user's organization

UpdateOrganizationEmailDomains

Gets all the groups in the current user's organization

ListGroupsInOrganization

Creates a new group in the current user's organization

CreateGroupInOrganization

Projects belong to a single organization. These routes allow users to manage their projects, browse content, and execute queries. Users inside an organization might have access to a project from an organization-level role or they might be granted access to a project directly.

Projects

GetExplores

SetExplores

GetExplore

CompileQuery

DownloadCsvFromExplore

GetProject

ListChartsInProject

ListChartSummariesInProject `Deprecated` 

ListChartSummariesInProject

ListSpacesInProject

GetProjectAccessList

Calculate all metric totals from a metricQuery

CalculateTotalFromQuery

getUserWarehouseCredentialsPreference

updateUserWarehouseCredentialsPreference

getCustomMetrics

Update project metadata like upstreamProjectUuid
we don't trigger a compile, so not for updating warehouse or credentials

updateProjectMetadata

deleteProjectSemanticLayerConnection

updateProjectSemanticLayerConnection

getDashboards

createDashboard

updateDashboards

createPreview

getTags

createTag

deleteTag

updateTag

getChartsAsCode

getDashboardsAsCode

upsertChartAsCode

upsertDashboardAsCode

Get validation results for a project. This will return the results of the latest validation job.

GetLatestValidationResults

Validate content inside a project. This will start a validation job and return the job id.

Validation jobs scan all charts and dashboards inside a project to find any broken references
to metrics or dimensions that aren't available. Results are available after the job is completed.

ValidateProject

DeleteValidationDismiss

CreateSpaceInProject

DeleteSpace

Updates the membership profile for a user in the current user's organization

UpdateOrganizationMember

Get access list for a project. This is a list of users that have been explictly granted access to the project.
There may be other users that have access to the project via their organization membership.

Get a project explicit member's access.
There may be users that have access to the project via their organization membership.

NOTE:
We don't use the API on the frontend. Instead, we can call the API
so that we make sure of the user's access to the project.

GetProjectMemberAccess

RevokeProjectAccessForUser

GrantProjectAccessToUser

UpdateSpace

AddSpaceUserAccess

RevokeSpaceAccessForUser

AddSpaceGroupAccess

RevokeGroupSpaceAccess

getCatalog

getMetadata

getAnalytics

getAnalyticsField

getMetricsCatalog

getMetric

getMetricsWithTimeDimensions

Get dimensions that can be used to segment metrics

getSegmentDimensions

addCategoryToCatalogItem

removeCategoryFromCatalogItem

updateCatalogItemIcon

getMetricsTree

createMetricsTreeEdge

deleteMetricsTreeEdge

createComment

getComments

deleteComment

resolveComment

getCsvUrl

Promote dashboard to its upstream project

promoteDashboard

promoteDashboardDiff

Install the Lightdash GitHub App and link to an organization

installGithubAppForOrganization

Callback URL for GitHub App Authorization also used for GitHub App Installation with combined Authorization

Getting started tutorials

Guides

References

Self-hosting

Welcome to Lightdash