Dremio Cloud
Dremio Software
 
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_id space_id view_name schema_id path tag type created sql_definition sql_context owner_id owner_type masking_policies row_access_policies
    e15aa988-fb0a-42a9-91ce-e8212144a2c3 f8c65f84-c4da-40df-8b90-c5c5e716b1e4 incidents empty text [test-space, incidents] a85f94a3-176b-40da-bb07-6c2c70cedd6f VIRTUAL_DATASET 2022-02-01 06:15:53.988 SELECT * FROM “SF_incidents2016.json” Samples.samples.dremio.com 80702009-37c5-454c-93f2-ec41ea1722ed USER_OWNER [function_name: “"@dremio".protect_ssn” args: “state” column_name: “name”] []
    36b8fcf5-78fa-4d78-9b5b-bad77b218895 f8c65f84-c4da-40df-8b90-c5c5e716b1e4 nyc-taxi empty text [test-space, nyc-taxi] bc7c91ee-e46f-49d5-a1a3-f52af0b08e1c VIRTUAL_DATASET 2022-02-01 06:02:35.407 SELECT * FROM “NYC-taxi-trips” Samples.samples.dremio.com 80702009-37c5-454c-93f2-ec41ea1722ed USER_OWNER [] []
    c84ea3fc-b962-4b8d-9d38-63a39d1097f8 f8c65f84-c4da-40df-8b90-c5c5e716b1e4 test-dataset2 empty text [test-space, test-dataset2] 62bf4c5a-2b5d-4b8f-873a-ab9e5aa81469 VIRTUAL_DATASET 2022-02-01 05:57:07.062 SELECT * FROM “NYC-taxi-trips” Samples.samples.dremio.com 80702009-37c5-454c-93f2-ec41ea1722ed USER_OWNER [] []

    Fields

    Field Data Type Description
    view_id varchar The UUID to identify the view.
    space_id varchar The UUID to identify the parent space that the view is saved under.
    view_name varchar The user- or system-defined name of the view.
    schema_id varchar The UUID for the schema/folder in which the view is contained.
    path varchar The string array representation of the path of the view.
    tag varchar The UUID that is generated to identify the instance of the view. Dremio changes this tag whenever a change is made to the view.
    type varchar The type of view.
    Enum: VIRTUAL_DATASET
    created timestamp The date and time that the view was created.
    sql_definition varchar The DDL statement that was used to create the view.
    sql_context varchar The context for the SQL definition.
    owner_id varchar The UUID for the owner (user or role) of the view. This UUID corresponds to the id in the users or roles system table.
    owner_type varchar The 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$
    masking_policies varchar The masking policies set on the view.
    row_access_policies varchar The row-access policies set on the view.