A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?

The correct answer is B. list @my_stage. The LIST command (B) - also abbreviated as LS - is the correct Snowflake command to display the files that exist in a named stage, including both internal and external stages. Syntax: LIST @my_stage; or LS @my_stage;. SHOW (C) is a valid Snowflake command but is used to display…

Data Loading and Unloading

Question

Options

Aview @my_stage
Blist @my_stage
Cshow @my_stage
Ddisplay @my_stage

How the community answered

(33 responses)

A
3% (1)
B
94% (31)
D
3% (1)

Explanation

The LIST command (B) - also abbreviated as LS - is the correct Snowflake command to display the files that exist in a named stage, including both internal and external stages. Syntax: LIST @my_stage; or LS @my_stage;. SHOW (C) is a valid Snowflake command but is used to display metadata about Snowflake objects such as tables, databases, or warehouses - not stage file contents. VIEW (A) and DISPLAY (D) are not valid Snowflake SQL commands.

Topics

#External Stages#Data Unloading#LIST Command#Stage Contents

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice