Date within range (min/max)¶
date_range - Column-level - Date and time
Validates that a date or datetime column's values fall within an expected range.
Parameters¶
| Parameter | Type | Default | Required | Description |
|---|---|---|---|---|
min_date |
str | none | No | Optional minimum allowed date (inclusive), ISO format YYYY-MM-DD. |
max_date |
str | none | No | Optional maximum allowed date (inclusive), ISO format YYYY-MM-DD. |
threshold_percent |
float | 0.0 |
No | Fail if the percentage of out-of-range values exceeds this. |
YAML example¶
checks:
- name: example_date_range
check_type: date_range
table_name: schema.table
column_name: example_column
parameters:
threshold_percent: 0.0
See YAML check format for the full field reference.