Add Completeness Checks

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

  2. Specify the column to be assessed for data completeness.

  3. Choose the desired type of check:

    • Missing Count: Determines the total number of NULL values within the column.

    • Missing Percentage: Calculates the percentage of NULL values present in the column.

  4. Select a suitable comparison operator (e.g., <= or =) for the threshold.

  5. Set the threshold to 0 if the selected column is expected to have no missing values or define a threshold percentage to indicate the acceptable level of NULL values.

  6. Click Add Config to further customize the check.

    • Select a property: Missing Values or Missing Regex and enter a value.

  7. Click Save.