Explore overview
Explore is where you analyse the tables your team has modelled, without writing SQL unless you want to. It’s built on Lightdash, so its own documentation covers the finer points of charts and dashboards.
Turning it on
Section titled “Turning it on”An admin presses Enable Explore once per project. This checks the BigQuery connection and loads your dbt models. You need committed dbt code first (see Build). After that, Explore keeps itself up to date: every time a run of your committed code succeeds, new and changed models appear.
You don’t sign in again; Explore uses your platform login.
Keeping Explore up to date with dbt
Section titled “Keeping Explore up to date with dbt”Explore’s list of tables, dimensions and metrics comes from your committed dbt code. It refreshes by itself after every successful dbt run on committed code: scheduled runs, and manual runs started with Committed code. Runs on the Working copy, failed runs and commits alone don’t refresh it.
Data is different: Explore reads BigQuery live, so new rows appear as soon as dbt has written them, with no refresh.
To refresh the models right now (for example after committing a new model and running it), editors and admins press ↻ Refresh models at the top of Explore. It rebuilds from your latest committed code and reopens Explore.
Home and the top bar
Section titled “Home and the top bar”Explore’s home page opens with two buttons: Build a chart (pick a table, choose dimensions and metrics) and Run SQL query (the SQL runner, with the size shown before it runs). The top bar follows the platform’s light or dark theme. Lightdash’s own announcements, “Learn more” buttons and notification bell are hidden, because the platform has its own place for news and help.
Working in Explore
Section titled “Working in Explore”- Pick a table (one of your models).
- Choose dimensions (things to group by, like country or date) and metrics (numbers, like users or revenue). They come from your dbt models’ YAML, so they mean the same thing for everyone.
- Add filters, sort, and press Run query.
- Switch to a chart, adjust it, and Save chart. Put saved charts on a dashboard, organised in spaces.
You can also create custom dimensions and metrics on the fly. They’re yours to explore with; to make one permanent and shared, add it to the model in Build.
What your role allows
Section titled “What your role allows”Account admins can build and manage content; editors can explore and build charts and dashboards; viewers can open dashboards and saved charts. The exact permissions follow your platform role, see Permissions.
The size of every query
Section titled “The size of every query”Next to Run query you’ll see how much data a query would process, before you run it. See Query size and limits.