![Snowflake - An Introduction Course [Video]](https://content.packt.com/V21592/cover_image_small.jpg)
Snowflake - An Introduction Course [Video]
Subscription
FREE
Video + Subscription
$12.99
Video
$79.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
Subscription
FREE
Video + Subscription
$12.99
Video
$79.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
-
Free ChapterKey Concepts of Snowflake
-
Data Loading in Snowflake
- Bulk Versus Continuous Loading
- Stages in Snowflake
- First Data Load
- Setup Stage
- Load from Stage
- Applying Transformations During COPY
- Additional Transformations During COPY
- File Format Objects
- Loading Data
- What Are Copy Options?
- ON_ERROR
- VALIDATION_MODE
- Error Processing after Load
- SIZE_LIMIT
- FORCE
- Load History
- Create a Free Azure Account
- Set Up an Azure Account
- Set Up Integration Object for Azure Container
- Create a Stage for the Azure Container
- Load Data from the Azure Container
- Load JSON
About this video
Snowflake is a cloud-based data warehousing platform. It separates storage and computing, enabling fast and scalable analytics. Its architecture, ease of use, and SQL support make it popular for data management, efficiently processing large volumes of data, and enabling data-driven insights.
In this introductory Snowflake course, we will explore the key concepts and functionalities of the cloud-based data warehousing platform. We will learn the basics of Snowflake, including its architecture, warehouses, and data-loading techniques. The lessons cover free trial sign-up, interface navigation, setting up warehouses using SQL, and creating database objects. Hands-on readings and quizzes reinforce your understanding. We focus on data loading in Snowflake, delving into COPY INTO, stages, transformations, and file format objects. We will explore loading data from various sources and applying transformations during the loading process.
By the end of the course, we will be equipped with a foundational knowledge of Snowflake, capable of navigating its interface, setting up warehouses, and efficiently loading and processing data. This course serves as an excellent starting point for anyone looking to harness the power of Snowflake for data warehousing and analytics.
- Publication date:
- August 2023
- Publisher
- Packt
- Duration
- 2 hours 56 minutes
- ISBN
- 9781835083765