ALTER EXTERNAL TABLE
Description
This statement is used to manually update the files of an external table. Data in a single file can be automatically updated, but if the data of an external table comes from a list of files, it cannot be automatically updated and requires a manual refresh.
Syntax
ALTER EXTERNAL TABLE table_name REFRESH;
Parameters
table_name specifies the name of the external table to refresh.
Examples
ALTER EXTERNAL TABLE lineitem REFRESH;
Query OK, 0 rows affected