'I want to be notified by email of error messages when executing Snowflake tasks
I would like to ask how to notify the error message when executing a task by e-mail.
As a premise, I know that notification is possible using AWS (S3 and Lambda, SNS). But is there a way to notify emails with Snowflake's default features?
Thank you for your confirmation.
Solution 1:[1]
Snowflake does not have this mechanism by default. But to achieve this, you can use any of the following suggestions:
- Write a JAVA stored procedure (Python is in private preview) to send messages and attach as a subtask.
- You can use SNOWALERT
- Or, as you wrote, use AWS mechanisms such as Amazon CloudWatch
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Michael Golos |