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

Which command is used to unload data from a Snowflake table into a file in a stage?
A . COPY INTO
B . GET
C . WRITE
D . EXTRACT INTO

Answer: A

Explanation:

The COPY INTO command is used in Snowflake to unload data from a table into a file in a stage. This command allows for the export of data from Snowflake tables into flat files, which can then be used for further analysis, processing, or storage in external systems.

Reference: Snowflake Documentation on Unloading Data

Snowflake SnowPro Core: Copy Into Command to Unload Rows to Files in Named Stage

Latest COF-C02 Practice Questions with 254 Q&As

Updated Study Material | Instant Download | Detailed Answers and Explanations

Subscribe
Notify of
guest
0 Comments