Skip to content

Unique check

unique - Column-level - Common column checks

Validates that a column's duplicate percentage stays within a threshold.

Parameters

Parameter Type Default Required Description
threshold_percent float 0.0 No Maximum allowed duplicate percentage. A value of 0.0 means all values must be unique.
max_duplicate_examples int 10 No Maximum number of duplicate examples to return in the details.

YAML example

checks:
  - name: example_unique
    check_type: unique
    table_name: schema.table
    column_name: example_column
    parameters:
      threshold_percent: 0.0
      max_duplicate_examples: 10

See YAML check format for the full field reference.