Back to articles list
- 1 minutes read

How to Add a View to a Data Model in Vertabelo

Views are essential in cases where we want to save our SQL query and then refer to its data using SELECT * FROM VIEW_NAME. In short, views allow us to save complex queries for future use. So, how can we add them to a data model?

On the left panel, right-click Views and click Add view. Alternatively, you can also click this icon on the top menu bar or use the keyboard shortcut (simply type 5).

How to Add a View to a Data Model in Vertabelo

A view will appear on the diagram. When you click on the view, you’ll see the View properties menu to the right. Here you can change the view’s name or update the SQL query it runs.

How to Add a View to a Data Model in Vertabelo

After updating the query, scroll down and click Update columns.

How to Add a View to a Data Model in Vertabelo

Verify the columns that will be created and click Update columns.

How to Add a View to a Data Model in Vertabelo

The columns should be updated successfully.

How to Add a View to a Data Model in Vertabelo
go to top