Trying to use DbtShellTask on windows but get the following

Question

Trying to use DbtShellTask on windows but get the following error ``` 2022 06 27 17 16 15+0200 ERROR prefect DbtShellTask | bin bash C UsersUSERAD~1AppDataLocalTempprefect 6rbqzzlx No such file or directory``` This line in prefect tasks shell py generates a strange path ```with tempfile NamedTemporaryFile prefix= prefect as tmp ```

Andreas Nord · Answer

Running something simple with ShellTask ```from prefect import Flow from prefect tasks shell import ShellTask task = ShellTask log stderr=True with Flow My Flow as f both tasks will be executed in home directory contents = task command= ls out = f run ``` gives the same error ``` 2022 06 28 09 55 31+0200 INFO prefect FlowRunner | Beginning Flow run for My Flow 2022 06 28 09 55 31+0200 INFO prefect TaskRunner | Task ShellTask Starting task run 2022 06 28 09 55 31+0200 ERROR prefect ShellTask | Command failed with exit code 127 2022 06 28 09 55 31+0200 ERROR prefect ShellTask | bin bash C UsersUSERAD~1AppDataLocalTempprefect exffnpu No such file or directory```

Kevin Kho · Answer

This looks like bash is not in the Windows path

Andreas Nord · Answer

My interpretation is that this file does not exist C UsersUSERAD~1AppDataLocalTempprefect exffnpu

Kevin Kho · Answer

Oh not even the path out of your TemporaryFile looks weird

Kevin Kho · Answer

I guess you could use the `os subprocess` call inside a task

Andreas Nord · Answer

Yes not sure what is the issue with tempfile behaviour will have to solve it with os subprocess