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 DynamoDB to store logs, the table has the columns creation_year, creation_month and state_code, I need to filter by those columns so I created a GSI for each, right now I have the following query for one index…
I have a dynamoDB table with a HASH key and a SORT key. **Now I have a situation where I need to get table contents based on the HASH key only and it will return an array of items. **…
I want to insert an item on a GSI, however the AWS SDK library doesn't seem to cooperate. This is the relevant code: const updateLeaderbordAggreagte = async (documentClient, leaderboardPK, tournamentPoints, participant) => { try { const putLeaderboardScore = new PutItemCommand({…
I have a user table with following attributes: FirstName LastName City CompanyName I want to query the table with any combination of these attributes and that too partial . For example: Input - Firstname- "bh" and lastname - "ta" Output…
I have the following schema where I am basically just trying to have a table with id as primary key, and both code and secondCode to be global secondary indexes to use to query the table. resource "aws_dynamodb_table" "myDb" {…
I have a cloudformation template regarding the dynamodb. I added new index called customerId-index as below: ComponentsTable: Type: AWS::DynamoDB::Table Properties: TableName: ${self:custom.base}-components PointInTimeRecoverySpecification: PointInTimeRecoveryEnabled: True StreamSpecification: StreamViewType: NEW_IMAGE BillingMode: PAY_PER_REQUEST AttributeDefinitions: - AttributeName: assetId AttributeType: S - AttributeName: componentId AttributeType:…
I need to get the rows by key (e.g. where status is "Active") but with sorting on multiple columns. I'm using the pagination that's why I cannot sort the result after fetching it from the DynamoDB. (Just for the information,…
There is an existing table in DynamoDB with few billion records and I want to add a Global Secondary Index (GSI) to it. Does this consume any Read Request Units (RRU) from the table capacity OR a Write Request Units…