SYS.PROJECT.VIEWS
The sys.project.views table contains metadata for views in a project.
note
You may not see some rows in the table if you do not have access to the metadata storage container.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| de457607-d655-4fa7-9428-62f89c9e32c3 | 9c7943bc-8560-4cf2-bbbf-45b126df6840 | taxi | empty text | [dev, taxi] | 00000-9b5ddf31-4a41-8876-b7f1-c362801236db | NESSIE_VIEW | 2023-06-21 18:36:58.011 | SELECT * FROM nyc_taxi_trips | [dev] | $unowned$ | $unowned$ | [] | [] |
| 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, NESSIE_VIEW |
| 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. |