Refreshing external tables automatically

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


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: