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 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

Examples 

> REFRESH FOREIGN CATALOG some_catalog;

> REFRESH FOREIGN SCHEMA some_catalog.some_schema;

> REFRESH FOREIGN TABLE some_catalog.some_schema.some_table;