Data type rules

Rule	Rule type	Description
Empty Check	EMPTYCHECK	Identifies records where the target column contains an explicit empty string (''). A rule break occurs when the column value is equal to the empty string.
Null Check	NULLCHECK	Identifies records where the target column contains an explicit NULL value. A rule break occurs when the column value is explicitly NULL.
Date Check	DATECHECK	Checks if the column value can be successfully parsed into a recognized date format. A rule break occurs if the value is not of this data format.
Integer Check	INTCHECK	Checks if the column value can be successfully parsed and cast as an integer. A rule break occurs if the value is not of this data format.
Double Check	DOUBLECHECK	Checks if the column value can be successfully parsed and cast as a double (floating point) number. A rule break occurs if the value is not of this data format.
String Check	STRINGCHECK	Checks the underlying data to confirm compatibility with the expected string type. A rule break occurs if the value is not of this data format.
Mixed Datatype Check	DATATYPECHECK	Identifies the most frequent datatype in the column (for example, String or Integer). It then reports the fraction of rows that do not match this dominant type, helping you quickly spot data inconsistencies and unexpected type mixing. Note Mixed datatype rules are not supported in Pushdown.

Empty Check

EMPTYCHECK

Identifies records where the target column contains an explicit empty string (''). A rule break occurs when the column value is equal to the empty string.

Null Check

NULLCHECK

Identifies records where the target column contains an explicit NULL value. A rule break occurs when the column value is explicitly NULL.

Date Check

DATECHECK

Checks if the column value can be successfully parsed into a recognized date format. A rule break occurs if the value is not of this data format.

Integer Check

INTCHECK

Checks if the column value can be successfully parsed and cast as an integer. A rule break occurs if the value is not of this data format.

Double Check

DOUBLECHECK

Checks if the column value can be successfully parsed and cast as a double (floating point) number. A rule break occurs if the value is not of this data format.

String Check

STRINGCHECK

Checks the underlying data to confirm compatibility with the expected string type. A rule break occurs if the value is not of this data format.

Mixed Datatype Check

DATATYPECHECK

Identifies the most frequent datatype in the column (for example, String or Integer). It then reports the fraction of rows that do not match this dominant type, helping you quickly spot data inconsistencies and unexpected type mixing.

Note Mixed datatype rules are not supported in Pushdown.