- All Exams Instant Download
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
Latest ARA-C01 Dumps Valid Version with 156 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments