Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

The correct answer is B. GET. In Snowflake, the GET command is used to download (stage → local) files from an internal stage to a directory on the client machine. The PUT command does the opposite - it uploads files from a local machine to a Snowflake internal stage. COPY INTO moves data between stages and…

Data Loading and Unloading

Question

Options

APUT
BGET
CCOPY
DSELECT

How the community answered

(32 responses)

A
3% (1)
B
94% (30)
D
3% (1)

Explanation

In Snowflake, the GET command is used to download (stage → local) files from an internal stage to a directory on the client machine. The PUT command does the opposite - it uploads files from a local machine to a Snowflake internal stage. COPY INTO moves data between stages and tables (not to local disk), and SELECT retrieves query results, not stage files.

Topics

#Data unloading#GET command#Snowflake stages#Local file system

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice