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:

Language: English