On this page

    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.

    INFORMATION_SCHEMA.CATALOGSThe information about the catalog that contains the metadata of a project.
    INFORMATION_SCHEMA.COLUMNSThe metadata for all the columns within the physical and virtual datasets in a project.
    INFORMATION_SCHEMA.SCHEMATAThe metadata for the sources and spaces in a project.
    INFORMATION_SCHEMA.“TABLES”The metadata for the physical and virtual datasets in a project.
    INFORMATION_SCHEMA.VIEWSThe metadata for virtual datasets in a project.