Skip to main content

Views

Views are virtual tables that presents data retrieved from one or more underlying models in Wren AI. It does not store data itself but rather displays data derived from the tables based on a predefined query.

Create a view​

Currently, the only way to create a view in Wren AI is by saving a result SQL statement as a view.

In Home page, we offer a save as view button in every answer that allows you to save the result SQLs as views.

create_view_1

create_view_2

View list​

You can access the list of saved views in the "Views" section of the sidebar on the Modeling page.

Click on the expand icon to see the columns in a view.

If you click on a view from the sidebar, Entity Relationship diagram will focus on the view you clicked.

view_list

Delete a view​

To delete a view:

  1. Click the "..." icon on the view diagram.
  2. Choose "Delete".

delete_view

Read the metadata of views​

To further understand your data, you can click on a view in the Entity Relationship diagram to view the metadata:

  • Name: View name
  • SQL statement: Saved SQL statement of the view.
  • Data Preview: By clicking Preview data, you can preview up to 100 rows of data from the view

view_metadata

Remember to deploy your changes

Deploy​

Please press the "Deploy" button on the navigation bar to synchronize any modifications in the Modeling page.

The navigation bar will show an Undeployed changes message if there are any new changes. undeployed

The navigation bar will show a synced message if all changes have been deployed. deployed