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.history.autonomous_reflections	The historical metadata for Autonomous Reflections.
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.