Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

The correct answer is D. COPY. The COPY INTO <table> command is used to bulk-load data from a stage (internal or external) into a Snowflake table. It is the primary and most efficient method for loading staged data. PUT is used to upload files from a local machine to an internal Snowflake stage - it does not…

Data Loading and Unloading

Question

Options

AINSERT
BPUT
CGET
DCOPY

How the community answered

(48 responses)

A
6% (3)
B
2% (1)
C
4% (2)
D
88% (42)

Explanation

The COPY INTO <table> command is used to bulk-load data from a stage (internal or external) into a Snowflake table. It is the primary and most efficient method for loading staged data. PUT is used to upload files from a local machine to an internal Snowflake stage - it does not load into tables. GET downloads files from an internal stage to a local machine. INSERT can add rows but is not designed for bulk loading from staged files and would be extremely inefficient for large datasets.

Topics

#Data loading#COPY INTO#External stage#SQL commands

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice