I followed the tutorial from Beyond Sky, while also playing with some of the settings to gain a better understanding
Vid link - https://www.youtube.com/watch?v=2euaC6DeaBg&list=PLdDq1FRPTfOlDyNBn7Mb_rx0Zhyb-NIaO&index=1
Used the assets from the Voxyde Fire Spear project.
I followed the tutorial from Voxyde, that covered making a sand storm in Houdini and then composited in Nuke. Though this shot doesn't include the simulations that I was unable to export, I used the given renders by the course.
https://voxyde.teachable.com/courses/enrolled/2592457