Refresh external tables automatically¶
Event notifications for cloud storage can start refreshes of the external table metadata or add or drop file references.
Important
If you transfer ownership on an external table or its parent database by using the GRANT OWNERSHIP command,
this 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
by using the ALTER EXTERNAL TABLE command.
Next topics: