
Answer-first summary for fast verification
Answer: list @my_stage
The correct command to verify data in an external stage in Snowflake is LIST @my_stage. This command displays the files stored in the specified stage, allowing users to confirm that data has been successfully unloaded. The community discussion shows 100% consensus on option B, with multiple users confirming this is the correct Snowflake command. The official Snowflake documentation for the LIST command (referenced in the discussion) supports this as the proper method for inspecting stage contents. Other options like VIEW, SHOW, and DISPLAY are not valid Snowflake commands for checking stage data - VIEW is used for creating views, SHOW is for metadata about objects like stages themselves (not their contents), and DISPLAY is not a standard Snowflake SQL command.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.