Refreshing External Tables Automatically

Event notifications for cloud storage can trigger refreshes of the external table metadata or add or drop file references.

The following table indicates which cloud storage services are supported for automatically refreshing external 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


Transferring ownership on an external table or its parent database with the GRANT OWNERSHIP command sets the table’s AUTO_REFRESH property to FALSE. This blocks automatic refreshes of the table metadata. To restore automatic refreshes after you transfer ownership, set AUTO_REFRESH = TRUE using the ALTER EXTERNAL TABLE command.

Next Topics: