On this page

    SYS.“TABLES”

    The sys.“tables” table contains metadata for tables in the Dremio instance.

    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."tables"
    

    Example Output

    table_idsource_idtable_nameschema_idpathtagtypeformat_typeapprox_statistics_allowedcreatedowner_idowner_typemasking_policiesrow_access_policies
    00cf3b4c-4042-4474-bad8-3a5c8bb6ffe97c8f019b-2e48-4d40-8a2f-038dae416dc4CATALOGSempty text[INFORMATION_SCHEMA, CATALOGS]nqoL6Ab63EE=SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.880$unowned$$unowned$[][]
    ab94e588-6efa-4cbc-8641-6ac35887808f7c8f019b-2e48-4d40-8a2f-038dae416dc4COLUMNSempty text[INFORMATION_SCHEMA, COLUMNS]nn9iIx6sBXM=SYSTEM_TABLEempty textfalse2021-12-08 15:47:52.022$unowned$$unowned$[][]
    88bc523d-814c-464f-b794-b0a123da15c57c8f019b-2e48-4d40-8a2f-038dae416dc4SCHEMATAempty text[INFORMATION_SCHEMA, SCHEMATA]2B2bcqtiiRY=SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.922$unowned$$unowned$[][]
    776c727b-93a7-4ede-86de-f2c117b81aaa7c8f019b-2e48-4d40-8a2f-038dae416dc4TABLESempty text[INFORMATION_SCHEMA, TABLES]R2+uXXdzCD8=SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.953$unowned$$unowned$[][]
    448136c0-65d0-4182-af42-3f2015acec1d7c8f019b-2e48-4d40-8a2f-038dae416dc4VIEWSempty text[INFORMATION_SCHEMA, VIEWS]DzR2AE93Xi0=SYSTEM_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]1wa3yogWHHM=PHYSICAL_DATASETPARQUETfalse2021-12-10 06:56:55.364$unowned$$unowned$[function_name: “"@dremio".long_dist” args: “trip_distance” column_name: “distance_mi”][]
    a0f0edb3-b333-4c8e-880c-2d89648113f9bd02d9ed-9a1e-4fba-b59b-d0d74b6d7232zips.json8e7d637e-dc4f-4372-83cc-08e51bc81cc7[Samples, samples.dremio.com, zips.json]rFfpVH9umtQ=PHYSICAL_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: ARROW, AVRO, CSV, DELTA, EXCEL, FOLDER, HTTP_LOG, ICEBERG, ICEBERG_TABLE, ICEBERG_VIEW, JSON, ORC, PARQUET, PSV, TEXT, TSV, UNKNOWN, XLS, 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$
    masking_policiesvarcharThe masking policies set on the table.
    row_access_policiesvarcharThe row-access policies set on the table.