What is a Lookup metric?
Lookup metrics validate column values against a reference source — checking that every value in a target column corresponds to a valid entry in an authoritative reference. They are the primary tool for referential integrity checks outside of database constraints, and for validating against controlled vocabularies, master data tables, REST APIs, reference files, and dynamically-queried reference sets. Type: User-defined — Lookup metrics are created manually. Navigate to Metric → Add and select Subcategory: Lookup. Lookup metrics answer the question: Do the values in this column exist in the reference set they should come from? Prizm compares the target column values against the configured reference source on each run, computes a match rate, and trends it over time. Alerts fire when the match rate drops below the configured threshold or when new unseen values appear in the target column.Metrics
Setup
Step-by-step guide to creating and configuring a lookup metric.
Use Cases
Real-world examples — product catalog integrity, ISO code validation, cross-source customer ID checks.