Snowflake - An Intermediate Course: Embrace data ingestion with Snowpipe, a seamless integration from Azure for continuous data loading

Nikolai Schuler

€59.99

5 (1 Ratings)

Video Aug 2023 2hrs 33mins 1st Edition

Nikolai Schuler

€59.99

5 (1 Ratings)

Video Aug 2023 2hrs 33mins 1st Edition

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Download Code

Key benefits

Create stages, storage integrations, notifications, and queues, mastering seamless data loading
Understand Zero-Copy Cloning to efficiently create table copies and streamline data management
Explore advanced data protection features, including time travel and data restoration

Description

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.

Who is this book for?

This course is designed for individuals with prior experience in Snowflake who want to take their skills to the next level. It is ideal for data analysts, engineers, BI professionals, data scientists, DBAs, and IT professionals who want to optimize data workflows, leverage advanced features, and gain insights into access control in a cloud-based environment. A basic understanding of Snowflake, SQL querying, and cloud computing concepts is necessary. Some exposure to data integration and management will be beneficial.