Output of a Snowflake directory table
Which columns are available in the output of a Snowflake directory table? (Choose two.)
❌ STAGE_NAME
✅ RELATIVE_PATH
✅ LAST_MODIFIED
❌ CATALOG_NAME
❌ FILE_NAME
A directory table is an implicit object layered on a stage (not a separate database object) and is conceptually similar to an external table because it stores file-level metadata about the data files in the stage. A directory table has no grantable privileges of its own.
Both external (external cloud storage) and internal (Snowflake) stages support directory tables. You can add a directory table to a stage when you create a stage (using CREATE STAGE
) or later (using ALTER STAGE
).