Add Custom Checks

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

  2. Specify the check type:

    • SQL Check: Utilize for validations that involve a single SQL query.

    • CTE Check: Employ for validations requiring multiple steps and Common Table Expressions.

  3. Compose a query considering the following points:

    • The query must return a single numerical result.

    • Always use fully qualified table names (e.g., <schema>.<table>).

    • Ensure correct column referencing.

  4. Choose from a range of operators: =, !=, <, >, <=, >=, between, not between.

  5. Specify the acceptable threshold value or value range for the validation.

  6. Provide a clear expression name and enter the SQL or CTE query as expression value.

  7. Click Save.