Snowflake Performance: Clustering and Search Optimization

Snowflake    |    Intermediate
  • 15 videos | 2h 16m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.0 of 2 users Rating 4.0 of 2 users (2)
Clustering and search optimization in Snowflake are crucial for enhancing query performance, reducing data retrieval times, and effectively managing large datasets. These techniques streamline data access, ensuring scalable and efficient data handling. In this course, you will explore how clustering helps improve the performance of point lookup and range queries. You will investigate the importance of choosing the appropriate clustering key and examine various approaches to implementing clustering, focusing on performance and scalability. Next, you will discover different methods for evaluating your clustering strategies and see how clustering can make your data retrieval queries more performant. You will also be introduced to search optimization in Snowflake to improve point lookup queries by building an auxiliary data structure to help quickly access data. Then you will compare search optimization and clustering to understand their effective use cases and gain insights on refining searches with complex predicates using AND and OR Clauses and optimizing searches on specific columns. Finally, you will work with VARIANTS, OBJECTS, and ARRAYS for versatile data management and improve queries with semi-structured data.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Provide an overview of the intuition behind clustering depth and the number of overlapping partitions
    Choose the clustering key appropriately
    Populate a table with data using put and copy into and use tablesample to shuffle the data in that table
    Evaluate choices of clustering keys and pick the most suitable
    Compare query performance on clustered and unclustered tables
    Resume clustering after cloning a clustered table
    Analyze the search optimization feature and contrast it with clustering
  • Turn on search optimization for a table and verify that the search access path is fully constructed
    Compare the performance of queries using search optimization, clustering, and no optimization at all
    Evaluate search optimization with in, and, and or clauses
    Implement search optimizations for individual columns for both equality and substring matches
    Work with variant, object, and array data loaded into a snowflake table
    Leverage search optimization for working with variant, array, and object data
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 23s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 11m 27s
    After completing this video, you will be able to provide an overview of the intuition behind clustering depth and the number of overlapping partitions. FREE ACCESS
  • Locked
    3.  The Clustering Key
    8m 47s
    Upon completion of this video, you will be able to choose the clustering key appropriately. FREE ACCESS
  • Locked
    4.  Implementing Clustering
    13m 5s
    During this video, you will learn how to populate a table with data using PUT and COPY INTO and use TABLESAMPLE to shuffle the data in that table. FREE ACCESS
  • Locked
    5.  Choosing the Clustering Key
    10m 55s
    Discover how to evaluate choices of clustering keys and pick the most suitable. FREE ACCESS
  • Locked
    6.  Benchmarking Clustering
    8m 24s
    In this video, find out how to compare query performance on clustered and unclustered tables. FREE ACCESS
  • Locked
    7.  Clustering and Cloning
    12m 7s
    Learn how to resume clustering after cloning a clustered table. FREE ACCESS
  • Locked
    8.  Search Optimization in Snowflake
    9m 43s
    In this video, we will analyze the Search Optimization feature and contrast it with clustering. FREE ACCESS
  • Locked
    9.  Enabling Search Optimization
    13m 36s
    Find out how to turn on search optimization for a table and verify that the search access path is fully constructed. FREE ACCESS
  • Locked
    10.  Comparing Search Optimization to Clustering
    10m 31s
    During this video, discover how to compare the performance of queries using search optimization, clustering, and no optimization at all. FREE ACCESS
  • Locked
    11.  Using Search Optimization with AND and OR Clauses
    8m 24s
    During this video, you will learn how to evaluate search optimization with IN, AND, and OR clauses. FREE ACCESS
  • Locked
    12.  Using Search Optimization On Columns
    11m 42s
    Discover how to implement search optimizations for individual columns for both equality and substring matches. FREE ACCESS
  • Locked
    13.  Working with VARIANTS, OBJECTS and ARRAYS
    7m 47s
    In this video, find out how to work with VARIANT, OBJECT, and ARRAY data loaded into a Snowflake table. FREE ACCESS
  • Locked
    14.  Using Search Optimization with Semi-structured Data
    6m 26s
    During this video, you will learn how to leverage search optimization for working with VARIANT, ARRAY, and OBJECT data. FREE ACCESS
  • Locked
    15.  Course Summary
    1m 46s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Data Loading in Snowflake: Fundamentals of Stages
Rating 4.7 of 50 users Rating 4.7 of 50 users (50)
Course Advanced Analytics: Performing Analytics Using Snowflake
Rating 4.6 of 48 users Rating 4.6 of 48 users (48)
Journey Data Analytics with Snowflake
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)