CATALOGS

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only

INFORMATION_SCHEMA.CATALOGS describes catalogs.

Information is displayed only for catalogs bound to the current workspace that the user has permission to interact with.

This is an extension to the SQL Standard Information Schema.

Definition

The CATALOGS relation contains the following columns:

Name	Data type	Nullable	Description
`CATALOG_NAME`	`STRING`	No	Name of the catalog.
`CATALOG_OWNER`	`STRING`	No	Owner of the catalog.
`COMMENT`	`STRING`	Yes	An optional comment that describes the catalog.
`CREATED`	`TIMESTAMP`	No	Timestamp when the catalog was created.
`CREATED_BY`	`STRING`	No	Principal who created the catalog.
`LAST_ALTERED`	`TIMESTAMP`	No	Timestamp when the catalog was last altered in any way.
`LAST_ALTERED_BY`	`STRING`	No	Principal who last altered the catalog.

The following constraints apply to the CATALOGS relation:

Class	Name	Column List	Description
Primary key	`CATALOGS_PK`	`CATALOG_NAME`	Unique identifier for the catalog.

SQL
> SELECT catalog_owner
    FROM information_schema.catalogs