A data warehouse must store your data in a form suitable for analysis and decision making. Creating Models helps you organize data present in your data warehouse. For example, you have a record of attendance of all students in a university and you want to notify students with a shortage of attendance. You can create a model that holds students with a shortage of attendance with the help of queries.
Hevo provides an interface that let you use standard SQL to create (and refresh) Models at specified frequencies or a schedule. Let's understand how to use Models.
Navigating to Models
You can navigate to Models section by clicking MODELS link on the left navigation bar.
View Model Details
A list of existing models is shown in the pane that appears on clicking MODELS link on the left navigation bar. Click on a model to show details of the same.
The Model details page will show you the following details in the header section at the top of the page:
- Name of the Model
- Current Status of the Model
- The destination with which the Model is associated
- The last run time of the Model
- The frequency at which the Model is refreshed