RELATIVE_PATH
TEXT
Path to the files to access using the file URL.
SIZE
NUMBER
Size of the file (in bytes).
LAST_MODIFIED
TIMESTAMP_LTZ
Timestamp when the file was last updated in the stage.
MD5
HEX
MD5 checksum for the file.
ETAG
HEX
ETag header for the file.
FILE_URL
TEXT
Snowflake file URL to the file.
RELATIVE_PATH
TEXT
Path to the files to access using the file URL.
SIZE
NUMBER
Size of the file (in bytes).
LAST_MODIFIED
TIMESTAMP_LTZ
Timestamp when the file was last updated in the stage.
MD5
HEX
MD5 checksum for the file.
ETAG
HEX
ETag header for the file.
FILE_URL
TEXT
Snowflake-hosted file URL to the file.
The correct answers are B and D.
The output of a Snowflake directory table includes the following columns:
FILE_NAME: The name of the file.
RELATIVE_PATH: The path of the file relative to the stage.
SIZE: The size of the file in bytes.
LAST_MODIFIED: The date and time the file was last modified.
FILE_URL: The Snowflake-hosted file URL to the file.
The other columns listed are not available in the output of a Snowflake directory table.
Hi. Can you paste the link where you saw the FILE_NAME? wanted to ensure if its in older version of Snowflake. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#output clearly mentions the columns.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
nexerSnow
9 months ago[Removed]
1 year agokayuhanbiduk
1 year agopvskbrod
1 year, 1 month agosinghks
1 year, 2 months agoSatyamKishore
1 year, 5 months agobee5k
1 year, 5 months agobee5k
1 year, 6 months agoRajivnb
1 year ago