Workflow capability within Azure Data warehouse to run parallel queries.
To maximise the parallel execution and MPP architecture, it will be great to have a workflow capability that will allow users to run queries in parallel against a defined Resource Class.
I appreciate this could be against the SQL engine design but looking at the architecture we might be able to do something like this
workflow-Parallel (ResourceClassUser = XlargeRCuser, OptionalAllocMaxMemory = 0.5)
where 4 sprocs will run in parallel with defined RC and max memory allocation in percentage/ratio to the total max available for the RC, half in this case.
Thanks for the suggestion. We announced workload isolation with workload groups for preview at Ignite Nov., 2019. Workload groups give you a lot more flexibility to define resource usage and thus concurrency. Please have a look at workload groups and share more feedback.
Greg Galloway commented
I think the admin missed the point of this request which was mainly about SQL syntax for parallel execution of multiple statements from inside a stored proc. I agree this would be great!