Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

The correct answer is B. PUT. To upload data files from a local directory or folder on a client machine to an internal stage in Snowflake, the PUT command is used. The PUT command takes files from the local file system and uploads them to an internal Snowflake stage (or a specified stage) for the purpose of…

Data Loading and Unloading

Question

Options

AGET
BPUT
CCREATE STREAM
DCOPY INTO <location>

How the community answered

(50 responses)

A
2% (1)
B
90% (45)
C
6% (3)
D
2% (1)

Explanation

To upload data files from a local directory or folder on a client machine to an internal stage in Snowflake, the PUT command is used. The PUT command takes files from the local file system and uploads them to an internal Snowflake stage (or a specified stage) for the purpose of preparing the data to be loaded into Snowflake tables. PUT file://<local_file_path> @<stage_name>; This command is crucial for data ingestion workflows in Snowflake, especially when preparing to load data using the COPY INTO command.

Topics

#Data Loading#PUT command#Internal Stages#File Upload

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice