I´m facing the following problem: I need to build a table with many attributes: status, user_id, attribute_1, attribute_2 ... attribute_n I need to perform a high number of queries filtering by status only, but this attribute has a low cardinality…
I am looking for help on design the dynamodb table. Here is my usecase, Currently, i have a set of actions that user can complete at any point of time. These actions keep on changes based on the user actions…
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…