Skip to content

Boolean implies other field

boolean_consistency - Column-level - Boolean

Validates that a required column is non-null whenever a boolean column has a given value.

Parameters

Parameter Type Default Required Description
boolean_column str none No The boolean column to check. Defaults to the check's own column.
when_value bool False No The value that triggers the requirement: true, false, 1, or 0.
then_column_required str none Yes Column that must be non-null when boolean_column equals when_value.
threshold_percent float 0.0 No Fail if the percentage of violating rows exceeds this.

YAML example

checks:
  - name: example_boolean_consistency
    check_type: boolean_consistency
    table_name: schema.table
    column_name: example_column
    parameters:
      when_value: false
      then_column_required: <then_column_required>
      threshold_percent: 0.0

See YAML check format for the full field reference.