REFRESH FOREIGN (CATALOG, SCHEMA, and TABLE)

Applies to: check marked yes Databricks SQL Databricks Runtime 13.3 LTS and above Unity Catalog only

Refreshes the metadata maintained in Unity Catalog for a:

Foreign catalog and its securables,
Foreign schema and its securables, or
Foreign table.

To run REFRESH FOREIGN CATALOG, you need at least one of the following:

Be a metastore admin
Have the USE CATALOG privilege on the catalog, the USE SCHEMA privilege on all child schemas, and the SELECT privilege on all child tables

To run REFRESH FOREIGN SCHEMA, you need at least one of the following:

Be metastore admin
Be the owner of the parent catalog
Have USE CATALOG privilege on the parent catalog, the USE SCHEMA privilege on the schema, and the SELECT privilege on all child tables

To execute REFRESH FOREIGN TABLE you need at least one of the following:

Be metastore admin
Be the owner of the parent catalog
Be the owner of the parent schema and have the USE CATALOG privilege on the parent catalog
Have USE CATALOG and USE SCHEMA privileges on the parent catalog and schema, respectively, and the SELECT privilege on the table

Syntax

REFRESH FOREIGN
 { CATALOG foreign_catalog_name |
   SCHEMA foreign_schema_name |
   TABLE foreign_table_name }

Parameters

foreign_catalog_name

Identifies the foreign catalog to refresh.
foreign_schema_name

Identifies the foreign schema to refresh.
foreign_table_name

Identifies the foreign table to refresh. The name must not include a temporal specification or options specification.

Examples

> REFRESH FOREIGN CATALOG some_catalog;

> REFRESH FOREIGN SCHEMA some_catalog.some_schema;

> REFRESH FOREIGN TABLE some_catalog.some_schema.some_table;