Which command is used to unload data from a Snowflake table into a file in a stage?

The correct answer is A. COPY INTO. COPY INTO is the Snowflake command used for both loading data (COPY INTO <table>) and unloading data (COPY INTO <stage>). When unloading, you specify the stage as the target: COPY INTO @mystage FROM mytable. Option B (GET) is used to download files from an internal stage to a…

Data Loading and Unloading

Question

Options

ACOPY INTO
BGET
CWRITE
DEXTRACT INTO

How the community answered

(62 responses)

A
92% (57)
B
3% (2)
C
2% (1)
D
3% (2)

Explanation

COPY INTO is the Snowflake command used for both loading data (COPY INTO <table>) and unloading data (COPY INTO <stage>). When unloading, you specify the stage as the target: COPY INTO @mystage FROM mytable. Option B (GET) is used to download files from an internal stage to a local file system - it does not unload table data. Options C (WRITE) and D (EXTRACT INTO) are not valid Snowflake commands.

Topics

#Data Unloading#COPY INTO#Snowflake Stages#SQL Commands

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice