Skip to content

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.