Which command should be used to unload all the rows from a table into one or more files in a named stage?

The correct answer is A. COPY INTO. COPY INTO <stage_location> is the command used to unload (export) data from a Snowflake table into files stored in a stage (internal or external). GET is used to download files from an internal stage to a local machine. PUT uploads local files to an internal stage. INSERT INTO…

Data Loading and Unloading

Question

Options

ACOPY INTO
BGET
CINSERT INTO
DPUT

How the community answered

(35 responses)

A
91% (32)
B
3% (1)
D
6% (2)

Explanation

COPY INTO <stage_location> is the command used to unload (export) data from a Snowflake table into files stored in a stage (internal or external). GET is used to download files from an internal stage to a local machine. PUT uploads local files to an internal stage. INSERT INTO adds rows into a table, not a stage. COPY INTO is the correct and only command for bulk data unloading in Snowflake.

Topics

#Data Unloading#COPY INTO command#Named Stages#Exporting Data

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice