On this page

    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.