Which command can be used to view the list of files that has been uploaded to the staged?

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?
A . list @mytable;
B . list @%raytable;
C . list @ %m.ystage;
D . list @mystage;

View Answer

Answer: D

Explanation:

The command list @mystage; is used to view the list of files that have been uploaded to an internal stage in Snowflake. The list command displays the metadata for all files in the specified stage, which in this case is mystage. This command is particularly useful for verifying that files have been successfully unloaded from a Snowflake table to the stage and for managing the files within the stage.

Reference: Snowflake Documentation on Stages

SnowPro® Core Certification Study Guide