Adding new Local Secondary Index to an existing DynamoDB table

Question

Is it possible to add a new Local Secondary Index to an existing DynamoDB table?

Come on AWS give us this feature! Pretty please.

Derrops
– Derrops

2020-08-09 07:57:43 +00:00
Commented Aug 9, 2020 at 7:57 — Derrops
– Derrops, Commented Aug 9, 2020 at 7:57

Eyal Ch · Accepted Answer · 2016-04-08 10:10:20Z

38

no, you cant do it, only adding global secondary index is possible to an existing table.

Local secondary indexes on a table are created when the table is created.

answered Apr 8, 2016 at 10:10

Eyal Ch

10.1k5 gold badges49 silver badges54 bronze badges

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

6 Comments

user4035628 Over a year ago

What if the design of the database changes or evolves with the same table? How do we handle that?

Eyal Ch Over a year ago

@kashyapjimuliya like how? do you have an example? you can always add/delete global secondary indexes

user4035628 Over a year ago

Like example, I have created two tables and for each there is LSI but when I want to add some new column to one of the tables and I want to make it as LSI for third table to have a One-to-One or One-to-Many relation. What I need to know is how is that scenario going to play out?

Eyal Ch Over a year ago

@kashyapjimuliya you can always add later secondary global index

Yusuf Over a year ago

but I want to use the same partition key for GSI as of table partition key. for this reason i needed LSI, since LSI is not possible, can i create GSI as such with same partition key

|

Collectives™ on Stack Overflow

Adding new Local Secondary Index to an existing DynamoDB table

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related