SnowPro™ Core Certification Companion: Hands-on Preparation and Practice

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

M. FerleSnowPro™ Core Certification CompanionCertification Study Companion Serieshttps://doi.org/10.1007/978-1-4842-9078-1_7

7. Data Loading and Unloading

Maja Ferle¹  

(1)

Ljubljana, Slovenia

 

When loading or unloading data into/from Snowflake, you must understand that Snowflake is hosted in the cloud. This means that loading and unloading data is easiest between Snowflake and other cloud storage locations. Loading or unloading data from local files requires an additional step that moves the data to a cloud storage location, where it is accessible to Snowflake.

There are many approaches to loading data into Snowflake, depending on the use case, including:

• Loading ...