Answer-first summary for fast verification
Answer: To store file-level metadata about data files in a stage
The primary purpose of a directory table in Snowflake is to store file-level metadata about data files in a stage. This is clearly stated in the Snowflake documentation and confirmed by the community discussion with 100% consensus on option D. Directory tables provide metadata such as file names, sizes, last modified timestamps, and file URLs, allowing users to query and analyze the files in a stage without accessing the actual data content. Option A is incorrect because directory tables store metadata, not actual data. Option B is incorrect as file URL expiration is handled by other Snowflake features, not directory tables. Option C is incorrect because user privileges and access control are managed through Snowflake's security model, not directory tables.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the primary purpose of a directory table in Snowflake?
A
To store actual data from external stages
B
To automatically expire file URLs for security
C
To manage user privileges and access control
D
To store file-level metadata about data files in a stage
No comments yet.