Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 631

Which columns are available in the output of a Snowflake directory table? (Choose two.)

    Correct Answer: C, D

    The columns available in the output of a Snowflake directory table include LAST_MODIFIED, which records the date and time the file was last modified, and RELATIVE_PATH, which specifies the path of the file relative to the stage. These two columns are essential for managing files in Snowflake's directory tables.

Discussion
nexerSnowOptions: CD

acc. to https://docs.snowflake.com/en/user-guide/data-load-dirtables-query

Ram9198Options: CD

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.

pvskbrodOptions: CD

https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#output

SatyamKishoreOptions: CD

CD https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#output

bee5kOptions: BD

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.

Rajivnb

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.

kayuhanbidukOptions: CD

CD. RELATIVE_PATH, LAST_MODIFIED

singhksOptions: CD

https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#output

bee5kOptions: CD

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.