Overview

The SQL Condition monitor is very closely related to the No-Code Condition monitor. It lets you write a condition as a SQL query. Use it when the flexibility of the No-Code Condition monitor is not enough.

How to Use

1. Datasets & Joins

See Datasets & Joins in the No-Code Condition documentation.

2. SQL Query

The SQL query is the condition. It must return a boolean per row. A true value means that the condition fails.

⚠️
To insert fields inside this query, fields must use the special formatting: datasetId:fieldName.
In the UI, you can use the autocompletion to insert fields with this format. To trigger it, start typing the name of your table, and Sifflet lists the fields of that table.

⚠️
You cannot query other tables inside the SQL query. Use only the tables selected in the join clause defined earlier.

Examples:

datasetId:email IS NOT NULL
datasetId1:field1 + datasetId2:field2 < 10

3. Other Settings

See Advanced Monitoring Features in the No-Code Condition documentation.