Question: What are the naming conventions in DynamoDB?

Answered by Rafal Wilinski
Answer
In DynamoDB, the naming conventions for tables, primary keys, and secondary indexes are as follows:
Table names: Must be unique within your AWS account and can contain only alphanumeric characters and underscores. The maximum length is 255 characters.
Primary key: The primary key is used to identify each item in a table uniquely and can be either a simple primary key (also known as a partition key) or a composite primary key (consisting of a partition key and a sort key).
-
Partition key: This must be unique within each partition and can contain any string or number.
-
Sort key: Can be used to sort items within a partition and contain any string or number.
Secondary indexes: Allow you to create additional indexes on a table that can be either global or local.
-
Global secondary index: This can have a different partition key and sort key than the primary key and can be created on any table.
-
Local secondary index: Must have the same partition key as the primary key but can have a different sort key.
Other Common DynamoDB FAQ (with Answers)
- How to count rows in DynamoDB?
- Does DynamoDB support atomic updates?
- Can a DynamoDB range key be a GSI key?
- Can we rename DynamoDB table?
- Can Power BI connect to DynamoDB?
- What is the access pattern in DynamoDB?
- How to access DynamoDB from EC2?
- Does DynamoDB support load balancing?
- Is DynamoDB OLTP or OLAP?
- Is DynamoDB ACID compliant?
- Can we store list in DynamoDB?
- Will I be charged for DynamoDB is it is inactive?
- Is it possible to make a DynamoDB table case insensitive?
- How to store graphs in DynamoDB?
- Is DynamoDB table region specific?