Documentation sections

Measure

Turn workspace data into live dashboards

Dashboards are AI-authored single TSX views that run pinned, read-only queries against a workspace Data connection. People view and filter the result in the app; permitted managers review drafts, publish revisions, and restore history.

Last reviewed July 14, 2026

In the app Measure → Dashboards

Problems this solves

Start with the recurring problem, then use this feature when its boundary matches the outcome you need.

Problem

Stop rebuilding the same report by hand

An operator repeatedly exports data and rebuilds weekly pipeline, support, or operations summaries.

How this helps

Publish a Dashboard whose pinned read-only queries calculate the same measures from live MotherDuck data whenever it is opened or filtered.

Problem

Give viewers stability while a revision is reviewed

A new query or visualization needs validation without changing the report everyone already relies on.

How this helps

Keep the published revision stable while managers preview a draft, validate it against source data, and publish or roll back deliberately.

Problem

Answer a decision question without granting write access

A team needs a focused view of warehouse data but should not edit the underlying database or arbitrary SQL in the app.

How this helps

Use AI-authored, parameterized, read-only queries with declared filters and a least-privilege Data connection.

Dashboard definitions are AI-authored.

The app does not provide a general-purpose chart or SQL editor. Ask an authorized AI client to create and revise dashboard components, filters, and queries. Use the app to run, preview, publish, organize, roll back, and delete them.

Prepare a data source

  1. Add a MotherDuck token under Measure → Data connections.
  2. Connect an AI with Measure Build and approve the Measure/Dashboards surface.
  3. Tell the AI which Data connection and business question to use.
  4. Ask it to inspect the available schema before proposing queries or charts.

Ask for a useful first draft

Describe the decision, audience, measures, dimensions, and filters instead of naming only a chart type:

Create a weekly support dashboard using the Support warehouse connection.
Show opened, resolved, and backlog counts; median time to resolution;
and backlog by priority. Add a date-range filter. Create a draft only.

SolidActions validates dashboard queries as read-only before accepting the definition. A dashboard can use a default Data connection and, when explicitly authored that way, a different valid workspace connection for an individual query.

Review the draft

  1. Open a dashboard marked draft or choose Preview draft for unpublished edits.
  2. Exercise every filter and check that labels, units, empty states, and time ranges are unambiguous.
  3. Compare a few values to the source system before relying on the dashboard.
  4. Ask the AI for a narrow correction when a query or presentation is wrong.
  5. Select Publish when the revision is ready for viewers.

Filters are passed only to declared query parameters. Changing a filter reruns the relevant pinned queries after a short debounce; it does not rewrite the dashboard.

Published, draft, and historical views

Published
The stable revision workspace viewers open by default.
Draft preview
The latest unpublished edits, available to people who can manage Dashboards.
Past version
A read-only historical revision. Rollback can make it the published revision viewers see.

Rollback changes the published pointer; it does not replace the newer editable head, which can remain as an unpublished draft. Version history identifies who created each revision and whether it changed the rendered component or only metadata and queries. Publishing and rollback do not erase older revisions.

Permissions and sharing

Measure Read can view published Dashboards in the app. Measure Use can authorize the hosted MCP product area, while Measure Build is required for schema inspection, code and query changes, preview management, publishing, and rollback. Dashboards are shared through workspace membership; there is no public or guest Dashboard link.

Current query limits

Each pinned query returns at most 10,000 rows and runs for at most 30 seconds. A workspace can issue 120 Dashboard queries per minute, and one Dashboard can pin up to 50 queries. Keep aggregation in SQL and return only the rows the view needs.

Organize and recover dashboards

Use folders to group dashboards by team or decision area. Delete moves a dashboard to Trash, where a manager can restore it. Permanent deletion from Trash is irreversible; restore first when you are uncertain.

When a dashboard fails

  • Confirm its Data connection still exists and reports an active state.
  • Check that the connected MotherDuck identity can still read the referenced schemas and tables.
  • Reset filters to their defaults and retry.
  • Ask the AI to inspect schema drift and update the draft; do not publish until the preview succeeds.

Next: manage the underlying Data connection.