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 stage?
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 stage?
To view the list of files that have been uploaded to an internal stage, the correct command is 'list @mystage;'. In Snowflake, the '@' symbol denotes a stage location, and 'mystage' specifies the name of the internal stage. The other options either incorrectly reference a table stage or prepend the '%' symbol, which is not needed in this context.
https://docs.snowflake.com/en/sql-reference/sql/list.html
User Stage should start with @~ Table Stage should start with @% Named Stage or Internal Stage of Snowflake is just @.
B. list @%mytable; -- copy into @%mytable FROM mytable; D. list @mystage; -- copy into @mystage FROM mytable;
correct answer
Correct Answer D
D. list @mystage;