REFRESH FOREIGN (CATALOG, SCHEMA, and TABLE)
Applies to: 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 catalogHave
BROWSE
privilege on the catalogHave
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 theUSE SCHEMA
privilege on the schema,Have
BROWSE
privilege on the parent catalog, orHave
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
andUSE SCHEMA
privileges on the parent catalog and schema, respectively, and theSELECT
privilege on the table,Have
BROWSE
privilege on the parent catalog, orHave
BROWSE
privilege on the parent schema.
Syntax
REFRESH FOREIGN
{ CATALOG foreign_catalog_name |
SCHEMA foreign_schema_name |
TABLE foreign_table_name }
Parameters
-
Identifies the foreign catalog to refresh.
-
Identifies the foreign schema to refresh.
-
Identifies the foreign table to refresh. The name must not include a temporal specification.