Loading delimited bulk data into Snowflake from cloud storage

This recipe demonstrates several important concepts related to loading data stored in cloud storage, for example, Amazon S3 bucket, Azure Blob Storage, and so on, into your Snowflake instance. To load data from cloud storage, we will make use of the external stage concept in Snowflake.

Getting ready

As we will be loading a file from cloud storage to Snowflake, you should have a cloud storage bucket created with files present in the bucket. To save time, you can download a previously created sample file from https://github.com/PacktPublishing/Snowflake-Cookbook/blob/master/Chapter03/r2/cc_info.csv.

Before proceeding with this recipe, follow the steps in the Configuring Snowflake access to private S3 buckets recipe to set up access when using a private or restricted bucket.

How to do it…

In order to load a file from cloud storage, we will create an external stage pointing to the cloud storage and use...