Hevo Models help you transform the data loaded by Hevo pipelines in the Destination data warehouse into a form conducive for a BI tool to perform analytics and reporting.
Hevo allows you to leverage the SQL query capability of the data warehouse to build the required data-model (dimensions and facts). You can define a Hevo Model using an SQL query (SELECT query). At runtime, Hevo executes the query against the data warehouse, and results are exported to another table in the warehouse. A complex SQL query (including joins, aggregates) can also be provided for more complex requirements. Hevo supports all query capabilities supported by your data warehouse.
To access Models, click Transform in the Asset Palette. It opens the Models List View page by default. You can view your existing models or create new ones.
Several new features have been introduced in Models in Release 1.44. To leverage these features in designing and using Models, you can update your legacy models to the new version of Models. Read about Updating Legacy Models.
- Key Features
- Types of Models
- Familiarizing with the Models UI
- Creating and Modifying Models
- Previewing a Model
- Viewing the Query History for a Model
- Legacy Models