Which query will display the stage metadata including file name and row number?

• A. SELECT metadata$filename, metadata$file_row_number FROM @my_stage
• B. SELECT metadata$filename, metadata$file_row_id FROM @my_stage
• C. SELECT metadata$file, metadata$file_row_number FROM @my_stage
• D. SELECT metadata$ROW_ID, metadata$ROW_NUMBER FROM @my_stage

Answer: (A)

In Snowflake, querying a stage as a table exposes special metadata columns that describe the files and their contents. The metadata that specifically gives you the file name and the row position within that file are metadata$filename and metadata$file_row_number. Selecting these from the stage @my_stage will return, for each row of data, the file it came from and the row’s position inside that file.

The other options use column names that aren’t valid stage metadata, so they won’t produce the requested information as reliably. metadata$file_row_id, metadata$file, and metadata$ROW_ID/metadata$ROW_NUMBER aren’t recognized stage metadata columns in this context.