Queries in Snowflake: Search Optimization, External Table Partitions, & Views

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.