Which Snowflake URL type is used by directory tables?
Which Snowflake URL type is used by directory tables?
Directory tables in Snowflake store file-level metadata about data files in a stage. When queried, they provide Snowflake-hosted file URLs that allow prolonged access to specific files, and these file URLs do not expire. This makes the 'File' URL type the correct choice for directory tables.
Conceptually, directory tables are similar to external tables in that they store file-level metadata about the data files in a stage. Query a directory table to retrieve the Snowflake-hosted file URL to each file in the stage. A file URL permits prolonged access to a specified file. That is, the file URL does not expire. The same file URL is returned by calling the BUILD_STAGE_FILE_URL function.
A is the correct answer
A. You can query a directory table to retrieve a list of the file URLs in the stage along with their relative path, size, date the file was last modified, md5 hash, and ETag using this command: select * from directory (@my_csv_stage)
file ansver A
https://docs.snowflake.com/en/user-guide/data-load-dirtables#:~:text=Directory%20tables%20store%20a%20catalog%20of%20staged%20files%20in%20cloud%20storage.%20Roles%20with%20sufficient%20privileges%20can%20query%20a%20directory%20table%20to%20retrieve%20file%20URLs%20to%20access%20the%20staged%20files%2C%20as%20well%20as%20other%20metadata.
Answer is correct
Correction A is correct.