Skip to main content

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_typemasking_policiesrow_access_policies
de457607-d655-4fa7-9428-62f89c9e32c39c7943bc-8560-4cf2-bbbf-45b126df6840taxiempty text[dev, taxi]00000-9b5ddf31-4a41-8876-b7f1-c362801236dbNESSIE_VIEW2023-06-21 18:36:58.011SELECT * FROM nyc_taxi_trips[dev]$unowned$$unowned$[][]
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[function_name: "\"@dremio\".protect_ssn" args: "state" column_name: "name"][]
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 view.
Enum: VIRTUAL_DATASET, NESSIE_VIEW
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$
masking_policiesvarcharThe masking policies set on the view.
row_access_policiesvarcharThe row-access policies set on the view.