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 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
Related
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for