To Nha Notes | Jan. 31, 2023, 4:37 p.m.
The use of Snowflake has evolved into much more than just a data warehouse, rather, the data cloud, a service offering for data solutions. Data pipelines are being built every day using the likes of Tasks and Procedures, but when you think about it, whenever your data pipeline fails, it may be critical to know when it fails and how it fails, as opposed to manually monitoring it.
As a result, one of the most requested capabilities is to be able to raise a notification whenever the data pipeline fails.
Unfortunately, there isn’t any straightforward off-the-shelf feature that Snowflake provides us which will allow us to use to raise notifications. Nevertheless, a simple solution can be built using the now available, External Function (Business Critical accounts and above).
This article will outline how to build a notification application within Snowflake.
External Function is a feature that allows users to execute external code that resides outside of Snowflake such as in AWS Lambda, Azure Function, or HTTPS server.
The user can simply call the External Function where it will talk to the HTTPS proxy service such as API Gateway which can be set up to trigger Lambda that contains your external code.
https://servian.dev/how-to-raise-notification-and-alerts-within-snowflake-d9276a801064
https://docs.snowflake.com/en/sql-reference/sql/create-notification-integration.html
https://docs.snowflake.com/en/sql-reference/email-stored-procedures.html