Retouched my old scene, now with around 100,000,000 simulated sand grains and made a tutorial for it. This is combination of Blender and Houdini. Rendered with Cycles. There’s also a tutorial which goes through the whole process and how you can import/export simulations between Houdini and Blender.
you don’t need to copy mapping coordinates every time from shader to shader, just put all of them (mapping) into a group node and reuse it in every shader, so press TAB and you will get global access to adjust every shader at once