Skip to content

No future dates

date_no_future - Column-level - Date and time

Validates that a date or datetime column has no dates after now.

Parameters

Parameter Type Default Required Description
include_time bool True No If true, compare as a timestamp. If false, compare as a date only.
threshold_percent float 0.0 No Fail if the percentage of future values exceeds this.

YAML example

checks:
  - name: example_date_no_future
    check_type: date_no_future
    table_name: schema.table
    column_name: example_column
    parameters:
      include_time: true
      threshold_percent: 0.0

See YAML check format for the full field reference.