I have following data in dynamo , all string fields. id | data | my_date 1 | some text | 2024-03-21 2. | more text | 2024-09-30 .... i wrote a query as such, to scan items and then filter…
Some context is needed for my question at the bottom of the post. There are two tables in the DynamoDB with the following schema. type Post @model { id: ID! author: String! comments: [Comment] @hasMany } type Comment @model {…
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…