Now that you’ve connected your dbt project to Lightdash, it’s time to start exploring your data.
A Table is the main starting point for exploring data in Lightdash. It contains a group of related dbt models, dimensions, and metrics. You explore Tables in the Explore view.
To access the Explore view, you just need to go to Explore
—> Tables
-> then select the Table you want to explore.
The Explore view is really made up of 5 areas:
Go to Explore
—> Tables
—> then select the Table that you want to explore.
To run a query:
For example, if I wanted to know the “total number of orders split by order status”, I’d select the Unique order count
metric to calculate the number of orders and the Status
dimension to split that by status.
Click on the three-dot-menu by your column headers and select the sorting option that you want for a column.
You can have multiple sorts by adding more columns using their three-dot-menu. You can see the number of sorts applied just above your results table.
You can update and change the sorting using of your table by clicking on the sort
menu. Here, you have the option to:
Once the query executes, the results will show in the results table. You can then open the charts section and choose a chart type to visualise the metric.
You can read more about configuring your charts here.
Saved Charts allow you to save a specific chart or visualisation so you can share it or revisit it again in future.
When you open a saved chart, it will always update to display the latest data in your database.
To save a chart:
Saved charts
to see your finished work of art