REFRESH_SOURCE_TABLE_METADATA¶

Description

The stored procedure REFRESH_SOURCE_TABLE_METADATA updates the partitions information of the desired source table.

Syntax

REFRESH_SOURCE_TABLE_METADATA (
      database_name : varchar
    , base_view_name : varchar
)

Note

Currently, this feature is only supported by PrestoDB data sources.

The procedure returns this field:

procedure_status: Success if the procedure executed correctly, Failure otherwise.

Privileges Required

The user that executes this procedure must have at least WRITE privileges on view and EXECUTE privileges on the targeted data source.

Example

CALL REFRESH_SOURCE_TABLE_METADATA('db', 'test_view');

This will update the partitions information on the source table pointed by test_view.

USER MANUALS