On this page

    System Tables

    System tables make up Dremio’s system-created catalog to store metadata for the objects in your Dremio organization. Each system table is specific to the associated Dremio object and its attributes, unlike Information Schemas, which are based on the ANSI standards. System tables are read-only (cannot be modified or dropped by users).

    TablesDescription
    sys.jobsThe metadata for jobs currently running in the Dremio instance.
    sys.membershipThe metadata for role membership in the Dremio instance.
    sys.privilegesThe metadata for privileges for objects in the Dremio instance.
    sys.reflection_dependenciesThe metadata for reflections dependencies in the Dremio instance.
    sys.reflectionsThe metadata for reflections in the Dremio instance.
    sys.rolesThe metadata for roles in the Dremio instance.
    sys.“tables”The metadata for tables in the Dremio instance.
    sys.timezone_namesThe complete list of timezones and associated information.
    sys.user_defined_functionsThe metadata for the user defined functions (UDFs) installed in the Dremio instance.
    sys.usersThe metadata for users in the Dremio instance.
    sys.versionThe metadata for the version of Dremio software that is deployed.
    sys.viewsThe metadata for views in the Dremio instance.