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.