Add Custom Checks¶
In the Select Checks section while adding a monitor, select the Custom option as check category.
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.
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.
Choose from a range of operators:
=
,!=
,<
,>
,<=
,>=
,between
,not between
.Specify the acceptable threshold value or value range for the validation.
Provide a clear expression name and enter the SQL or CTE query as expression value.
Click Save.