This is my API request body (Array of numbers): { "userIds": [10,11,12, 20] } Where the usersIds in DB is a number type and it's not the primary or secondary keys. I need to query DynamoDB and get the details…
I have a simple lambda function that is trying to insert an intem into a dynamodb table. The said table has its PK of type string, I'm trying to insert a string in it, but I get an error that…
I have an Application deployed in ECS, which query Dynamodb on the status column using GSI and perform some computations and update the status. My problem is quering the GSI in pagination takes a long time, I want to scale…
I have the following data structure in Dynamo and am able to execute queries according to my required access patterns, but I am attempting to use the higher level API to let the AWS framework take care of conversion/deserialization from…
I am creating a Node.js application where some Lambda functions mutate data atomically called via API. Creation function run perfectly, but update function, with the same structure, gives "Unable to update Member data" (where Member is the table to update),…
We have a dynamodb database and would like to export the data to a new redshift database staging table on a nightly basis. Ideally I think it be better if we only export inserts or updates since last load otherwise…
I have the following data Partition key Sort key value aa str1 1 aa str2 123 aa str3 122 ab str1 12 ab str3 111 ac str1 112 And by using QueryRequest I want to select entries where the partition…
I am trying to understand how partition works in dynamodb table. Based on AWS doc: A DynamoDB partition can support 3000 read operations and 1000 write operations. It keeps a divider between read and write ops so they do not…
I have a DynamoDB table, that has partition key: id and sort key as number timestamp (it will always be there). The id will always be unique. Does it even make sense to have timestamp as sort key in such…
In this code snippet I try to get an item from a table which has partitionKey as a messageId case "GET /items/{messageId}": const { messageId } = event.pathParameters; body = await dynamo.send( new GetCommand({ TableName: tableName, Key: { 'messageId': messageId,…