REFRESH FOREIGN (CATALOG, SCHEMA, and TABLE)

Applies to: check marked yes Databricks SQL Databricks Runtime 13.3 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 USE CATALOG privilege on the catalog

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

Be metastore admin,
Be the owner of the parent catalog, or
Have USE CATALOG privilege on the parent catalog and the USE SCHEMA privilege on the schema

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, or
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.

Examples

> REFRESH FOREIGN CATALOG some_catalog;

> REFRESH FOREIGN SCHEMA some_catalog.some_schema;

> REFRESH FOREIGN TABLE some_catalog.some_schema.some_table;