Refactor sharding key rules

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

Why

Related to Investigate: Handle setting sharding key (#536752 - closed) and Add sharding key logic (!188873 - closed)

The initial implementation of set sharding key behavior runs on every validation check. Eventually we can use the suggestion in the MR to consolidate this but only after we add the sharding key logic for each layer (MR,Project, Group etc)

What

Implement similar suggestion to !188873 (comment 2470099175)