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.
SQL Models Topics
- Familiarizing with the Models UILearn how to navigate the Models UI in Hevo.
- Types of ModelsLearn about the different types of Models supported by Hevo.
-
Key FeaturesLearn about the Query Export, Templatized Queries, and Model Reset features introduced in Release 1.44.
- Working with SQL ModelsLearn how to create, schedule, and manage a SQL Model.
- Previewing a ModelLearn how to preview the output of a Model's SELECT query before running it.
Viewing the Query HistoryLearn how to view the history of queries executed for a Model.-
Legacy ModelsLearn about Models created prior to Release 1.44 and how to update them to use the newer features.
-
Troubleshooting ModelsTroubleshoot common issues encountered in a Model run.