CATALOGS

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.2 and above check marked yes Unity Catalog only

INFORMATION_SCHEMA.CATALOGS describes catalogs.

Information is displayed only for catalogs 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.

Constraints

The following constraints apply to the CATALOGS relation:

Class

Name

Column List

Description

Primary key

CATALOGS_PK

CATALOG_NAME

Unique identifier for the catalog.

Examples 

> SELECT catalog_owner
    FROM information_schema.catalogs