Skip to main content

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.