DESCRIBE CATALOG

Berlaku untuk:centang ditandai yaDatabricks SQL centang ditandai ya Databricks Runtime 10.4 LTS dan di atas centang ditandai ya Unity Catalog saja

Mengembalikan metadata katalog yang ada. Informasi metadata mencakup nama katalog, komentar, dan pemilik. Jika opsi opsional EXTENDED ditentukan, opsi tersebut menampilkan informasi metadata dasar bersama dengan properti katalog lainnya.

Sintaks

{ DESC | DESCRIBE } CATALOG [ EXTENDED ] catalog_name

Parameter

  • catalog_name: Nama katalog yang ada di metastore. Jika nama tidak ada, pengecualian akan ditampilkan.

Contoh

> 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
  • Last updated on