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.jobs | The metadata for jobs currently running in the Dremio instance. |
| sys.membership | The metadata for role membership in the Dremio instance. |
| sys.privileges | The metadata for privileges for objects in the Dremio instance. |
| sys.reflection_dependencies | The metadata for reflections 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. |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.