Create one
On the alerts page for your warehouse, click Create alert.- Name and describe the alert so the notification says something useful when it fires.
- Write the SQL, or describe what you want in plain language and let Paradime draft it for you. The draft lands in the editor, where you can read and change it before saving. The left pane lists the tables and columns the built-in alerts read; clicking one inserts it at your cursor.
- Test alert runs the query immediately and shows whether it would fire, along with sample rows, so you are not waiting for a schedule to find out you had a typo.
- Choose how often it repeats: daily while true keeps reminding you each day the condition holds, once until it resets tells you once and stays quiet until the condition clears.
- Pick destinations: a Slack channel, a Microsoft Teams webhook, or email, the same way Bolt notifications are configured.
The rule is simply: any row the query returns is a violation. Write the query so it returns nothing when everything is fine, and returns the offending rows when it is not.