Run Queries in Parallel

asaeed78 — Wed, 27 Aug 2025 14:49:53 GMT

I have a batch macro that creates sql statements from rows of an excel sheet and then runs the sql against my db.

each row of my excel defines a single sql statement. At the moment the queries are run in sequence. I want all the queries to be run in parallel.

Is there a way to achieve this in a single Workflow?

Re: Run Queries in Parallel

KGT — Fri, 29 Aug 2025 01:25:48 GMT

The Batch Macro will run in sequence. That is how it's designed. So, changing the structure of your workflow is going to be the solution.

You could have the batch macro create all the statements, and so the output of the Batch Macro is each of the statements, and then pass them all at once to the DB. If you want the outputs to be separate though, then you will need to have separate streams.

The other Out-of-the-box thought I had was having the statements write to a temp table, so that way your batch macro is just passing the statements, not waiting for results, and then call the temp table afterwards.

topic Re: Run Queries in Parallel in Alteryx Connect Discussions

Run Queries in Parallel

Re: Run Queries in Parallel