Workflows

Last updated on Jul 18, 2023

In Hevo, you can use Workflows to create a Directed Acyclic Graph (DAG). 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 to be 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 conditions in Workflows:

Example

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

The condition Quantity filter states that 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