New to DynamoDB. Suppose I am building an E-commerce site with single table design, where there are many entities like orders, deliveries, etc. I start with Partition Key and Sort Key with generic names: "PK" and "SK", since it makes…
I want to use the AWS SKD v2 of DynamoDB which can accepts the table name dynamically and return all the records and I am creating the Rest API for the same. I have to use the access key and…
Been having a hard time trying to find a definitive answer on this. I need to mass insert a lot of data into a dyanmoDb table with a sort key (a DateTime). As far as I can tell, the order…
I'm having an issue using BatchGetCommand to get a list of records from a DynamoDB table. I am using an AWS Lambda that uses NodeJS 18.x. I have been able to get ScanCommand, GetCommand and QueryCommand to work. BatchGetCommand is…
I've inherited a service where the TTL value for the DynamoDB records is in the following format 2022-11-03T10:35:42.920Z Does anyone know how I can run a query to delete all the records with a TTL value that is in the…
I have a new Amplify Gen 2 project ( NextJS 14 app) that uses DynamoDB and also needs to access existing AppSync GraphGL API. Existing API is added to the app first by running amplify add codegen --apiId XXXXXXXXXXXXXXX and…
I'm designing a DynamoDB table for storing property-related data where each property belongs to a category and subcategory. I have three combination of primary key in sql server. I need assistance in designing the table schema to efficiently query properties…
I have a csv sitting in an S3 Bucket about 900,000 rows long, and within that csv I have two columns phone and ttl. I am able to successfully import this csv into a new DynamoDB table, however I am…
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…