Author: Dominika Florczykowska
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.
What Are Additional SQL Scripts and What Do You Use Them For in Vertabelo?
Sometimes you need to perform actions that you can’t directly model in Vertabelo. For example, you might want to define functions or stored procedures, add users, or set permissions for objects such as tables or views. This can be done using additional SQL scripts. Here’s how. Open your model. On the right, you can see the Model properties menu. Click Additional SQL scripts. You can set scripts to run at the beginning or end of a create script or at the beginning or end of a drop script.
How to Import a DDL Script into Vertabelo
What if you have a DDL script (i.e. an SQL script that defines data structures) and you would like to visualise it by creating a model of the database? This can be done in Vertabelo by importing the SQL script. Open your model. Click on the model name in the upper-left corner. Click Import and Import from SQL. A new window will appear. Click Browse to add a file from your computer.
How to Import a Vertabelo XML File into Vertabelo
Sometimes it’s useful to generate a model based on a saved configuration. Vertabelo models can be exported as XML files; later on, these files can be imported back to Vertabelo to create a model. This can be helpful, e.g. for backups. Open your model. Click on the model name in the upper-left corner. Click Import and then Import from XML. Click Browse to choose a file from your computer.
Vertabelo Document Types
There are various document types in Vertabelo: folders, physical data models, logical data models, and SQL scripts. What do they do, and how can you tell them apart visually? Go to your drive. In the right panel, you’ll find folders, which are designated by this icon . Folders can contain documents or other folders. Inside folders you can place: logical data models, physical data models and SQL scripts.
Vertabelo Feature: Google BigQuery Support
Cloud databases are becoming more and more popular. That’s why Vertabelo has added support for Google BigQuery, one of the most popular cloud databases. BigQuery is an enterprise data warehouse that enables the storing and very fast processing of huge data sets. It can be useful in data analytics, machine learning, and other areas. If you’re working with multiple Cloud databases, check out our articles on Amazon Redshift and how to model a Redshift database in Vertabelo.
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).
Vertabelo Feature: Snowflake Support
Vertabelo Feature: Snowflake Support Cloud and analytical databases are very popular and are becoming more important. Snowflake has been one of the most popular feature requests on our support page and a much-anticipated database for Vertabelo support. We are happy to announce that Snowflake databases can now be designed with Vertabelo! In this article, we’ll explain how to create a physical ER diagram for a Snowflake database in Vertabelo. Remember that you can also choose to create a logical ER diagram first and then use that to generate a physical ER diagram.
How to Export Your Vertabelo Model as an Image
Did you know that you can export your data models as images? Here’s how to do it in Vertabelo: Open your model. On the top menu bar, click this icon . A new window will appear. Choose the image file type you want to export to. You can also choose whether to export the whole model or only the selected part. Then click Generate. When the file is ready, you can download it by clicking the Download button.
How to Publish Your Vertabelo Model on the Web
Sometimes you would like to embed your Vertabelo data model into a website or send it to other people. You can do that easily with the Publish to Web option in Vertabelo. Open your model and click on its name in the upper-left corner. Then click Publish to Web. A new window will appear. Click Publish. You can copy a link to your model or a script for embedding it in a website.
How to Rename a Vertabelo Model
What if you want to change a model’s name? It’s easy! Simply follow the instructions below. Open the drive. Find the document that needs to have its name changed and right-click on it. Then click Rename. A new window will appear. Type the new name and click Rename. It works!