Valid date/time (no Feb 30, etc.)¶
date_valid - Column-level - Date and time
Validates that a date or datetime column contains only genuinely valid dates.
Parameters¶
| Parameter | Type | Default | Required | Description |
|---|---|---|---|---|
check_time |
bool | False |
No | If true, also validate the time component. |
threshold_percent |
float | 0.0 |
No | Fail if the percentage of invalid values exceeds this. |
YAML example¶
checks:
- name: example_date_valid
check_type: date_valid
table_name: schema.table
column_name: example_column
parameters:
check_time: false
threshold_percent: 0.0
See YAML check format for the full field reference.