Answer: Named external stage

The question asks which stage allows for automatic refreshing of metadata in directory tables. According to Snowflake documentation and the community discussion with unanimous consensus (100% D), named external stages support automatic metadata refresh for directory tables. This functionality is specifically designed for external stages that reference cloud storage locations (AWS S3, Azure Blob Storage, Google Cloud Storage), allowing Snowflake to automatically detect and update metadata about files without manual intervention. User stages, table stages, and named internal stages do not support this automatic metadata refresh capability for directory tables.

Author: LeetQuiz Editorial Team