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 (joins, aggregates, etc) can also be provided for more complex requirements. Hevo supports all query capabilities supported by your data warehouse.

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.

See Also

Last updated on 26 Aug 2020