Snowflake Performance: Iceberg Tables, External Tables, and Views

Snowflake    |    Intermediate
  • 12 videos | 1h 50m 17s
  • Includes Assessment
  • Earns a Badge
Understanding the concept of views in Snowflake is vital for creating and querying various types of views. Views allow us to use role-based access control to manage permissions and data security effectively and are essential for organizing and simplifying data and ensuring that only authorized users can access sensitive information. In this course, you will discover how to create and query standard, materialized, and secure views in Snowflake. Then you will configure role-based access control to allow users to access specific views and you will use materialized views to improve the performance of your queries and secure views to control access to the details of the underlying table. Next, you will learn how to query data stored in external cloud locations using Snowflake, integrate Snowflake with Google Cloud Storage buckets, and create an external table to access and query data stored on the Google Cloud using Snowflake. Finally, you will create and configure Iceberg tables in Snowflake for a modern, high-performance format that aids in managing large-scale datasets, providing features like schema evolution, partitioning, and time travel for enhanced data management.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Provide an overview of the properties and use cases of views, materialized views, and secure views
    Create and query views
    Use views and role-based access control to grant different users access to different subsets of a table
    Create and query materialized views
    Suspend and resume materialized views
  • Create secure views and contrast them with ordinary views
    Create a google cloud platform (gcp) service integration object and assign gcp roles to the associated service account
    Describe and contrast external tables and iceberg tables in snowflake
    Create an external table connected to an external stage
    Create an iceberg table and configure appropriate cloud integrations
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 34s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 7m 35s
    After completing this video, you will be able to provide an overview of the properties and use cases of views, materialized views, and secure views. FREE ACCESS
  • Locked
    3.  Creating and Querying Views
    12m 8s
    In this video, find out how to create and query views. FREE ACCESS
  • Locked
    4.  Using Views and Role-based Access Control
    9m 30s
    Learn how to use views and role-based access control to grant different users access to different subsets of a table. FREE ACCESS
  • Locked
    5.  Creating Materialized Views
    7m 31s
    During this video, discover how to create and query materialized views. FREE ACCESS
  • Locked
    6.  Suspending and Resuming Materialized Views
    12m 23s
    Find out how to suspend and resume materialized views. FREE ACCESS
  • Locked
    7.  Using Secure Views
    6m 45s
    In this video, you will learn how to create secure views and contrast them with ordinary views. FREE ACCESS
  • Locked
    8.  Creating Service Integration Objects
    12m 20s
    Discover how to create a Google Cloud Platform (GCP) service integration object and assign GCP roles to the associated service account. FREE ACCESS
  • Locked
    9.  External Tables and Iceberg Tables
    13m 33s
    Upon completion of this video, you will be able to describe and contrast external tables and Iceberg tables in Snowflake. FREE ACCESS
  • Locked
    10.  Defining and Using External Tables
    11m 44s
    In this video, find out how to create an external table connected to an external stage. FREE ACCESS
  • Locked
    11.  Working with IcebergTables
    13m 37s
    During this video, discover how to create an Iceberg table and configure appropriate cloud integrations. FREE ACCESS
  • Locked
    12.  Course Summary
    1m 37s
    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 An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Course Queries in Snowflake: Getting Started with Performance Optimizations
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)
Course Data Loading in Snowflake: Fundamentals of Stages
Rating 4.7 of 50 users Rating 4.7 of 50 users (50)