REFRESH FOREIGN (CATALOG, SCHEMA, and TABLE)

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 13.3 LTS and above check marked yes 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

Examples

> REFRESH FOREIGN CATALOG some_catalog;

> REFRESH FOREIGN SCHEMA some_catalog.some_schema;

> REFRESH FOREIGN TABLE some_catalog.some_schema.some_table;