The Data Query step lets you execute a SQL query to fetch, filter, or transform your input data. Use this step to:
  • Enrich data: Join your input data with additional tables to add extra context.
  • Refetch information: Retrieve the most up-to-date data after a Wait step.
  • Filter rows: Apply custom conditions to include or exclude specific records.
  • Fan-out: Expand a single trigger event into multiple notifications by transforming the input row into multiple rows.
To add a Data Query step, click the ”+” placeholder node in the builder or the ”+” button on any connection between two steps, then select Data Query.
Data Query interface

Configuration of a Data Query step that enriches user data by joining with the organization table.

​
Breakdown

Select a database connection

Choose the database connection through which the query will be executed. This connection must be configured in your settings.

Write your SQL query

Enter a SQL statement that processes the data from the parent step. You can access the input data via a temporary table called input_rows in addition to the tables from the database connection you selected.The query editor supports SQL syntax highlighting, auto-completion, and a built-in formatter.

Add a description (optional)

Provide a brief description to easily identify this step within your workflow.

Test the query output

Use the Test Panel to preview outputs and validate your query. This ensures that the data passed on to subsequent steps meets your requirements.

​
Explore further

How it works

Discover how our real-time engine executes your queries and manages data transformations.

Publishing workflows

Learn how publishing your workflow activates the Data Query step and finalizes its configuration.