From the course: Advanced Data Engineering with Snowflake

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Alerts in Snowflake

Alerts in Snowflake

Generating and querying logs and traces to keep track of what happens in your code is one key part of observability. Another equally important part is the ability to be alerted when key events occur in your data environment. This is where Snowflake's alerts feature can help immensely. Alerts in Snowflake allow you to perform an action in your data environment when specific conditions are met. These actions can include sending out e-mail notifications or even executing a SQL statement, for example. An alert is made up of three components. A condition that triggers the alert, the action to perform when the condition is met, and finally, how often to evaluate the condition. In other words, a schedule to check for the condition. Alerts in Snowflake can be set up using SQL and once defined, can be configured to meet your specific use case. They frequently play a role across several different aspects of a pipeline. For example, you can use alerts on compute resources for generating…

Contents