Skip to content

Range (min/max)

numeric_range - Column-level - Numeric

Validates that a numeric column's values fall within expected bounds.

Parameters

Parameter Type Default Required Description
min_value float none No Optional minimum allowed value (inclusive).
max_value float none No Optional maximum allowed value (inclusive).
non_negative bool False No If true, fail when any value is negative (equivalent to min_value=0).
threshold_percent float 0.0 No Fail if the percentage of out-of-range values exceeds this.

YAML example

checks:
  - name: example_numeric_range
    check_type: numeric_range
    table_name: schema.table
    column_name: example_column
    parameters:
      non_negative: false
      threshold_percent: 0.0

See YAML check format for the full field reference.