Composite unique¶
composite_unique - Column-level - Common column checks
Validates that combinations of columns are unique, e.g. (tenant_id, email).
Parameters¶
| Parameter | Type | Default | Required | Description |
|---|---|---|---|---|
columns |
list | none | Yes | List of column names (at least two). |
threshold_percent |
float | 0.0 |
No | Fail if the percentage of duplicate combinations exceeds this. |
max_duplicate_examples |
int | 10 |
No | Maximum number of duplicate examples to return in the details. |
YAML example¶
checks:
- name: example_composite_unique
check_type: composite_unique
table_name: schema.table
column_name: example_column
parameters:
columns: <columns>
threshold_percent: 0.0
max_duplicate_examples: 10
See YAML check format for the full field reference.