Table Functions

Table functions are special SQL functions that return tabular data and can be used in the FROM clause of a query, similar to querying a table or view. All table functions in Dremio are part of the sys schema and are read-only.

Unlike system tables, which are tables in Dremio's system-created catalog containing metadata about Dremio objects, table functions can accept parameters and perform computations to return customized result sets.

Table functions are particularly useful for analyzing relationships between objects in Dremio, such as Reflection dependencies and refresh settings. See below for a list of available table functions.

Table Function	Description
sys.reflection_lineage	The Reflections that will also be refreshed if a refresh is triggered for a particular Reflection.
sys.reflection_refresh_settings	Returns the refresh settings for a Reflection, including settings inherited from the datasets that the Reflection depends on.