Questions tagged [dynamodb-gsi]
11 questions
3
votes
1 answer
GSI capacity mode will be on-demand when primary Table has on-demand capacity mode?
GSI capacity mode will be on-demand when primary Table has on-demand capacity mode?
I am not able to find this information on the AWS documentation. Though what I am able to find is: RCU and WCU(provisioned capacity mode) should be same(or more) for…
lowLatency
- 5,534
- 12
- 44
- 70
1
vote
1 answer
Populate GSI attributes in Dynamodb if GSI is added on an existing table
I have an existing table with all the data, around 1 million records.
I needed to add GSI to the table to better query some data. However, with app logic the GSI is being populated only for new records. The partition key and sort key for GSI can be…
Ajay Narain Mathur
- 5,326
- 2
- 20
- 32
1
vote
1 answer
Dynamodb global secondary index composite sort key
I'm new to dynamodb and trying to create a global secondary index for addition access patterns.
How can I create dynamoDB GSI with composite sort key?
For example: my primary table stored orders, which has these fields User_ID,ID, Type,…
Quang
- 135
- 2
- 9
0
votes
1 answer
In DynamoDB, can GSI and LSI sort key value be updated?
In dynamoDB, can the value of the sort key be changed after the item is written to the table?
For example, I have a sort key counts, am I able to do incr updates on counts if it was being used as a sort key for GSI or LSI?
My understanding was that…
niyruu
- 5
- 3
0
votes
1 answer
DynamoDB querying Global Secondary Index with non-existant ExclusiveStartKey returns unexpected results
I have a DynamoDB table that has
partition key "idA", sort key "idB"
GSI partition key "idB", sort key "idA"
I am attempting to delete all items with specific "idB", so I query the GSI to get a list of records, but also want to paginate results…
SvenTheBarbarian
- 71
- 3
0
votes
2 answers
Dynamodb bulk query
I have an index used for bulk operations on collections that is experiencing throttling. To mitigate this am planning to shard the index so each pk is split over whatever number of partitions. At the moment there is a delete operation running on…
Person1
- 109
- 2
- 10
0
votes
2 answers
How to use Map type in Attribute projections for DynamoDB
I'm trying to design a GSI for my table which contains a lot of data. However I know that its best practice to only project data that I need instead of the entire thing. Projecting data is pretty straight forward when it comes to Top-Level entities…
dev1398
- 1
- 1
0
votes
1 answer
Make DynamoDB GSI strongly consistent
How long should I wait after putting the record to make scan/query using GSI strongly consistent? My use case has asynchronous workflows which can afford to wait for 5-10 minutes. I need to know how much wait time is sufficient to ensure that I'm…
Aditya Abhas
- 174
- 11
0
votes
0 answers
Update dynamoDB gsi composite sort key
My dynamoDB table has a GSI which its sort key is composite key. This composite key looks like this: #STATUS#CREATED_AT. The status field can be changed during update action on item, but I noticed even if I change the GSI_sk in primary table, this…
Quang
- 135
- 2
- 9
0
votes
1 answer
How can I design a DynamoDB table with a GSI when I need to know the unique keys?
I'm trying to design a DynamoDB table. I'm choose the keys I insert, what my partition and sort keys will be, as well as whether or not to including a GSI.
My data, for sake of example, looks like this:
Table name: person
{
uuid:…
mmachenry
- 1,773
- 3
- 22
- 38
0
votes
1 answer
Dynamodb GSI for boolean value
So I have this notifications table with the following columns:
PK: (which stores the userId)
sentAt: (which stores the date the notifications was sent)
data: (which stores the data of the notification)
Read: (a boolean value which tells if the user…
Meridian Asllani
- 11
- 1
- 4