platform / explore

Answers for everyone, without waiting on SQL.

Explore is the analysis area for the tables your team has modelled. Pick a table, choose dimensions and metrics, and get a chart, or write SQL when you want to. Everything uses your governed definitions.

request-demo read-the-docs

explore — marts.revenue_daily

# 1. pick a table, dimensions and metrics
table     revenue_daily
group by  channel, week
measure   revenue
filter    order_date in the last 90 days

Will process 1.2 GB
✔ chart saved · added to dashboard

trusted by data teams at

camino/financial

✓ Enterprise-ready. Already trusted by multiple Fortune 100 companies.

see it

Pick a table, choose fields, get a chart

Dimensions and metrics come from your dbt code, so every chart uses the same definitions. The query size is shown before you run.

explore — revenue_daily

table

revenue_daily

dimensions

channelweekcountrydevice

metrics

revenueordersconversion rate

filters

order_date · last 90 days

Will process 1.2 GBRun query

ResultsChartSQL

Share of revenue by channel and week

Save chartAdd to dashboard

// illustrative

what you get

Explore, in detail

self-serve.md

Self-serve analysis

Choose a table, group by dimensions, measure metrics, add filters and run. No SQL required.

governed.md

Governed by your dbt code

Dimensions and metrics come from your dbt YAML, so a metric means the same thing for everyone.

charts-dashboards.md

Charts and dashboards

Turn any result into a chart, save it and place it on a dashboard organised into spaces.

sql-runner.md

SQL runner and virtual views

Write SQL against your tables, chart the result, or save it as a virtual view that appears in Explore as a table.

query-size.md

Know the cost before you run

Explore shows how much data a query will process, and a per-project cap stops oversized queries.

auto-updates.md

Always up to date

When a dbt run succeeds, new and changed models appear in Explore automatically. One login, no separate sign-in.

how it works

From setup to answers

01 /

Enable

An admin enables Explore once per project. It checks your warehouse connection and loads your dbt models.

02 /

Explore

Pick a table, dimensions, metrics and filters, then run the query.

03 /

Chart

Switch to a chart, adjust it and save it.

04 /

Place charts on dashboards, grouped in spaces, for your team.

roles

The right access for every person

viewers.md

Viewers

Open dashboards and saved charts.

editors.md

Editors

Explore data and build charts and dashboards.

admins.md

Admins

Build and manage content, and set up Explore and its limits.

faq

Frequently asked questions

Do I need to write SQL?

No. You can pick a table, dimensions and metrics and filter, then run. If you prefer SQL, the SQL runner lets you write it and chart the result.

Where do the metrics and dimensions come from?

From your dbt YAML in Build, the semantic layer. That is why they mean the same thing for everyone, and why the AI agent gives the same answers.

What is a virtual view?

A saved SQL query that appears in Explore as a table. It exists only inside Explore and stores the query, not the data. For anything your team depends on, create a dbt model instead.

Can I control query cost?

Yes. Explore shows the data a query will process before you run it. Each project has a largest-query limit, 10 GB by default, and oversized queries are blocked.

Can I create my own metrics?

Yes, for your own exploration. To make one permanent and shared, add it to the model in Build.

Does it work with other BI tools?

Yes. The same tables work with any BI tool. Explore is built to make the most of your semantic layer.