SQL Models

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.

• Articles in this section
  • Familiarizing with the Models UI
  • Types of Models
  • Key Features
    • Query Export Options
    • Templatized Queries
    • Model Reset
  • Working with SQL Models
  • Previewing a Model
  • Viewing the Query History
  • Legacy Models
    • Legacy Models in Hevo
    • Updating Legacy Models
  • Troubleshooting Models
    • Model run timeout
    • Access denied

Revision History