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.