SQL Models

Last updated on Jan 08, 2024
On This Page

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.

Note: You cannot modify your Source data through Models.

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.

Using Models, you can transform and load data in near real-time. You can schedule the Models as per your required schedule and frequency to have timely access to analysis-ready data. Read Scheduling Models.

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

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Jan-09-2024 NA Merged FAQ, Can I use Models to transform and load data in real-time? into this document.
Dec-29-2023 NA Merged FAQ, Can I use Models to make changes to the data in my Source? to this document.

Tell us what went wrong