Queries in Snowflake: Getting Started with Performance Optimizations

Partitioning data based on a column is a common technique for performance query optimization in many database technologies. Snowflake is a highly-performant big-data technology that uses its own form of data partitioning called micro-partitioning that stores data in columnar format. In this course discover the advantages of Snowflake micro-partitions over regular static partitioning. Next examine how caching works in Snowflake. Finally learn how to perform the clustering of Snowflake tables and how clustering helps the performance of filters point-lookups and range queries on the clustering key columns. Upon completion youll be able to leverage micro-partitioning in Snowflake differentiate between retrieval optimization caching and local disk caching and implement clustering with the correct clustering key.