Dremio Cloud
Dremio Software
 
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_NAME SCHEMA_NAME SCHEMA_OWNER TYPE IS_MUTABLE
    DREMIO $scratch <owner> SIMPLE NO
    DREMIO @user1@dremio.com <owner> SIMPLE NO
    DREMIO INFORMATION_SCHEMA <owner> SIMPLE NO
    DREMIO Samples <owner> SIMPLE NO
    DREMIO Samples.samples.dremio.com <owner> SIMPLE NO
    DREMIO Samples.samples.Dremio University <owner> SIMPLE NO
    DREMIO sys <owner> SIMPLE NO
    DREMIO sys.cache <owner> SIMPLE NO
    DREMIO test <owner> SIMPLE NO
    DREMIO Weather <owner> SIMPLE NO

    Fields

    Field Data Type Description
    CATALOG_NAME varchar Name of the catalog, which is always DREMIO.
    SCHEMA_NAME varchar Path (source, space, folders) that contains datasets.
    SCHEMA_OWNER varchar Owner of the schema. This is an inherited field and <owner> is always returned.
    TYPE varchar Type of the schema, which is always SIMPLE.
    IS_MUTABLE varchar The value in this column is YES if the schema can be modified. NO if it’s immutable.