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 3
Zero-Copy Cloning
Content Locked
Section 3
Cloning and Time Travel
In this video, we will discover how Zero-Copy Cloning seamlessly integrates with Snowflake's time travel feature. We will explore how to clone data at different points in time, leveraging time travel capabilities to replicate historical data instantly.