Overview

Sifflet Field Uniqueness Monitor Template is a field-level validation monitor. It checks if the monitored field contains duplicate values and fails if any duplicates are found.

As Code

Monitor Kind: FieldUniqueness
This monitor is used to ensure that values in a specified field are unique.

field:

parameters:
  kind: FieldUniqueness
  field: CUSTOMER_ID

Filtering and grouping

Field uniqueness Monitors allow for filtering and grouping parameters.

parameters:
  kind: FieldUniqueness
  field: CUSTOMER_ID
  whereStatement: NOT invalid
  groupBy:
    field: REGION

Time Window (Beta)

📘

Beta

Field uniqueness Monitors now allow time window parameters.

Threshold Settings (Beta)

📘

Beta

Field uniqueness Monitors now allow threshold configuration.