
Answer-first summary for fast verification
Answer: list @file_stage
The LIST command is the correct SQL command in Snowflake to display the files stored in a stage. According to Snowflake documentation, LIST @stage_name returns the files in the specified stage, which allows users to validate which data files were unloaded. The community discussion shows 100% consensus on option A with multiple users confirming that 'list @file_stage' is correct, and one comment directly references the official Snowflake documentation for the LIST command. Other options like SHOW, VIEW, and VERIFY are not valid Snowflake commands for listing stage files - SHOW is used for displaying database objects, VIEW for creating views, and VERIFY is not a standard Snowflake SQL command.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.