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.