Add Uniqueness Checks

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

2. Specify the column that is expected to hold only unique values.

3. Select one of the following methods for assessing uniqueness:

   • Duplicate Count: Determines the absolute number of duplicate entries found within the column.

   • Duplicate Percentage: Calculates the proportion of duplicate entries relative to the total number of values in the column.

4. Choose the appropriate comparison operator, typically = for count checks and <= for percentage checks.

5. Enter the threshold value.

   This is usually 0 for count checks, meaning any duplicates trigger an issue, or a small percentage, such as 0.1%, for percentage checks, allowing for minor deviations.

6. Click Save.