September 4, 2021 - 1 minutes read

How to Add a View to a Data Model in Vertabelo

Dominika is a Python software developer. She graduated from the Warsaw University of Technology with a degree in computer science. At Vertabelo, she creates content as a technical writer. In her free time, she runs, practices yoga, and learns foreign languages.

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.

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

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

The columns should be updated successfully.