Loading from S3, Azure Blob, GCS in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of an external stage in Snowflake when loading data from cloud storage?

An external stage in Snowflake points to a location in cloud storage (like S3, Azure Blob, or GCS) and allows Snowflake to access files there for loading or unloading data.

beginner

Which cloud storage services are commonly supported by Snowflake for loading data?

Snowflake supports Amazon S3, Microsoft Azure Blob Storage, and Google Cloud Storage (GCS) for loading data.

intermediate

What is the role of credentials when creating an external stage in Snowflake?

Credentials authenticate Snowflake to access the cloud storage location securely, such as AWS IAM roles for S3, Azure SAS tokens for Blob, or GCP service account keys for GCS.

beginner

How does Snowflake load data from an external stage into a table?

Snowflake uses the COPY INTO command to load data from files in the external stage into a target table, parsing the file format and applying any transformations if needed.

beginner

Why is it important to define the file format when loading data from cloud storage into Snowflake?

Defining the file format tells Snowflake how to interpret the data files (like CSV, JSON, Parquet), ensuring correct parsing and loading of data into tables.

Which command in Snowflake is used to load data from an external stage into a table?

A COPY INTO

B LOAD DATA

C INSERT FROM

D IMPORT FILE

The COPY INTO command loads data from an external stage into a Snowflake table.

What type of credentials might you use to access an Amazon S3 bucket from Snowflake?

A Azure SAS Token

B GCP Service Account Key

C AWS IAM Role

D FTP Username

AWS IAM Roles are used to securely grant Snowflake access to Amazon S3 buckets.

Which cloud storage service is NOT supported by Snowflake for external stages?

A Microsoft Azure Blob Storage

B Dropbox

C Google Cloud Storage

D Amazon S3

Dropbox is not supported as an external stage for Snowflake.

Why do you need to specify a file format when loading data from cloud storage into Snowflake?

A To create a backup of the files

B To encrypt the data during transfer

C To compress the files

D To tell Snowflake how to parse the data files

Specifying the file format helps Snowflake understand how to read and parse the data files correctly.

What is an external stage in Snowflake?

A A pointer to cloud storage location for data files

B A temporary table inside Snowflake

C A user role for access control

D A type of file format

An external stage points Snowflake to files stored in cloud storage for loading or unloading.

Explain how Snowflake loads data from Amazon S3 into a table.

Think about the steps from storage to table.

Describe the differences in credentials used for accessing Azure Blob Storage and Google Cloud Storage from Snowflake.

Focus on the type of keys or tokens used.