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 34sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
7m 35sAfter 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
-
3. Creating and Querying Views12m 8sIn this video, find out how to create and query views. FREE ACCESS
-
4. Using Views and Role-based Access Control9m 30sLearn how to use views and role-based access control to grant different users access to different subsets of a table. FREE ACCESS
-
5. Creating Materialized Views7m 31sDuring this video, discover how to create and query materialized views. FREE ACCESS
-
6. Suspending and Resuming Materialized Views12m 23sFind out how to suspend and resume materialized views. FREE ACCESS
-
7. Using Secure Views6m 45sIn this video, you will learn how to create secure views and contrast them with ordinary views. FREE ACCESS
-
8. Creating Service Integration Objects12m 20sDiscover how to create a Google Cloud Platform (GCP) service integration object and assign GCP roles to the associated service account. FREE ACCESS
-
9. External Tables and Iceberg Tables13m 33sUpon completion of this video, you will be able to describe and contrast external tables and Iceberg tables in Snowflake. FREE ACCESS
-
10. Defining and Using External Tables11m 44sIn this video, find out how to create an external table connected to an external stage. FREE ACCESS
-
11. Working with IcebergTables13m 37sDuring this video, discover how to create an Iceberg table and configure appropriate cloud integrations. FREE ACCESS
-
12. Course Summary1m 37sIn 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.
