Row-Level Checks

Row-Level Checks#

Check

Description

Column Less Than Check

Ensures that values in one column are less than another column or expression result.

Column Greater Than Check

Ensures that values in one column are greater than another column or expression result.

Date Between

Ensures that date column values are within a defined range.

Date Max

Ensures that date column values are less than a defined maximum date.

Date Min

Ensures that date column values are greater than a defined minimum date.

Exactly One Not Null Check

Validates that exactly one of the specified columns is non-null per row.

Is Contained In

Ensures that column values are contained within a predefined set of allowed values.

Is Not Contained In

Ensures that column values are not contained within a set of forbidden values.

Not Null Check

Checks whether the specified column contains at least one non-null value.

Null Check

Verifies whether a given column contains any null values.

Numeric Between

Ensures that numeric column values are within a defined inclusive range.

Numeric Max

Ensures that numeric column values are less than a defined maximum.

Numeric Min

Ensures that numeric column values are greater than a defined minimum.

Timestamp Between

Ensures that timestamp column values are within a defined inclusive range between a minimum and maximum timestamp.

Timestamp Max

Ensures that timestamp column values are less than a defined maximum timestamp.

Timestamp Min

Ensures that timestamp column values are greater than a defined timestamp.

Regex Match Check

Validates that string values match a given regular expression pattern.

String Length Between Check

Checks that string lengths fall within a specified range.

String Max Length Check

Ensures that string values do not exceed a maximum length.

String Min Length Check

Validates that string values in a column meet a minimum length requirement.