Overview
Etlworks can run a workflow step once for each record returned by a database query. The technique is known as a database loop.
A SQL SELECT statement drives the loop. Every row in the result set is one iteration, and the flow runs once for each record.
For every column in the query result, Etlworks creates a variable that can be referenced in the flow using {variable} syntax. This lets flows process records dynamically, build requests, or branch on values pulled from the database.
For the full configuration reference, see Database Loop in Looping in Workflows.