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

Snowflake    |    Intermediate
  • 15 videos | 1h 32m 27s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)
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.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Outline search optimization in snowflake and the search optimization service
    Enable search optimization
    Use search optimization and recall its advantages
    Compare the performance benefits of search optimization and clustering
    Identify how to partition external tables in snowflake
    Create an external stage and external table from data in s3
    Partition external tables
  • Perform manual partitioning on external tables
    Differentiate non-materialized, materialized, and secure views
    Create non-materialized views
    Query views and observe the outcomes
    Query materialized views to observe performance benefits
    Create and use secure views
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 12s
  • 6m 40s
  • Locked
    3.  Enabling Search Optimization
    8m 16s
  • Locked
    4.  Using Search Optimization
    6m 29s
  • Locked
    5.  Comparing Search Optimization and Clustering
    8m 6s
  • Locked
    6.  Partitioning of Snowflake External Tables
    3m 9s
  • Locked
    7.  Creating an External Stage and Table
    8m 9s
  • Locked
    8.  Partitioning External Tables
    5m 17s
  • Locked
    9.  Performing Manual Partitioning on External Tables
    5m 58s
  • Locked
    10.  Views in Snowflake
    8m 33s
  • Locked
    11.  Creating Views
    6m 18s
  • Locked
    12.  Querying Views
    5m 17s
  • Locked
    13.  Querying Materialized Views
    9m 44s
  • Locked
    14.  Creating and Using Secure Views
    4m 5s
  • Locked
    15.  Course Summary
    5m 13s

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

Book Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud, 4th Edition
Course Advanced Analytics: Performing Analytics Using Snowflake
Rating 4.6 of 48 users Rating 4.6 of 48 users (48)
Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Loading in Snowflake: Using External Stages
Rating 4.6 of 32 users Rating 4.6 of 32 users (32)
Course Getting Started with Snowflake: Queries, Dashboards, & Tables
Rating 4.7 of 149 users Rating 4.7 of 149 users (149)
Course Search Management
Rating 4.6 of 20 users Rating 4.6 of 20 users (20)