Secondary Index -DynamoDB

Question

I am new to dynamoDb and exploring its docs these days. I read about secondary index in dynamodb and have a small confusion. When we create a secondary index we specify partition and sort key (optional) for that index but do we also add attributes to secondary index which which we'll be querying using the secondary index?

Let's say, I have a table named Person and it contain attributes such as Name, Age, Gender, Contact, Star. It has name as the partition key and now I want to create a secondary index on Age such that I can query using Age and get the attributes - contact, star, name. Should I add these attributes (contact, star, name) to secondary index as well while creating it or I can just need to specify partition key (age in this case)?

Leeroy Hannigan · Accepted Answer · 2024-01-30 15:52:20Z

0

You are only required to define the partition key Age in this case. By default, the projection will include ALL which means it will replicate the entire base table item (contact, star, name) into the index.

You can optionally choose to project only a subset of the attributes, (contact, star), for example.

The base table keys will always be projected, no matter if you exclude them from the Incudes projection type, no Name will always exist in the index at minimum.

https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_Projection.html

answered Jan 30, 2024 at 15:52

Leeroy Hannigan

20.5k4 gold badges23 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Secondary Index -DynamoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related