Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

The correct answer is C. COPY INTO <location>. COPY INTO <location> is the command used to unload (export) data from a Snowflake table into files in an internal or external stage. The direction of the data flow is the key differentiator: COPY INTO <table> does the opposite - it loads data from a stage into a table. CREATE…

Data Loading and Unloading

Question

Options

ACREATE STAGE
BCOPY INTO <table>
CCOPY INTO <location>
DCREATE PIPE

How the community answered

(21 responses)

B
5% (1)
C
95% (20)

Explanation

COPY INTO <location> is the command used to unload (export) data from a Snowflake table into files in an internal or external stage. The direction of the data flow is the key differentiator: COPY INTO <table> does the opposite - it loads data from a stage into a table. CREATE STAGE creates the stage itself, and CREATE PIPE sets up Snowpipe for continuous automated data ingestion. When you need to export data out of Snowflake, COPY INTO <location> is the correct command.

Topics

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

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice