Row-Level Checks¶
Row-level checks validate each record individually. If a row fails a check, it is marked as invalid and annotated with failure context.
| Check | Description |
|---|---|
| Column Less Than | Values in one column are less than another column or expression. |
| Column Greater Than | Values in one column are greater than another column or expression. |
| Date Between | Date values fall within a defined range. |
| Date Max | Date values do not exceed a defined maximum. |
| Date Min | Date values are not below a defined minimum. |
| Exactly One Not Null | Exactly one of the specified columns is non-null per row. |
| Is Contained In | Column values are within a predefined set of allowed values. |
| Is Not Contained In | Column values are not within a set of forbidden values. |
| Not Null | Column contains at least one non-null value. |
| Null Check | Column contains no null values. |
| Numeric Between | Numeric values fall within a defined range. |
| Numeric Max | Numeric values do not exceed a defined maximum. |
| Numeric Min | Numeric values are not below a defined minimum. |
| Timestamp Between | Timestamp values fall within a defined range. |
| Timestamp Max | Timestamp values do not exceed a defined maximum. |
| Timestamp Min | Timestamp values are not below a defined minimum. |
| Regex Match | String values match a given regular expression. |
| String Length Between | String lengths fall within a defined range. |
| String Max Length | String values do not exceed a maximum length. |
| String Min Length | String values meet a minimum length requirement. |