Automated directory table metadata refreshes

The metadata for a directory table can be refreshed automatically using the following event notification service for each cloud storage service:

The refresh operation synchronizes the metadata with the latest set of associated files in the external stage and path, i.e.:

  • New files in the path are added to the table metadata.

  • Changes to files in the path are updated in the table metadata.

  • Files no longer in the path are removed from the table metadata.

For setup instructions, see the topic for the cloud storage service where your files are located.

The following table indicates which cloud storage services are supported for automatically refreshing directory table metadata to your Snowflake account, based on the cloud platform that hosts your account:

Snowflake Account Host

Amazon S3

Google Cloud Storage

Microsoft Azure Blob storage

Microsoft Data Lake Storage Gen2

Microsoft Azure General-purpose v2

Amazon Web Services

Google Cloud Platform

Microsoft Azure

As the table indicates, cross-cloud support is currently only available to accounts hosted on Amazon Web Services.

Next Topics: