COF-C02 · Question #618
Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
The correct answer is A. Directory table. A directory table is an implicit object automatically overlaid on a Snowflake stage - either internal (Snowflake-managed) or external (e.g., S3, Azure Blob, GCS). It stores file-level metadata such as file path, size, last modified date, and ETag for files on that stage. Users…
Question
Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
Options
- ADirectory table
- BTemporary table
- CTransient table
- DA table with a materialized view
How the community answered
(64 responses)- A94% (60)
- B2% (1)
- C2% (1)
- D3% (2)
Explanation
A directory table is an implicit object automatically overlaid on a Snowflake stage - either internal (Snowflake-managed) or external (e.g., S3, Azure Blob, GCS). It stores file-level metadata such as file path, size, last modified date, and ETag for files on that stage. Users can query a directory table with SELECT to list staged files and then join that metadata with other data. It is not created explicitly; it is enabled on the stage with DIRECTORY = (ENABLE = TRUE).
Topics
Community Discussion
No community discussion yet for this question.