Stages (internal and external) in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is an internal stage in Snowflake?

An internal stage is a storage location inside Snowflake where files can be uploaded and accessed for loading or unloading data. It is managed by Snowflake and does not require external cloud storage setup.

beginner

What is an external stage in Snowflake?

An external stage points to a cloud storage location outside Snowflake, such as AWS S3, Azure Blob Storage, or Google Cloud Storage. It allows Snowflake to access files stored externally for data loading or unloading.

intermediate

Name two benefits of using internal stages in Snowflake.

1. No need to manage external cloud storage credentials.<br>2. Fast and secure access since data stays within Snowflake's environment.

intermediate

What must you configure to use an external stage in Snowflake?

You must provide the cloud storage URL and credentials (like access keys or SAS tokens) so Snowflake can securely access the external storage location.

beginner

How do stages help in the data loading process in Snowflake?

Stages act like a mailbox where files are placed before loading into tables or after unloading from tables. They simplify and organize data transfer between Snowflake and storage.

Which of the following is true about internal stages in Snowflake?

A They need manual credential management.

B They require external cloud storage setup.

C They cannot be used for unloading data.

D They store data inside Snowflake's managed storage.

Internal stages store data inside Snowflake's managed storage, so no external setup or credential management is needed.

What is required to create an external stage in Snowflake?

A A local file path.

B Only a Snowflake user name.

C Cloud storage URL and access credentials.

D No configuration is needed.

External stages need the cloud storage URL and credentials so Snowflake can access the external files.

Which cloud storage services can be used with Snowflake external stages?

A Only AWS S3.

B AWS S3, Azure Blob Storage, Google Cloud Storage.

C Only local disk drives.

D FTP servers.

Snowflake supports external stages with AWS S3, Azure Blob Storage, and Google Cloud Storage.

What is a key advantage of using internal stages?

A No need to manage external credentials.

B They are slower than external stages.

C They require manual file transfers.

D They only support CSV files.

Internal stages do not require managing external cloud credentials, simplifying usage.

Stages in Snowflake are primarily used for:

A Storing files temporarily for loading or unloading data.

B Running SQL queries.

C Managing user permissions.

D Backing up databases.

Stages act as temporary storage locations for files during data loading or unloading.

Explain the difference between internal and external stages in Snowflake.

Think about where the data physically lives and what setup is needed.

Describe how stages simplify the data loading process in Snowflake.

Imagine stages like a mailbox for your data files.