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 2
Continuous Data Protection in Snowflake
Content Locked
Section 5
Understanding Different Table Types
In this video, we will explore different table types in Snowflake in this video. The video explains the distinctions between temporary, transient, and permanent tables, helping us make informed decisions regarding data storage and usage.