Validator overview
The Distinct Values validator ensures a column contains only distinct values or matches expected uniqueness. This validator is useful for ensuring primary key uniqueness, validating composite keys, or monitoring the cardinality of categorical field values over time. You can configure distinct values validators to monitor the following metrics:
The distinct values validator works similar to the Volume validator configured for the Unique Count or Unique Percentage metrics. For more information, see Volume validators. For an overview of all validator types, see Validator Types.
Metric configuration parameters
Field selection
For the distinct value metrics, you have to specify one or several fields. Specifying several fields means field values are concatenated before being counted, which is, for example, useful when validating uniqueness of composite keys.Null values: Validio includes
NULL values in the counts, unless you apply a NULL filter to remove them.