INFORMATION_SCHEMA.CATALOGS
The INFORMATION_SCHEMA.CATALOGS view contains information about the catalog that contains the metadata of a project. This is the catalog in which the INFORMATION_SCHEMA resides. This view always contains a single row and returns DREMIO as the only catalog in the project.
Syntax
SELECT *
FROM INFORMATION_SCHEMA.CATALOGS
Example Output
| CATALOG_NAME | CATALOG_DESCRIPTION | CATALOG_CONNECT |
|---|---|---|
| DREMIO | The internal metadata used by Dremio | empty |
Fields
| Field | Data Type | Description |
|---|---|---|
| CATALOG_NAME | varchar | The name of the catalog, which is always DREMIO. |
| CATALOG_DESCRIPTION | varchar | The description for the catalog that contains metadata. |
| CATALOG_CONNECT | varchar | The connection permissions to the catalog that contains metadata information. This is an inherited field and is always empty. |