On this page

    INFORMATION_SCHEMA.SCHEMATA

    The INFORMATION_SCHEMA.SCHEMATA view contains metadata for the sources, spaces in a project. Embedded folders within a space, for example, Samples.samples.dremio.com, which contain datasets are also represented as a schema.

    Syntax
    SELECT * 
    FROM INFORMATION_SCHEMA.SCHEMATA
    

    Example Output

    CATALOG_NAMESCHEMA_NAMESCHEMA_OWNERTYPEIS_MUTABLE
    DREMIO$scratch<owner>SIMPLENO
    DREMIO@user1@dremio.com<owner>SIMPLENO
    DREMIOINFORMATION_SCHEMA<owner>SIMPLENO
    DREMIOSamples<owner>SIMPLENO
    DREMIOSamples.samples.dremio.com<owner>SIMPLENO
    DREMIOSamples.samples.Dremio University<owner>SIMPLENO
    DREMIOsys<owner>SIMPLENO
    DREMIOsys.cache<owner>SIMPLENO
    DREMIOtest<owner>SIMPLENO
    DREMIOWeather<owner>SIMPLENO

    Fields

    FieldData TypeDescription
    CATALOG_NAMEvarcharName of the catalog, which is always DREMIO.
    SCHEMA_NAMEvarcharPath (source, space, folders) that contains datasets.
    SCHEMA_OWNERvarcharOwner of the schema. This is an inherited field and <owner> is always returned.
    TYPEvarcharType of the schema, which is always SIMPLE.
    IS_MUTABLEvarcharThe value in this column is YES if the schema can be modified. NO if it’s immutable.