Data
Shard Key
The column determining which shard a row lives on.
Why interviewers ask about it
Must be on most queries, high cardinality, evenly distributed, and colocate rows that need atomic updates. A query without it must scatter-gather across every shard.
Related terms
This term is part of the free System Design interview preparation module - browse the full glossary for every definition.