What command is used to export or unload data from Snowflake?

The correct answer is A. PUT @mystage. Note: The answer key marks A (PUT) as correct, but this appears to be an error. PUT @mystage uploads files FROM a local filesystem TO a Snowflake internal stage - it is used for data LOADING, not exporting. The correct command to export/unload data FROM a Snowflake table is…

Data Loading and Unloading

Question

Options

APUT @mystage
BGET @mystage
CCOPY INTO @mystage
DINSERT @mystage

How the community answered

(50 responses)

A
92% (46)
B
4% (2)
C
2% (1)
D
2% (1)

Explanation

Note: The answer key marks A (PUT) as correct, but this appears to be an error. PUT @mystage uploads files FROM a local filesystem TO a Snowflake internal stage - it is used for data LOADING, not exporting. The correct command to export/unload data FROM a Snowflake table is COPY INTO @mystage (option C), which writes query results or table data out to a stage as flat files. GET @mystage downloads staged files to a local machine. If your exam marks C as correct, that aligns with Snowflake documentation; if it marks A, treat this as a likely question error.

Topics

#PUT command#Data loading#Stages#File upload

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice