CATALOGS

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

INFORMATION_SCHEMA.CATALOGS 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.

Constraints

The following constraints apply to the CATALOG 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
  system