Queries in Snowflake: Getting Started with Performance Optimizations

Snowflake 2022    |    Intermediate
  • 16 Videos | 1h 51m 33s
  • Includes Assessment
  • Earns a Badge
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.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    outline micro-partitioning in Snowflake
    recognize query results and local disk caching
    load data into tables
    use caching for retrieval optimization in Snowflake
    disable caching in Snowflake
    query data using the local disk cache
    recall how clustering works in Snowflake
  • recall how the overlap depth of micro-partitions is computed
    outline the concepts of clustering in Snowflake
    choose clustering keys and view the resources saved by clustering on different columns
    use clustering and recall its advantages
    run queries on clustered date to query performance
    suspend clustering on a table
    cluster with multiple columns and evaluate the resulting performance
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 9s
    UP NEXT
  • Playable
    2. 
    Micro-partitions in Snowflake
    6m 56s
  • Locked
    3. 
    Snowflake Caching
    8m 9s
  • Locked
    4. 
    Loading Data into Tables
    10m 26s
  • Locked
    5. 
    Using Caching in Snowflake
    9m 13s
  • Locked
    6. 
    Disabling Caching
    7m 22s
  • Locked
    7. 
    Querying Data Using the Local Disk Cache
    7m 43s
  • Locked
    8. 
    How Clustering Works in Snowflake
    4m 39s
  • Locked
    9. 
    Overlap Depth of Micro-partitions
    6m 6s
  • Locked
    10. 
    Snowflake Clustering Concepts
    7m 15s
  • Locked
    11. 
    Choosing Clustering Keys
    11m 57s
  • Locked
    12. 
    Using Clustering
    7m 38s
  • Locked
    13. 
    Running Queries on Clustered Data
    6m 23s
  • Locked
    14. 
    Suspending Clustering
    5m 4s
  • Locked
    15. 
    Clustering with Multiple Key Columns
    7m 6s
  • Locked
    16. 
    Course Summary
    4m 28s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.