INFORMATION_SCHEMA.CATALOGS (Databricks SQL)

Describes catalogs.

Information is displayed only for catalogs the user has permission to interact with.

Definition

The CATALOGS relation contains the following columns:

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

The following constraints apply to the CATALOG relation:

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

> SELECT catalog_owner
    FROM information_schema.catalogs
  system