• Online, Self-Paced
Course Description

Search optimization service is a Snowflake feature used to create an auxiliary data structure optimized as a search access path to improve selective point lookup query performance. While search optimization is an extremely handy feature, it can also run up substantial storage and compute costs.

In this course, learn how to implement search optimizations by measuring the cost of search optimizations for your table and adding the service to it. Next, differentiate between search optimizations and clustering and discover how to implement partitioning for external tables. Finally, practice working with views in Snowflake and differentiate between non-materialized, materialized, and secure views.

Upon completion, you'll be able to leverage search optimization in Snowflake, implement external table partitioning, and use and analyze views.

Learning Objectives

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.