A user wants to upload a file to an internal Snowflake stage using a put command. Which tools and or connectors could be used to execute this command? (Select TWO).

The correct answer is B. SnowSQL E. Snowsight worksheets. The PUT command is a Snowflake-specific file transfer command (not standard SQL) and is only supported in certain clients. SnowSQL (B) natively supports PUT from the command line, making it a primary tool for this operation. Snowsight (E) provides a built-in UI in worksheets…

Data Loading and Unloading

Question

Options

ASnowCD
BSnowSQL
CSQL API
DPython connector
ESnowsight worksheets

How the community answered

(59 responses)

A
5% (3)
B
90% (53)
C
3% (2)
D
2% (1)

Explanation

The PUT command is a Snowflake-specific file transfer command (not standard SQL) and is only supported in certain clients. SnowSQL (B) natively supports PUT from the command line, making it a primary tool for this operation. Snowsight (E) provides a built-in UI in worksheets that allows users to execute PUT commands to upload files to internal stages. The SQL API (C) is a REST API that does not support PUT/GET file transfer commands. SnowCD (A) is a connectivity diagnostic tool only. The Python connector does technically support PUT via cursor.execute(), but B and E represent the tools explicitly designed and documented for this workflow.

Topics

#Data Loading#Internal Stages#PUT Command#Snowflake Client Tools

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice