Missing CSV file in email of report / alert about superset HOT 1 OPEN

It looks like the issue with the missing CSV file in email reports/alerts from Apache Superset might be related to the handling of attachments in the email sending process. Here are a few areas to investigate:

1. CSV Data Generation: Ensure that the CSV content is being generated correctly. The issue might arise if self._content.csv is empty or not set, which would prevent the attachment from being included in the email.

2. Email Sending Function: The problem could be in how the send_email_smtp function processes attachments. It's called with files=[] and data=content.data, where data should contain the CSV content. If the function doesn't handle this parameter as expected, the attachment might not be added to the email.

3. Configuration and Logging: Check your Apache Superset and SMTP server configurations for any settings that might affect email attachments. Additionally, enabling more detailed logging in Apache Superset can provide insights. Adjust the logging level to DEBUG to capture detailed information about the email sending process, which could help identify why the CSV file isn't being attached.

To enable detailed logging, adjust the LOG_LEVEL to DEBUG in the Superset configuration file. This will increase log verbosity, providing more information on the email sending process and attachment handling. Be mindful that debug logging can generate a lot of data, so it's best used temporarily for troubleshooting.

These steps should help you narrow down the cause of the issue and find a resolution. If you discover any new details or errors in the logs, sharing those could provide further clues for troubleshooting.

To continue the conversation, mention @dosu.

from superset.