KPI Summary: SQL to Slack

Slack messages loaded with SQL data are maybe the number one low-hanging fruit of the Industry. These short messages make sure that everyone stays aware of recent trends and never fail to create discussions around data. Get started with this template and have a Slack message ready in a matter of minutes.

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 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.

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

4) 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 Slack-block that sends the Slack message displayed above

Pre-requisites:

• Slack Workspace