Which command will unload data from a table into an external stage?

The correct answer is C. COPY INTO <location>. COPY INTO <location> is Snowflake's bulk data unload command that exports data from a table or query result into files in either an internal or external stage (e.g., Amazon S3, Azure Blob Storage, Google Cloud Storage). PUT uploads files from a local machine to an internal…

Data Loading and Unloading

Question

Options

APUT
BINSERT
CCOPY INTO <location>
DGET

How the community answered

(27 responses)

A
4% (1)
C
93% (25)
D
4% (1)

Explanation

COPY INTO <location> is Snowflake's bulk data unload command that exports data from a table or query result into files in either an internal or external stage (e.g., Amazon S3, Azure Blob Storage, Google Cloud Storage). PUT uploads files from a local machine to an internal Snowflake stage. GET downloads files from an internal stage to a local machine. INSERT adds rows into a table, not a stage. Only COPY INTO <location> handles unloading to external stages.

Topics

#Data Unloading#COPY INTO#External Stage#SQL Commands

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice