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).
note
In Dremio 20+, the sys.dependencies table has been renamed to sys.reflection_dependencies.
| Tables | Description |
|---|---|
| sys.copy_errors_history | Information 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.copy_file_history | The history of every file loaded by an autoingest pipeline. |
| sys.jobs | The metadata for jobs currently running in the Dremio instance. |
| sys.jobs_recent | The metadata for jobs that ran in the Dremio instance during the previous thirty days. |
| sys.materializations | Monitoring history for reflection materialization jobs in the Dremio instance. |
| sys.membership | The metadata for role membership in the Dremio instance. |
| sys.pipe_summary | The historical metadata for autoingest pipes. |
| sys.privileges | The metadata for privileges for objects in the Dremio instance. |
| sys.pipes | The metadata for autoingest pipes. |
| sys.reflection_dependencies | The runtime graph for reflection dependencies in the Dremio instance. |
| sys.reflections | The metadata for reflections in the Dremio instance. |
| sys.roles | The metadata for roles in the Dremio instance. |
| sys."tables" | The metadata for tables in the Dremio instance. |
| sys.timezone_names | The complete list of timezones and associated information. |
| sys.user_defined_functions | The metadata for the user defined functions (UDFs) installed in the Dremio instance. |
| sys.users | The metadata for users in the Dremio instance. |
| sys.version | The metadata for the version of Dremio software that is deployed. |
| sys.views | The metadata for views in the Dremio instance. |