[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

then you must set the configuration as shown below

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

Besides that, you must set the feature flags

ALERT_REPORTS = True

Need to send a notification to Email?

First, you must set the feature flags

ALERT_REPORTS = True

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

superset\docker\pythonpath_dev\superset_config.py

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 = 

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