...
For more information on data quality, see Overview of Data Quality.
| name | description | ||
|---|---|---|---|
Unique | Column values must be unique. | ||
Implies | Source column values imply the values of a target column. For each unique source value, there should be exactly one implied target value. | ||
Not Missing | Column values must not be missing. Null values and empty strings are not allowed. | ||
Not Null | Column values must not be null. Empty strings are allowed. | ||
Valid | Column values must be valid instances of a data type. | ||
Match | Column values must match a pattern. | ||
Not Match | Column values must not match a pattern. | ||
Starts With | Column values must start with a pattern. | ||
Ends With | Column values must end with a pattern. | ||
Equal | Column values must equal a provided value. | ||
Not Equal | Column values must not equal a provided value. | ||
In Range | Column values must lie between provided minimum and maximum values. | ||
Greater Than | Column values must be greater than a minimum value. | ||
Less Than | Column values must be less than a maximum value. | ||
InRange | Column values must lie between provided minimum and maximum values. | In Set | Column values must be one of a set of acceptable values. |
Not In Set | Column values must not be one of a set of unacceptable values. | ||
Unique | Column values must be unique. | ||
Implies | Source column values imply the values of a target column. For each unique source value, there should be exactly one implied target value. | ||
Formula | Apply a custom data quality rule formula. |
