Dremio Cloud
Dremio Software
 
On this page

    INFORMATION_SCHEMA.“TABLES”

    The INFORMATION_SCHEMA.“TABLES” view contains metadata for the tables and views in a project.

    note:

    The name of the view must be encapsulated in quotes (“TABLES”) so that it is parsed as the view name instead of the reserved keyword table.

    Syntax 
    SELECT * 
FROM INFORMATION_SCHEMA."TABLES"

    Example Output

    TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
    DREMIO INFORMATION_SCHEMA CATALOGS SYSTEM_TABLE
    DREMIO INFORMATION_SCHEMA COLUMNS SYSTEM_TABLE
    DREMIO INFORMATION_SCHEMA SCHEMATA SYSTEM_TABLE
    DREMIO INFORMATION_SCHEMA TABLES SYSTEM_TABLE
    DREMIO INFORMATION_SCHEMA VIEWS SYSTEM_TABLE
    DREMIO sys boot SYSTEM_TABLE
    DREMIO Weather SFWeatherElevation VIEW
    DREMIO Samples.samples.dremio.com SF weather 2018-2019.csv TABLE
    DREMIO Samples.samples.dremio.com SF_incidents2016.json TABLE
    DREMIO sys.cache datasets SYSTEM_TABLE

    Fields

    Field Data Type Description
    TABLE_CATALOG varchar Name of the catalog, which is always DREMIO.
    TABLE_SCHEMA varchar The path (source, space, folders) to the table or view.
    TABLE_NAME varchar The name of the table or view.
    TABLE_TYPE varchar The type of the object.
    Enum: SYSTEM_TABLE, TABLE, VIEW