Skip to content

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.