On this page

    SYS.PROJECT.“TABLES”

    The sys.project.“tables” table contains metadata for tables in a project.

    note:

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

    Syntax
    SELECT * 
    FROM sys.project."tables"
    

    Example Output

    table_idsource_idtable_nameschema_idpathtagtypeformat_typeapprox_statistics_allowedcreatedowner_idowner_type
    00cf3b4c-4042-4474-bad8-3a5c8bb6ffe97c8f019b-2e48-4d40-8a2f-038dae416dc4CATALOGSempty text[INFORMATION_SCHEMA, CATALOGS]3c6ac367-02f3-4391-bd05-d426934694a0SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.880$unowned$$unowned$
    ab94e588-6efa-4cbc-8641-6ac35887808f7c8f019b-2e48-4d40-8a2f-038dae416dc4COLUMNSempty text[INFORMATION_SCHEMA, COLUMNS]ff81a410-957b-4e14-b8c2-b294ff1fd512SYSTEM_TABLEempty textfalse2021-12-08 15:47:52.022$unowned$$unowned$
    88bc523d-814c-464f-b794-b0a123da15c57c8f019b-2e48-4d40-8a2f-038dae416dc4SCHEMATAempty text[INFORMATION_SCHEMA, SCHEMATA]b34d280e-63fb-4e07-bfb2-f4db2436f40cSYSTEM_TABLEempty textfalse2021-12-08 15:47:51.922$unowned$$unowned$
    776c727b-93a7-4ede-86de-f2c117b81aaa7c8f019b-2e48-4d40-8a2f-038dae416dc4TABLESempty text[INFORMATION_SCHEMA, TABLES]b9b41929-bf55-4410-8a6c-00fd30a89585SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.953$unowned$$unowned$
    448136c0-65d0-4182-af42-3f2015acec1d7c8f019b-2e48-4d40-8a2f-038dae416dc4VIEWSempty text[INFORMATION_SCHEMA, VIEWS]e8b7dc13-134c-4613-b749-918eb3b04e11SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.987$unowned$$unowned$
    eb5e9ee9-dbd7-40a8-b48a-5aa0170383fdbd02d9ed-9a1e-4fba-b59b-d0d74b6d7232NYC-taxi-trips8e7d637e-dc4f-4372-83cc-08e51bc81cc7[Samples, samples.dremio.com, NYC-taxi-trips]5e88d477-0bae-41f7-8865-2c0dd1d89e1aPHYSICAL_DATASETPARQUETfalse2021-12-10 06:56:55.364$unowned$$unowned$
    a0f0edb3-b333-4c8e-880c-2d89648113f9bd02d9ed-9a1e-4fba-b59b-d0d74b6d7232zips.json8e7d637e-dc4f-4372-83cc-08e51bc81cc7[Samples, samples.dremio.com, zips.json]518dcb2a-9e34-45af-a09a-0e335d5cced8PHYSICAL_DATASETJSONfalse2022-01-05 22:10:42.528$unowned$$unowned$

    Fields

    FieldData TypeDescription
    table_idvarcharThe UUID to identify the table.
    source_idvarcharThe UUID to identify the source that the table is associated with.
    table_namevarcharThe user- or system-defined name of the table.
    schema_idvarcharThe UUID for the schema/folder in which the table is contained.
    pathvarcharThe string array representation of the path of the table.
    tagvarcharThe UUID that is generated to identify the instance of the table. Dremio changes this tag whenever a change is made to the table.
    typevarcharThe type of table.
    Enum: PHYSICAL_DATASET, SYSTEM_TABLE
    format_typevarcharThe format type of the data.
    Enum: JSON, PARQUET, TEXT, empty text
    approx_statistics_allowedbooleanWhen set, COUNT DISTINCT queries will return approximate results. This value will be true if approximate results will be returned and false otherwise.
    createdtimestampThe date and time that the table was created.
    owner_idvarcharThe UUID for the owner (user or role) of the table. This UUID corresponds to the id in the users or roles system table.
    owner_typevarcharThe type of owner of the table. This value will be $unowned$ if ownership has not been granted for the table.
    Enum: USER_OWNER, ROLE_OWNER, $unowned$