A data warehouse stores your data in a form suitable for analysis and decision making. Querying 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 view that holds students with a shortage of attendance with the help of queries.
Hevo provides an interface that let you use standard SQL to perform cross-table querying at specified frequencies on data warehouses. Let's understand how to use the query module.
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