Which command is used to determine the file name of each row of data from a staged file?
Which command is used to determine the file name of each row of data from a staged file?
The correct command to determine the file name of each row of data from a staged file is 'SELECT METADATA$FILENAME'. This option directly specifies that it retrieves the file name, which is what the question asks for.
https://docs.snowflake.com/en/user-guide/querying-metadata