A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

The correct answer is D. list @mystage. The LIST command in Snowflake lists files in a stage. Named internal stages use the syntax @stage_name, so the correct command is LIST @mystage; (D). Option A (LIST @mytable) would list files in the table stage for mytable, not the named stage mystage. Option B uses a typo…

Data Loading and Unloading

Question

Options

Alist @mytable;
Blist @%raytable;
Clist @ %m.ystage;
Dlist @mystage;

How the community answered

(31 responses)

A
6% (2)
B
3% (1)
C
3% (1)
D
87% (27)

Explanation

The LIST command in Snowflake lists files in a stage. Named internal stages use the syntax @stage_name, so the correct command is LIST @mystage; (D). Option A (LIST @mytable) would list files in the table stage for mytable, not the named stage mystage. Option B uses a typo (@%raytable). Option C has incorrect syntax with spaces and a period in the stage name. The @ prefix before a stage name is required, and named stages are referenced directly as @stagename.

Topics

#Internal Stages#LIST command#Data Unloading#File Management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice