In Amazon DynamoDB, there are two main types of primary keys :
Partition Key :
* A partition key, also known as a hash key, is a single attribute chosen as the primary key for a DynamoDB table.
* DynamoDB uses the partition key's value to partition the data across multiple partitions for storage and retrieval.
* Each item in the table must have a unique partition key value.
* Partition keys are crucial for achieving scalability and distributing workload evenly across partitions.
Composite Primary Key (Partition Key and Sort Key) :
* A composite primary key consists of two attributes: a partition key and a sort key (also known as a range key).
* The combination of partition key and sort key uniquely identifies each item within the table.
* DynamoDB uses the partition key's value to determine the partition in which an item is stored, and the sort key's value to order items within the same partition.
* Composite primary keys enable range queries, sorting, and efficient querying of data based on various criteria.
Choosing the appropriate type of primary key depends on the access patterns and querying requirements of your application:
* Use a partition key alone when items in the table can be uniquely identified by a single attribute, and there is no need for range queries or sorting.
* Use a composite primary key when items in the table can be uniquely identified by a combination of attributes, and you need to support range queries or sorting operations.
