Data Management and Utilities

DATEADD Function in Snowflake calculates a date or timestamp value by adding a specified interval to a given date or timestamp.

A Snowflake Alert allows scheduled execution of conditional SQL statements, enabling users to monitor specific events or thresholds within their environment.

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.