Add Validity Checks

1. In the Select Checks section while adding a monitor, select the Validity option as check category.

2. Select the column you intend to validate.

3. Choose a validation method:

   • Invalid Count: Determines the number of values that do not meet the validation criteria.

   • Invalid Percentage: Calculates the proportion of values failing validation.

4. Configure parameters for format and value:

   • For format validations, specify the regular expression pattern.

   • For value validations, define the set of permitted values.

5. Set the comparison operator (usually = for count checks, or <= for percentage checks) and threshold (typically 0 for counts or a small percentage).

6. Customize the message that appears when the check fails.

7. Click Add Config to further customize the check.

8. Select a property:

   • Invalid Format: Validates against the defined invalid format.

   • Invalid Regex: Validates against the defined invalid regex pattern.

   • Invalid Values: Validates against the defined invalid values.

   • Valid Format: Validates against a format.

   • Valid Length: Validates against a defined length.

   • Valid Max Length: Validates against a maximum defined length.

   • Valid Min Length: Validates against a minimum defined length.

   • Valid Regex: Validates against a regex pattern.

   • Valid Values: Validates against a list of allowed values.

9. Click Save.