Book Image

Snowflake - An Intermediate Course [Video]

By : Nikolai Schuler
5 (1)
Book Image

Snowflake - An Intermediate Course [Video]

5 (1)
By: Nikolai Schuler

Overview of this book

Snowflake is a cloud-based data platform designed to handle and analyze large volumes of data efficiently and effectively. It provides a fully-managed and scalable infrastructure, making it easy to store, manage, and process data in a cost-effective manner. Snowflake supports various data types, including structured, semi-structured, and unstructured data for a wide range of use cases. The course covers topics to advance your knowledge and skills with Snowflake. We will explore continuous data loading with Snowpipe, enabling real-time data ingestion from Azure. We will set up stages, storage integrations, notifications, and queues for efficient and continuous data loading. The course also delves into continuous data protection, ensuring data reliability through features such as time travel, data restoration, and undropping objects. We will gain insights into different table types, Snowflake editions, pricing, and usage monitoring. The course introduces Zero-Copy Cloning, facilitating the creation of table copies for streamlined data management. We will understand roles and user management, providing a comprehensive view of access control in Snowflake. By the end of the course, we will have a solid grasp of Snowflake’s sophisticated capabilities, empowering us to manage and analyze data effectively in a cloud-based environment.
Table of Contents (4 chapters)
Chapter 4
Roles and User Management in Snowflake
Content Locked
Section 6
Custom Roles
In this video, we will explore the concept of custom roles in Snowflake, which allow us to tailor permissions and privileges to specific user groups or use cases. We will discover how to create and manage custom roles, enhancing our control over data access and user management within Snowflake.