DEV Community

Cover image for [Apache Superset] Topic #5, Automated Alerts and Reporting via Slack/Email in Superset
Duc Nguyen Thanh
Duc Nguyen Thanh

Posted on

4

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

👋 While you are here

Reinvent your career. Join DEV.

It takes one minute and is worth it for your career.

Get started

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay