• Online, Self-Paced
Course Description

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, you'll 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.

Learning Objectives

{"discover the key concepts covered in this course"}

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration