select metadata$filename, metadata$file_row_number from @filestage/data1.json.gz;

select metadata$filename, metadata$file_row_number from @filestage/data1.json.gz;

Please select the correct statements for the above-mentioned query.
A . FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the row number for each record in the container staged data file
B. FILESTAGE is the file name, METADATA$FILE_ROW_NUMBER will give the path to the data file in the stage
C. FILESTAGE is the stage name, METADATA$FILE_ROW_NUMBER will give the path to the data
file in the stage

Answer: A

Explanation:

Metadata Columns

Currently, the following metadata columns can be queried or copied into tables:

METADATA$FILENAME

Name of the staged data file the current row belongs to. Includes the path to the data file in the stage.

METADATA$FILE_ROW_NUMBER

Row number for each record in the container staged data file. Please also go through the below link thoroughly https://docs.snowflake.com/en/user-guide/querying-metadata.html#metadata-columns