Which command can be used to load data files into a Snowflake stage?

The correct answer is C. PUT. The PUT command is used to upload (stage) data files from a local file system to a Snowflake internal stage. It is a Snowflake-specific command available in the SnowSQL CLI. COPY INTO (B) loads data from a stage into a Snowflake table (or unloads table data to a stage) - it…

Data Loading and Unloading

Question

Options

AJOIN
BCOPY INTO
CPUT
DGET

How the community answered

(29 responses)

A
3% (1)
B
7% (2)
C
86% (25)
D
3% (1)

Explanation

The PUT command is used to upload (stage) data files from a local file system to a Snowflake internal stage. It is a Snowflake-specific command available in the SnowSQL CLI. COPY INTO (B) loads data from a stage into a Snowflake table (or unloads table data to a stage) - it does not move files from local disk to a stage. GET (D) downloads files from a Snowflake internal stage to a local file system. JOIN (A) is a SQL clause for combining table rows and has no role in staging files.

Topics

#Snowflake stages#Data loading to stage#PUT command#File upload

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice