Skip to main content

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_NAMECATALOG_DESCRIPTIONCATALOG_CONNECT
DREMIOThe internal metadata used by Dremioempty

Fields

FieldData TypeDescription
CATALOG_NAMEvarcharThe name of the catalog, which is always DREMIO.
CATALOG_DESCRIPTIONvarcharThe description for the catalog that contains metadata.
CATALOG_CONNECTvarcharThe connection permissions to the catalog that contains metadata information. This is an inherited field and is always empty.