Question

What is the Azure Cosmos DB synthetic partition key?

Answer 1

It is crucial to select a good partition key that can distribute the data evenly across multiple partitions. We can create a Synthetic partition key when there is no right column with properly distributed values. The three ways to create a synthetic partition key are:

1. Concatenate Properties: Combine multiple property values to form a synthetic partition key.
2. Random Suffix: A random number is added to the end of the partition key value.
3. Pre-calculated Suffix: A pre-calculate numbed is added to the end of the partition value to improve the read performance