Create a Reveal
Build and run your first query in Discover — select a reveal, add fields, set the grain, filter, and see results against your warehouse
Time: About 10 minutes.
You'll need: A workspace with at least one reveal and an active warehouse connection.
Role: Tracer, Weaver, or Luminary (the editor needs the
run_discover permission).In this tutorial you'll open the Discover editor, pick a reveal as your starting point, choose the fields you care about, set how time is bucketed, add a filter, and click Run to render your first result. Because the query is built from your semantic layer, it automatically respects your Data Keys, Data Gates, and role permissions — you never have to scope it by hand.
Before you start
- Confirm you have the Tracer, Weaver, or Luminary role. See User roles.
- Make sure your workspace has at least one Reveal. If none exist, the FieldPanel shows a "No reveals yet" prompt linking you to Forge.
- The reveal's project needs an active warehouse connection. See Warehouses.
- Skim the Discover reference so the three working areas — FieldPanel, action bar, and results — are familiar.
Steps
Open Discover and pick a reveal
Click Discover in the left navigation to open the reveal picker at /discover, then choose a reveal. The editor navigates to /discover/:domain/:reveal and loads that reveal's fields. You can switch reveals any time from the REVEAL selector at the top of the FieldPanel.
Add fields
In the FieldPanel, click a field to add it to the query. Attributes (blue A badge) become grouping columns; metrics (green M badge) become aggregated values. Use Search fields… to filter the list, or the All Fields / In Use toggle to see only what you've selected. On a selected metric you can change the aggregation (SUM, COUNT, COUNT DIST, AVG, MIN, MAX) from the inline picker.
Set the grain
If you added a time field (amber D badge), use the grain pills — Day, Week, Month, Quarter, Year — to choose how time is bucketed. If a field group fixes the grain, the pills are disabled and labelled "set by field group".
Add a filter (optional)
Open the Filters bar and click Add filter. Choose a field, an operator (operators adapt to the field type — text, number, or date), and a value. Date filters support relative ranges like "is in the last 7 days" as well as explicit ranges. You can also set Compare to here to add a previous-period comparison.
Run the query
Click Run. The button stays disabled until you have at least one field and no invalid filter. The row count and duration appear in the action bar, and a Cached badge shows when results came from cache.
Result
The Results tab shows your data as a chart or formatted table, and the action bar reports the row count and query time. Switch to the SQL tab to see the exact, read-only SQL Celiq compiled from your CML. Your query state is captured in the URL as a query ID, so a refresh restores your work and the link is shareable.
If Run stays greyed out, you need at least one field selected, and any open filter must have a complete operator and value.
Next steps
- Style the result you just produced in Configure a Visualization.
- Let Celiq recommend the right chart in Use the Smart Chart Picker.
- Pin your query to a dashboard in Build Your First Mosaic.
- Save the query as a reusable, governed Prism.