Skip to content

Range (no negative unless allowed, no extreme values)

money_range - Column-level - Money

Validates that a currency amount column stays within bounds, and is non-negative unless explicitly allowed.

Parameters

Parameter Type Default Required Description
min_value float none No Optional minimum allowed amount.
max_value float none No Optional maximum allowed amount.
allow_negative bool False No If false, fail when any value is negative.
threshold_percent float 0.0 No Fail if the percentage of violations exceeds this.

YAML example

checks:
  - name: example_money_range
    check_type: money_range
    table_name: schema.table
    column_name: example_column
    parameters:
      allow_negative: false
      threshold_percent: 0.0

See YAML check format for the full field reference.