Answer: SELECT * FROM DIRECTORY (@mystage)

The correct syntax to query a directory table in Snowflake is SELECT * FROM DIRECTORY(@mystage). This is explicitly documented in Snowflake's official documentation for querying directory tables. Option B follows this exact syntax pattern. Option A uses incorrect syntax with ::DIRECTORY, Option C uses non-existent TO_TABLE function, and Option D has incorrect parameter placement with DIRECTORY after the stage name. The community discussion shows 100% consensus on B with multiple references to Snowflake documentation confirming this is the proper syntax.

Author: LeetQuiz Editorial Team