From the course: Everybody's Introduction to Snowflake
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Data loading and unloading with Snowflake - Snowflake Tutorial
From the course: Everybody's Introduction to Snowflake
Data loading and unloading with Snowflake
- To leverage Snowflake you first need to understand how to get your data into and out of Snowflake. Let's break it down. First, we'll discuss data loading. This is the process of importing your data into Snowflake. This is typically achieved through two methods batch loading and continuous loading. In batch loading data is loaded at scheduled intervals. For example, daily sales reports to allow for analysis the next day, or maybe you work at a bank and you batch load transactions at the end of each day to perform end of day reconciliations. In all of these examples batch loading is a strategic decision. By consolidating data transmission into a single larger transfer these organizations can minimize disruption, manage bandwidth for their infrastructure and often improve overall system performance. In continuous loading data is streamed into Snowflake as soon as it's generated. Examples include e-commerce platforms where events downstream from a cell need to be acted on immediately…
Contents
-
-
-
Tackling data capture challenges5m 9s
-
(Locked)
Data loading and unloading with Snowflake6m 15s
-
(Locked)
Supported data sources in Snowflake3m 44s
-
(Locked)
Data types and formats in Snowflake4m 38s
-
(Locked)
Tools for loading data into Snowflake3m 19s
-
(Locked)
Optimal frequency for loading data into Snowflake3m 36s
-
-
-
-