database sharding, how to pick the right shard key

hey everyone, im wrestling with database sharding for a new project and could use some collective wisdom. we're expecting significant data growth. choosing the right shard key seems critical to avoid hotspots and ensure good query performance down the line. what factors do you consider when selecting a shard key? any gotchas or common mistakes to watch out for?