Skip to content

Sign consistency

numeric_sign_consistency - Column-level - Numeric

Validates that every value in a numeric column has the expected sign.

Parameters

Parameter Type Default Required Description
allowed_sign str 'non_negative' No The sign every value is expected to have. One of: non_negative, non_positive, positive_only, negative_only, any.
threshold_percent float 0.0 No Fail if the percentage of rows with the wrong sign exceeds this.

YAML example

checks:
  - name: example_numeric_sign_consistency
    check_type: numeric_sign_consistency
    table_name: schema.table
    column_name: example_column
    parameters:
      allowed_sign: non_negative
      threshold_percent: 0.0

See YAML check format for the full field reference.