Setup

Creating a standalone query metric

Add the metric

Navigate to Metric in the top navigation.
Click the Add button (⊕).
Enter a Metric Name.
Select Subcategory: Standalone Query from the dropdown.
Enter a Purpose description.
Click Create.

Open the configuration view

Click the metric name to open its detail page. The configuration view exposes:

Data Source — the connection to execute the query against
Domain / Product — the organizational grouping this metric belongs to
Metadata tabs — Description, Purpose, Rationale
Standalone Query Configuration — SQL editor, schedule settings, and rule options
Threshold
Semantic context and Owners

Set the data source and metadata

Data Source: Select the data source connection this metric will execute against. Because Standalone Query metrics are not bound to a specific asset, you select a data source directly rather than a table.Fill in the metadata tabs as needed:

Tab	Content
Description	What this metric measures. Prizm AI can suggest a description based on the metric name.
Purpose	Business justification — why this metric exists and who it serves.
Rationale	The reasoning behind the SQL query and schedule chosen.

Write the SQL query and set the schedule (Configuration tab)

The Configuration tab contains the SQL editor and the run schedule.

Writing the query

Write a SQL SELECT statement that returns a single numeric value. The query may reference multiple tables or schemas — Standalone Query metrics are not restricted to a single asset.

-- Example: revenue reconciliation across two sources
SELECT ABS(a.total - b.total) / b.total AS discrepancy_rate
FROM (
  SELECT SUM(amount) AS total
  FROM warehouse.transactions
  WHERE date = CURRENT_DATE - 1
) a,
(
  SELECT SUM(revenue) AS total
  FROM reporting.daily_revenue
  WHERE date = CURRENT_DATE - 1
) b

Run schedule

Set when the query executes. Standalone Query metrics run on this schedule independently of any asset job.

Option	Description
Daily	Run once every day at a specified time
Weekly	Run once per week on a specified day and time
Custom cron	Enter a cron expression for flexible scheduling

Rule options

Option	Description
Valid	Treat the result as the signal to evaluate
Scoring	Include this metric in the domain quality score
Weightage%	Relative weight of this metric in the overall score (default 100)
Pass Criteria	The threshold condition the result must satisfy to pass
Export	Include metric results in data exports

Click Validate to execute the query against current data and preview the returned value.

Set the threshold

Choose how Prizm determines when to raise an alert on the query result:Automated Threshold — Prizm learns statistical baselines from historical run values and alerts when the result deviates by a configurable number of standard deviations:

Priority	Deviation range	Default
Low	0σ – 1σ	Off — within expected variation
Medium	1σ – 2σ	Off — monitor for drift
High	2σ – 3σ	On — investigation recommended
Critical	≥ 3σ	On — immediate action required

Custom Threshold — Set explicit upper and/or lower bounds on the query result to trigger alerts.

Set semantic context and owners

Scroll down past the Threshold section to complete:

Semantic context: Assign Domain, Application, Product, Tag, and Dimension to place the metric in the correct domain grouping within the Prizm catalog.
Owners: Set Business owner, Technical owner, and Steward.
Audience: Restrict who can view this metric’s results.

Click Save Changes when done.

Get Started

Core Concepts

Platform

Architecture

Data Sources

Integrations

Security & Access Control

Deployment

Help

Settings

MCP

Release Notes

API Reference

Creating a standalone query metric

Writing the query

Run schedule

Rule options

​Creating a standalone query metric

​Writing the query

​Run schedule

​Rule options

Creating a standalone query metric

Writing the query

Run schedule

Rule options