Skip to main content

Information Schema

Dremio stores metadata for the objects in your project in the Information Schema, which is a set of system-generated read-only views (cannot be modified or dropped). The Dremio Information Schema is based on the ANSI Information Schema.

The following views can be queried to return metadata for the respective catalog objects.

ViewDescription
INFORMATION_SCHEMA.CATALOGSThe information about the catalog that contains the metadata of a project.
INFORMATION_SCHEMA.COLUMNSThe metadata for all the columns within the tables and views in a project.
INFORMATION_SCHEMA.SCHEMATAThe metadata for the sources in a project.
INFORMATION_SCHEMA."TABLES"The metadata for the tables and views in a project.
INFORMATION_SCHEMA.VIEWSThe metadata for views in a project.