SQL Models

Last updated on Sep 21, 2023

Hevo Models help you transform the data that you have loaded to the Destination using Hevo Pipelines into a form conducive for a BI tool to perform analytics and reporting.

You can leverage the SQL query capability of the data warehouse or database to build the required data Model (dimensions and facts). Each Model uses a single SELECT query. At runtime, Hevo executes the query against the data warehouse, and the results are exported to another table in your Destination. You can write a complex SQL query, including joins and aggregates, for more complex requirements. Hevo supports all the query capabilities offered by your Destination.

You can schedule the Models as per your required schedule and frequency to have timely access to analysis-ready data.

We have introduced several new features in Models in Release 1.44. To leverage these features, you can update your legacy Models to a more recent version. Read Updating Legacy Models.

See Also

Tell us what went wrong