Parameterization of SQL queries

Overview

You can use {tokens} anywhere in the source and destination queries, also anywhere where the user can enter SQL query. 

How it works

The system will replace the {token} on the value of the Flow variable. 

Setting values of the flow variables

Use one of the following methods to set values of the flow variables:

• Flow variables are passed as URL parameters or URL variables to the user-created API endpoints.
• Flow variables are passed as URL parameters to the run Flow by name API.
• Flow variables are passed as a payload to the run Flow by ID API.
• Flow variables can also be defined when creating nested Flows.
• Flow variables can be set and accessed programmatically.
• Flow variables set as database loop parameters.
• Flow variables set as file loop parameters.
• Flow variable set when executing flow manually.
• Flow variable set when configuring the schedule.
• Flow variable set when configuring the flow to be executed by Integration Agent.

In addition to Flow variables, the destination query can contain {source field names}.