Start ≤ end (two columns)

date_order - Column-level - Date and time

Validates that one date column is never later than another, e.g. start_date before end_date.

Parameters

Parameter	Type	Default	Required	Description
start_column	str	none	No	Column that must be earlier or equal. Defaults to the check's own column.
end_column	str	none	Yes	Column that must be later or equal.
allow_equal	bool	True	No	If true, start equal to end is valid. If false, start must be strictly before end.
threshold_percent	float	0.0	No	Fail if the percentage of rows violating the order exceeds this.

YAML example

checks:
  - name: example_date_order
    check_type: date_order
    table_name: schema.table
    column_name: example_column
    parameters:
      end_column: <end_column>
      allow_equal: true
      threshold_percent: 0.0

See YAML check format for the full field reference.