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 |
❌ |
❌ |
✔ |
✔ |
✔ |
Important
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: