Go to the desert biome at night
Search for Nightstar Sand nodes on the ground
Mine the nodes with a pickaxe
Use a Pal with mining skills to gather it faster
Check cliffs, dunes, and rocky desert areas
Revisit the area after respawns if nodes are exhausted
Use a map marker to track good farming spots