DESCRIBE CATALOG
适用于: Databricks SQL Databricks Runtime 10.4 LTS 及更高版本 仅 Unity Catalog
返回现有目录的元数据。 元数据信息包括目录名称、注释和所有者。
如果指定了可选的 EXTENDED
选项,则它将返回基本元数据信息以及其他目录属性。
语法
{ DESC | DESCRIBE } CATALOG [ EXTENDED ] catalog_name
参数
- catalog_name:元存储中现有目录的名称。 如果该名称不存在,则会引发异常。
示例
> DESCRIBE CATALOG main;
info_name info_value
------------ ------------------------------------
Catalog Name main
Comment Main catalog (auto-created)
Owner metastore-admin-users
Catalog Type Regular
> DESCRIBE CATALOG EXTENDED main;
info_name info_value
------------ ------------------------------------
Catalog Name main
Comment This is a reserved catalog in Spark.
Comment Main catalog (auto-created)
Owner metastore-admin-users
Catalog Type Regular
Created By
Created At
Updated By
Updated At
-- A catalog from a Delta Sharing share
> DESCRIBE CATALOG vaccinedata;
info_name info_value
------------ ------------------------------------
Catalog Name vaccinedata
Comment
Owner alwaysworks@databricks.com
Catalog Type Delta Sharing