An Architect runs the following SQL query:
How can this query be interpreted?
An Architect runs the following SQL query:
How can this query be interpreted?
The SQL query is selecting the metadata, specifically the filename and the file row number, from a CSV file that is staged in a storage location referenced as FILEROWS. Here, FILE_ROW_NUMBER refers to the line number in the staged file, and FILEROWS is a stage where the file Food_Reviews.csv is stored. The file_format=CSV_N specifies the format of the file being read. Therefore, the correct interpretation is that FILEROWS is a stage and FILE_ROW_NUMBER is the line number in the file.
Answer is A and is validated
METADATA$FILE_ROW_NUMBER Row number for each record in the staged data file.