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.

    View Description
    INFORMATION_SCHEMA.CATALOGS The information about the catalog that contains the metadata of a project.
    INFORMATION_SCHEMA.COLUMNS The metadata for all the columns within the tables and views in a project.
    INFORMATION_SCHEMA.SCHEMATA The metadata for the sources and spaces in a project.
    INFORMATION_SCHEMA.“TABLES” The metadata for the tables and views in a project.
    INFORMATION_SCHEMA.VIEWS The metadata for views in a project.