GREATEST and LEAST Functions in Snowflake
The GREATEST function in Snowflake retrieves the largest value whereas the LEAST function returns the smallest value from a list of expressions.
Snowflake
Snowflake Dynamic Tables: Change Data Capture Simplified
Snowflake Dynamic Tables track the changes in the query data specified and refresh the materialized results incrementally through an automated process.
QUALIFY in Snowflake: Filter Window Functions
QUALIFY clause in a SELECT statement allows you to filter query results of Window functions within the same query.
GROUP BY ALL in Snowflake
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.
Tag-based Data Masking in Snowflake
Snowflake combines best of tagging and data masking features to protect sensitive data which is referred to as Tag-based Data Masking
Tagging in Snowflake
Tags in Snowflake can be applied on the database objects which lets you discover, monitor and protect sensitive data.
Snowflake SnowPro Core Certification Preparation Guide
A comprehensive list of all resources that help you in your Snowflake SnowPro Core Certification examination preparation.
Search Optimization Service in Snowflake
Search Optimization Service is a query optimization service that improves query performance of selective point lookup queries.
Query Acceleration Service in Snowflake
Query Acceleration Service is a feature to improve the performance of huge queries by offloading portions of query processing to the additional compute resources.
Caching in Snowflake
Learn how Snowflake caching helps in improving the query performance by making data retrieval faster and more efficient.