Skip to main content

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).

Dremio system tables are divided into namespaces:

  • Depending on whether the object is an organization or project-level object, the system table lives in the corresponding namespace. For example, clouds are an organization-level object, so the clouds system table is under the sys.organization namespace. For more information about the object model, see Objects in Dremio Cloud.
  • System tables can represent either the runtime state of an object, which reflects the current state of the system, or the history of an object. For example, sys.project.jobs represents the jobs that are running in the project at the table is queried whereas sys.project.history.jobs represents the jobs that have historically been run.

Runtime System Tables

The following system tables can be queried to return runtime metadata for the respective entities.

note

Only users who have been assigned the ADMIN role or users who have been granted SELECT privileges on one or more specific runtime system tables can run queries on those tables.

TablesDescription
sys.organization.cloudsThe runtime metadata for clouds in an organization.
sys.organization.privilegesThe runtime metadata for privileges at the organization-level.
sys.organization.projectsThe runtime metadata for projects in an organization.
sys.organization.rolesThe runtime metadata for roles in an organization.
sys.organization.usageThe runtime metadata for usage for projects/engines in the organization.
sys.organization.usersThe runtime metadata for users in an organization.
sys.project.enginesThe runtime metadata for engines in a project.
sys.project.jobsThe runtime metadata for jobs in a project.
sys.project.privilegesThe runtime metadata for privileges at the project-level.
sys.project.reflection_dependenciesThe runtime graph for reflection dependencies in a project.
sys.project.reflectionsThe runtime metadata for reflections in a project.
sys.project."tables"The runtime metadata for tables in a project.
sys.project.viewsThe runtime metadata for views in a project.

Historical System Tables

The following system tables can be queried to return historical metadata for the respective entities.

note

Only users who have been assigned the ADMIN role can run queries on historical system tables.

TablesDescription
sys.project.copy_errors_historyInformation about COPY INTO operations that were run with ON_ERROR set to continue and that rejected at least one record in a CSV or JSON file.
sys.project.history.eventsThe historical metadata for events in a project.
sys.project.history.jobsThe historical metadata for jobs in a project.
sys.project.materializationsMonitoring history for reflection materialization jobs in the Dremio instance.