Hello Let s say I wanted to run multiple dbt commands throug

Question

Hello Let s say I wanted to run multiple dbt commands through the <https docs prefect io api latest tasks dbt html|dbt task> but will not know the commands until runtime they will be received as a paramter What is the recommended way of looping tasks Would something like this be ok ```dbt task = DbtShellTask with Flow dbt flow as flow dbt command string = Parameter dbt command string default = dbt run required = True dbt commands = dbt command string split for command in dbt commands dbt task command=dbt command ```

Zanie · Answer

Hi That won t work because dbt commands string is just a `Parameter` type then not a string You d want to map over the parameter instead

Zanie · Answer

JC Garcia · Answer

oh that s great do mapped tasks run sequentially or in parallel

Zanie · Answer

They run in parallel

matta · Answer

Is there a way to make them run sequentially < Zanie>

Zanie · Answer

You could use a loop e g <https docs prefect io core advanced tutorials task looping html>

Zanie · Answer

Additionally if you just want to leverage the `DbtShellTask` functionality but want to track the running of the commands with a single Prefect task you can pass the parameter to a task that does split and loop as you have written but call `dbt task run ` within your task The benefit of the more complex `LOOP` pattern is that each of the subtasks would be tracked by Prefect but if that s not important to you calling ` run` directly may be useful

matta · Answer

< JC Garcia>

JC Garcia · Answer

thanks < Zanie>