For Directory tables, what stage allows for automatic refreshing of metadata?
A.
User stage
B.
Table stage
C.
Named internal stage
D.
Named external stage
The Answer Is:
D
This question includes an explanation.
Explanation:
For directory tables, a named external stage allows for the automatic refreshing of metadata. This capability is particularly useful when dealing with files stored on external storage services (like Amazon S3, Google Cloud Storage, or Azure Blob Storage) and accessed through Snowflake. The external stage references these files, and the directory table ' s metadata can be automatically updated to reflect changes in the underlying files.