All Collections
Buffer Query Source Step
Buffer Query Source Step

The Buffer Query Source step is used to query a buffer using SQL (NoQL).

Praise Magidi avatar
Written by Praise Magidi
Updated over a week ago

Illustrated below is an example where a Buffer Query Source step is used.

The Record Generator step is used as the main source step and populated is an AccountID as illustrated below.

Adding a Buffer Query Source Step

To add a Query Source source step, follow these instructions:

1. Click on the highlighted icon as shown in the below image.

2. The below page will appear. Select or search for a Buffer Query.

Configuring the Buffer Query Source Step

Illustrated in the below image is the configuration that is available in the Buffer Source step.


Select the required buffer by clicking on the drop-down list which is outlined in red in the above image. This returns the buffer ID (highlighted in the image above). Type out the SQL query in the Query section. A record in the data set can be referenced by using 'inputRecord.fieldName' in the SQL query. Click on the Validate button to validate the SQL query.

The available SQL syntax to query a buffer are in the link below:

Limit field

Set the maximum number of records required to be returned.


Number of records to skip.

Force Aggregate checkbox

Force an aggregate query regardless of the query type.

Debug checkbox

Log queries for debug purposes.

Using the Buffer Query Source step

In this example, an inner join is used to get the account name from the SFAccount buffer and the case details from the SFCase buffer based on what the AccountID is in the Record Generator step.

The below image is an output of the various cases that are linked to the AccountID with the account name showing above the cases.

Did this answer your question?