How to raise Notification and Alerts within Snowflake
Raising notifications in Snowflake
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.
So, what is External Function?
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.