HOW TO: Send Email Notification in Snowflake?
Snowflake offers built-in stored procedures SYSTEM$SEND_EMAIL and SYSTEM$SEND_SNOWFLAKE_NOTIFICATION for sending email notifications.
Snowflake offers built-in stored procedures SYSTEM$SEND_EMAIL and SYSTEM$SEND_SNOWFLAKE_NOTIFICATION for sending email notifications.
ASOF JOIN in Snowflake matches each row in one table to the closest row in another table based on a specified condition, typically involving time series data.
MIN_BY and MAX_BY are aggregate functions in Snowflake that calculate the minimum or maximum value of a column and return the value of another column in that row.
A Common Table Expression (CTE) in Snowflake is a named subquery used within the execution scope of the query in which it is specified.
The DATEDIFF function in Snowflake facilitates the calculation of the difference between two date, time, or timestamp values.
The GREATEST function in Snowflake retrieves the largest value whereas the LEAST function returns the smallest value from a list of expressions.
Snowflake Dynamic Tables track the changes in the query data specified and refresh the materialized results incrementally through an automated process.
QUALIFY clause in a SELECT statement allows you to filter query results of Window functions within the same query.
The GROUP BY ALL clause is similar to GROUP BY clause except that it automatically include all non-aggregate items in the SELECT clause for grouping.
Learn how to find and kill long running queries in Snowflake using the QUERY_HISTORY table functions available under Information Schema.