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. |