Queries in Snowflake: Search Optimization External Table Partitions & Views

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 youll be able to leverage search optimization in Snowflake implement external table partitioning and use and analyze views.