Overview

The Sifflet Duplicates monitor template is a field-level validation monitor. It checks for duplicate values in the monitored field and reports the number of occurrences where duplicates are found.

As Code

Monitor Kind: FieldDuplicates
This monitor detects and reports duplicate values in a specified field.

field:
The field to check for duplicate values.

parameters:
  kind: FieldDuplicates
  field: CUSTOMER_ID

Filtering and Grouping

Duplicates monitors allow filtering and grouping parameters.

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

Time Window (Beta)

📘

Beta

Duplicates monitors allow time window parameters.

Threshold Settings (Beta)

📘

Beta

Duplicates monitors allow threshold configuration.