Hello there, 
I was wanted once to make a render of some Sand falling, so I’ve been going over the internet, but didn’t see any tutorial of people creating it, so I came and tried to create it myself
Tried with the shaders, and a little bit of modelling too, the shader is composed of the sand texture, mixed at some transparency with the gradient texture and musgrave one…
Now I know, the transition between the sand and the falling sand isn’t great 
…
If you come across any other method, (modelling, particle, geometry node, ect… 
) please do not hesitate to tell me
