Jumpstart Snowflake: A Step-by-Step Guide to Modern Cloud Analytics

© Dmitry Anoshin, Dmitry Shirokov, Donna Strok 2020

D. Anoshin et al.Jumpstart Snowflakehttps://doi.org/10.1007/978-1-4842-5328-1_4

4. Loading Bulk Data into Snowflake

Dmitry Anoshin¹ , Dmitry Shirokov² and Donna Strok³

(1)

British Columbia, Canada

(2)

Burnaby, BC, Canada

(3)

Seattle, WA, USA

 

There are two ways to load data into Snowflake: bulk data loading with the COPY statement and continuous data loading with Snowpipe. This chapter is focused on bulk data loading. We will cover the following topics:

• Overview of bulk data loading: We will cover what bulk data loading is, file load locations, supported file formats and encoding, compression handling, and encryption options.

• Bulk data loading recommendations: We will cover file preparation including file ...