Transform

Last updated on Sep 28, 2023
On This Page

Starting Release 2.17, the Workflows feature is available only for existing users. Users signing up from Release 2.17 onwards cannot create Workflows. For more information, please contact Hevo Support or your account executive.

While Pipelines in Hevo address the Extract and Load steps in our Extract-Load-Transform (ELT) approach of moving your data from the Source to the Destination warehouse, the Transform step is achieved using dbt™ Models, SQL Models and Workflows.

The most important benefit of the ELT approach is that you can transform your Source data in any manner, and any number of times. You can also transform only the data you need for a particular business analysis. To enable this, Hevo offers the intuitive and easy-to-use Models interface, where you can apply transformations on the data till you reach the final data model that is required for your business reporting and intelligence needs. Using the Query Builder in Models, you can design and test standard SQL queries that can aggregate data from one or more systems and transform it for analysis and reporting and work closely with the Destination schema. You can also create SQL Join clauses that can combine data from multiple tables, and write the query results into a new table.

Furthermore, Hevo integrates with dbt Core™, the open-source CLI offering from dbt that allows you to transform the data in your data warehouse Destinations. You can configure dbt™ Models in Hevo and connect to the Git repository hosting your dbt projects to run the models within the project. These models, containing SELECT statements, are run against the Destination tables specified in your SQL query. The results are then loaded into the target tables and views in your data warehouse Destination.

Workflows further extend the functionality offered by dbt and SQL Models. They provide you with a powerful way to derive insights of your business. Workflows allow you to join multiple Models, whereby the output from one Model can form the input to one or more Models. This enables you to perform deeper analysis and gather important data inputs for your reporting and BI needs.

You can schedule the Models and Workflows to run at specific times and frequency, giving you further independence and control in analyzing your data.



Revision History

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

Date Release Description of Change
Jul-12-2023 NA Added information about dbt™ Models.

Tell us what went wrong