Which command is used to unload files from an internal or external stage to a local file system?

The correct answer is B. GET. The GET command in Snowflake downloads (unloads) data files from an internal stage (or named external stage via SnowSQL) to the local file system of the client machine. The PUT command does the opposite - it uploads local files to a Snowflake stage. COPY INTO is used to load…

Data Loading and Unloading

Question

Options

ACOPY INTO
BGET
CPUT
DTRANSFER

How the community answered

(28 responses)

A
4% (1)
B
89% (25)
C
7% (2)

Explanation

The GET command in Snowflake downloads (unloads) data files from an internal stage (or named external stage via SnowSQL) to the local file system of the client machine. The PUT command does the opposite - it uploads local files to a Snowflake stage. COPY INTO is used to load data from a stage into a table or unload table data into a stage, but not directly to a local file system.

Topics

#GET command#Data Unloading#Stages#Local filesystem

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice