Alert: SQL to Slack

Sending a well designed Slack alert is not only a good way to keep everyone in the loop, but also great to save the day when critical events happen in your data.

In Query.me Notebooks you can now base your Slack blocks on any amount of SQL-blocks, if statements and for loops, giving you complete control over when an Alert should be triggered and what it should contain.

How to use

1) Create or Edit the SQL-block in the Template:
Unless you want to send multiple messages, your SQL should be a LIMIT 1.
Every column returned by your query can become referenced data in your Slack message.

2) Create or Edit the IF statement in the Template.
Reference the column and set a condition that should trigger blocks inside your statement.
Feel free to combine IF and FOR, and also use more blocks, like Email, inside the statement.

3) Create or Edit the Slack-block in the Template:
Design your message and simply reference data using JINJA.
E.g.: {{ query_1.data()[0]['column_name']}}
Find out more about message styling and Slack's Block-kit-builder.

4) Don't have Slack webhook yet?
Simply follow the link on the bottom of the Slack-block to create one.

5) Test your design: Press play ▶️
Get immediate feedback on what your Slack message looks like.

Includes:

• A SQL-block that fetches a daily KPI summary (demo-data)
• A Parameter-block to define a threshold
• An IF-Statement to create a conditional execution
• A Slack-block that sends the Slack message displayed above

Pre-requisites:

• Slack Workspace