REFRESH FOREIGN (CATALOG, SCHEMA, and TABLE)

Applies to: check marked yes Databricks Runtime 13.3 and later 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 USE CATALOG privilege on the catalog
Have BROWSE privilege on the catalog
Have BROWSE privilege on any schema under the catalog

To run REFRESH FOREIGN SHEMA, 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 and the USE SCHEMA privilege on the schema,
Have BROWSE privilege on the parent catalog, or
Have BROWSE privilege on the schema.

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

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,
Have BROWSE privilege on the parent catalog, or
Have BROWSE privilege on the parent schema.

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.

Examples

> REFRESH FOREIGN CATALOG some_catalog;

> REFRESH FOREIGN SCHEMA some_catalog.some_schema;

> REFRESH FOREIGN TABLE some_catalog.some_schema.some_table;