On this page

    SYS.PROJECT.VIEWS

    The sys.project.views table contains metadata for views in a project.

    Syntax
    SELECT * 
    FROM sys.project.views
    

    Example Output

    view_idspace_idview_nameschema_idpathtagtypecreatedsql_definitionsql_contextowner_idowner_type
    e15aa988-fb0a-42a9-91ce-e8212144a2c3f8c65f84-c4da-40df-8b90-c5c5e716b1e4incidentsempty text[test-space, incidents]a85f94a3-176b-40da-bb07-6c2c70cedd6fVIRTUAL_DATASET2022-02-01 06:15:53.988SELECT * FROM “SF_incidents2016.json”Samples.samples.dremio.com80702009-37c5-454c-93f2-ec41ea1722edUSER_OWNER
    36b8fcf5-78fa-4d78-9b5b-bad77b218895f8c65f84-c4da-40df-8b90-c5c5e716b1e4nyc-taxiempty text[test-space, nyc-taxi]bc7c91ee-e46f-49d5-a1a3-f52af0b08e1cVIRTUAL_DATASET2022-02-01 06:02:35.407SELECT * FROM “NYC-taxi-trips”Samples.samples.dremio.com80702009-37c5-454c-93f2-ec41ea1722edUSER_OWNER
    c84ea3fc-b962-4b8d-9d38-63a39d1097f8f8c65f84-c4da-40df-8b90-c5c5e716b1e4test-dataset2empty text[test-space, test-dataset2]62bf4c5a-2b5d-4b8f-873a-ab9e5aa81469VIRTUAL_DATASET2022-02-01 05:57:07.062SELECT * FROM “NYC-taxi-trips”Samples.samples.dremio.com80702009-37c5-454c-93f2-ec41ea1722edUSER_OWNER

    Fields

    FieldData TypeDescription
    view_idvarcharThe UUID to identify the view.
    space_idvarcharThe UUID to identify the parent space that the view is saved under.
    view_namevarcharThe user- or system-defined name of the view.
    schema_idvarcharThe UUID for the schema/folder in which the view is contained.
    pathvarcharThe string array representation of the path of the view.
    tagvarcharThe UUID that is generated to identify the instance of the view. Dremio changes this tag whenever a change is made to the view.
    typevarcharThe type of table.
    Enum: VIRTUAL_DATASET
    createdtimestampThe date and time that the view was created.
    sql_definitionvarcharThe DDL statement that was used to create the view.
    sql_contextvarcharThe context for the SQL definition.
    owner_idvarcharThe UUID for the owner (user or role) of the view. This UUID corresponds to the id in the users or roles system table.
    owner_typevarcharThe type of owner of the view. This value will be $unowned$ if ownership has not been granted for the view.
    Enum: USER_OWNER, ROLE_OWNER, $unowned$