Workflows

Last updated on Oct 03, 2023

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.

In Hevo, you can use Workflows to create a Directed Acyclic Graph (DAG). The DAG conceptually represents the Models and their order of execution. The Models may be connected by lines if data from one Model forms an input to another Model. Workflows allow you to:

  • Define dependencies between SQL and dbt™ Models.

  • Combine the data transformed by these Models with or without data load conditions.

  • Load the transformed data to the Destination tables as per your Workflow setup.

Read Working with SQL Models and Configuring a dbt™ Project for the steps to create SQL Models and configure dbt projects, respectively.

Data load conditions

A data load condition is evaluated as either TRUE or _FALSE_ by comparing the number of rows loaded in a Destination table since the last run of the Workflow with the number defined in the condition.

Based on the outcome of the condition, you can define how different Models are combined in the Workflow, and whether the Workflow should stop.

You can define conditions only on the data loaded into the Destination tables by Hevo.

The following example illustrates the use of data load conditions:

Example

Let us consider a Model, Engineering, which is connected to Models, Employees 1 and Employees 2 through the Quantity filter condition.

Quantity filter condition: The number of rows in the Destination table _18_new_campaign is Greater than Equal To 10.

Configure Condition

Therefore, if the number of rows in the data coming through the Engineering Model are greater than 10, it serves as input to the Employees 1 Model. Else, it serves as input to the Employees 2 Model.

Quantity filter condition




Revision History

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

Date Release Description of Change
Jul-18-2023 NA Updated the content to reflect supported functionality.
Jan-02-2023 NA Added information for dbt integration with Workflows.
Sep-07-2022 1.97 Updated the page to reflect the latest changes intoduced in Workflows.

Tell us what went wrong