[Apache Superset] Topic #5, Automated Alerts and Reporting via Slack/Email in Superset

ngtduc693

Duc Nguyen Thanh

Posted on October 10, 2024

[Apache Superset] Topic #5, Automated Alerts and Reporting via Slack/Email in Superset

Hello,
I'm Duc Nguyen (Duke) and I'm back

If you have not read the previous articles, please read it before practicing this one.

Topic #1, What is Apache Superset used for and how to install it on Windows 11
Topic #2, Superset ARCHITECTURE
Topic #3, Visualization data from CSV data file
Topic #4, Integrate 2D/3D maps into Superset

Today I will show you how to integrate automatic reporting and alerts to Email or Slack in Superset

Need to send a notification to Slack? You need Slack Bot API Token in this case
First, go here and create a new app. After successfully creating your app you can see like image below

Slack App

then you must set the configuration as shown below

Slack App 2

After you deploy it to your app, you will have Bot Token then access the following file and fill the bot token in this key (if you don't have this key, create it)

superset\docker\pythonpath_dev\superset_config.py
Enter fullscreen mode Exit fullscreen mode

Alert

Besides that, you must set the feature flags

ALERT_REPORTS = True
Enter fullscreen mode Exit fullscreen mode

Need to send a notification to Email?

First, you must set the feature flags

ALERT_REPORTS = True
Enter fullscreen mode Exit fullscreen mode

and then, please provide the SMTP host, port, SSL (if any), user, password in the configuration file

superset\docker\pythonpath_dev\superset_config.py
Enter fullscreen mode Exit fullscreen mode
SMTP_HOST =
SMTP_PORT =
SMTP_STARTTLS = True
SMTP_SSL_SERVER_AUTH = True/False
SMTP_SSL = True/False
SMTP_USER = 
SMTP_PASSWORD = 
SMTP_MAIL_FROM =
EMAIL_REPORTS_SUBJECT_PREFIX = 
Enter fullscreen mode Exit fullscreen mode

If you are unclear about anything, please leave a comment and wait for the next topic in the Apache Superset tutorial section.

💖 💪 🙅 🚩
ngtduc693
Duc Nguyen Thanh

Posted on October 10, 2024

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related