Questions tagged [amazon-dynamodb]

Amazon DynamoDB is a key-value and document database that delivers single-digit millisecond performance at any scale. It's a fully managed, multiregion, multimaster database with built-in security, backup and restore, and in-memory caching for internet-scale applications. DynamoDB is hosted on AWS, but also has a local deployment option just for development and functional testing.

0
votes
0answers
11 views

Getting limited and sorted pages of items from DynamoDB?

I'm using DynamoDB for one of my react-native projects. Server-side is NodeJS. The table I have has a primary key 'hashtag', and a sort key 'timestamp'. hashtag | timestamp blabla | 1 blabla | 2 ...
0
votes
1answer
13 views

BatchGet - AWS DynamoDB with any sort key

I'm using AWS (JS) Document Client library for DynamoDb and trying to do a batchGet from a table (partition+sort key). Issue is that I would like to get all items by partition key and any sort key. ...
0
votes
1answer
8 views

Is there any way not to get a null return when query over a sort key in dynamodb using nodejs and serverless framework?

I'm querying a dynamodb table with a partion key and a sort key using serverless framework and nodejs. I'm not sure to be using a correct syntax because if y add a condition over the sort key I'm ...
0
votes
0answers
21 views

CognitoIdentityCredentials is not authorized to perform: dynamodb:Query on resource

I am facing issue in sending data to my dynamoDb private table(only user can read and write data). I logout from my previous logged in account using the code CognitoCachingCredentialsProvider ...
0
votes
1answer
19 views

Query a index in dynamo db using golang

I need an example in golang on how to do a query on an index in dynamo db. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SQLtoNoSQL.Indexes.QueryAndScan.html the one above is for ...
0
votes
0answers
20 views

Issue when using AWSCognito/DynamoDB

I am using AWSCognito and DynamoDB in an iOS app. When running this Swift code: dynamoDbObjectMapper.save(newMyObject!, completionHandler: { (error: Error?) -> Void in if let error = ...
0
votes
0answers
15 views

How to get items in DynamoDB Table filter based on TimeStamp and an offset of this TimeStamp value?

I am looking to query a DynamoDB table, filtered based on time value, however I cannot find any documentation on how to modify this value in the FilterExpression. The idea is to add and subtract an ...
0
votes
2answers
16 views

DynamoDB How to query a non-key attribute with strong consistency?

I have the following table in DynamoDB: Table: Person Attributes: person_id, firstName, lastName, age, birthday Partition Key: person_id My problem is: I need to query all the people that are ...
0
votes
0answers
23 views

How to create DynamoDB (Local) tables in Docker Container

I currently have Dynamodb-local running in a Docker container using the amazon/dynamodb-local image. The container starts up and I can manually create the necessary tables via AWS CLI. At this point,...
1
vote
0answers
11 views

Duplicate KeyPair with a DynamoDb batchLoad causes error

When I am performing a batchLoad I'm getting an error which states: "provided list of item keys contains duplicates" which I could understand as the List I am passing to batchLoad might have ...
0
votes
1answer
27 views

DynamoDB - Event Store on AWS

I'm designing an Event Store on AWS and I chose DynamoDB because it seemed the best option. My design seems to be quite good, but I'm facing some issues that I can't solve. **The design Events are ...
0
votes
1answer
36 views

Loading 20 million records to Dynamodb is very slow using boto3

I'm trying to load more than 20 million records to my Dynamodb table using below code from EMR 5 node cluster. But it is taking more hours and hours time to load completely. I have much more huge data ...
0
votes
0answers
18 views

Dynamo DB run multiple queries for list of HasKey but without range key

I have a table which has a HashKey defined and there can be multiple records corresponding to this. So, I have a range key which helps in uniquely determining the record. I want to query all records ...
0
votes
1answer
8 views

Can't connect existing AppSync resolvers/API to existing Dynamodb table

I have existing an AppSync API, and I want connect it to an existing Dynamodb table. However, I cannot connect with Dynamodb without creating a new AppSync API. I created new AppSync API and AWS ...
-1
votes
1answer
22 views

Amazon DynamoDB scan vs RDS where clause performance without using indexes

I searched around but didn't find any answers so posting the question here. I am setting up a new DB, and trying to compare the performance of Dynamo DB SCAN operation and the SQL WHERE clause (both ...
0
votes
1answer
15 views

Referring to a different table without a code change

I am doing some testing using AWS Lambda and DynamoDB and I would like to keep DynamoDB table table1 as it is with all its data intact. However, I would like to move on to another test with the same ...
1
vote
2answers
25 views

DynamoDb scan Returning all data on Local but not On Live

I used the recursive calls to get data more then 1 mb data from the dynamodb using this params.ConsistentRead = true; let projectCollection = []; dynamoDb.scan(params, onQuery); function ...
0
votes
1answer
26 views

Is DynamoDB sorting impossible?

I connected DynamoDB with Spring-boot. Normal findAll() is work. Pageable is work too. But when I insert sort value, it's not a work. And I tried to use findAllByOrderByBn() method. This is my ...
0
votes
0answers
9 views

How do I handle connections in a AppSync / GraphQL model

I have a GraphQL model like the one that follows. What I basically want is to have the Photo associated with either the Producer OR the Product. So I thought that by not entering any exclamation mark (...
0
votes
1answer
9 views

No method or field annotated by @DynamoDBHashKey within type java.lang.String

I don't know why doesn't run this project. @Data @DynamoDBTable(tableName ="tableName") public class entityName implements Serializable { private static final long serialVersionUID = 1L; @...
0
votes
0answers
7 views

Handling different kinds of exceptions in while using AWS Java SDK

I am updating a DynamoDB table from a AWS Lambda. I am using the default AWS SDK retry policy with the default SDK backoff strategy with a baseDelay of 25 ms, throttled delay of 125 ms, maxDelay of 20 ...
2
votes
2answers
45 views

Modeling Relational Data in DynamoDB (nested relationship)

Entity Model: I've read AWS Guide about create a Modeling Relational Data in DynamoDB. It's so confusing in my access pattern. Access Pattern +-------------------------------------------+-----------...
0
votes
0answers
27 views

Counting complex querys as single request

Hello I have PHP+Mysql api and now I'm reworking to asp.net core + dynamoDB api, in php I have 5 mysql querys which all of them use count on diffrent params, now I want same query to go in dynamoDB ...
0
votes
0answers
32 views

How to migrate the whole database from Postgres to DynamoDB

I have a database in PostgreSQL. Now we need to import whole database into DynamoDB. Data Migration service need to be used for this purpose or any other service can be used. Please explain in detail. ...
-1
votes
1answer
21 views

How to sort data from dynamo DB using nodeJS in AWS-lambda

I am retrieving data from the table using onScan in lambda function. I want to sort them based on the timestamp. Please advise on this var params = { TableName: "LogEvents", FilterExpression: ...
0
votes
0answers
19 views

data is not getting passed to dynamodb from s3

Data is not getting passed to dynamodb from S3. Looks like i am missing something. Please help me if anyone has worked on this requirement. I have already written a code which is not throwing any ...
0
votes
1answer
31 views

Should DynamoDB be the default recommendation for AWS?

Now that DynamoDB supports transactions for up to ten items, and also offers API for consistent reads, shouldn't it be the default selection for database on AWS? Not only is it providing all features ...
0
votes
0answers
17 views

Multiple Dates in Sort Key

I'm new to this so bare with me please. I want to build a table that keeps track of car rentals. So let's say that we have the following situation: Car A is booked at 2018-09-20 and is to be used ...
1
vote
0answers
16 views

ConditionExpression failing when attempting to compare range key with supplied date range

I have a table inside dynamodb with a hash key of deviceKey and a range key of timestamp. deviceKeys have the form of 'randomstring-num' so for example I might have 'abc-1', where the string is an IoT ...
1
vote
0answers
21 views

How to query DynamoDB table by list of Ids primary keys

I need to fetch a few (hundreds) records from DynamoDB table by its IDs (Java SDK). Can I do something like the following: // Set<String> Ids = <set of string IDs> QuerySpec spec = new ...
1
vote
2answers
36 views

DynamoDB fake server for integration testing

I am new to DynamoDB and I was wondering if there is any kind of embedded DynamoDB fake server available as a maven dependency/plugin, in order to run end-to-end tests as part of the maven build. E.g. ...
0
votes
0answers
14 views

AWS Amplify + Appsync - Is it possible to use @connection transform to cascade delete related data?

I am developing a web application using AWS Amplify and AppSync to read and write my data to DynamoDB tables. Using the Amplify's GraphQL Transforms, it is easy enough to establish a connection ...
-1
votes
0answers
3 views

Data validation against dynamodb table

I have a dynamodb table with 100 iot device ids, when data coming from the device (ex: moisture sensor) , I want to validate that data against dynamodb device ids if that id present in dynamodb table ...
0
votes
0answers
25 views

Keep getting the “ConfigError: Missing region in config” error in Node.js no matter what I do

I keep getting the "UnhandledPromiseRejectionWarning: ConfigError: Missing region in config" when trying to make requests to APIs I have set up in Node.js. I'm new to DynamoDB and after setting up ...
0
votes
0answers
15 views

Lambda returns Null From DynamoDB

I am new to AWS .. created Basic DynamoDB table with "EmailId" as key and added a record to the table "PlayerDetials". Below is my Lambda function. When i test it , it always return Null instead of ...
0
votes
0answers
13 views

AWS DyanamoDB is not letting batchWriteItem in tables and completes successfully without error

I am following the format which dynamodb requires for batchWriteItem I am generating an putRequest array and passes this to a table In CloudWatch, I can see request completes succesfully but items ...
1
vote
1answer
28 views

DynamoDB Throughput vs Search time

I've just figured out a big mistake I had while creating the dynamodb structure. I've created 11 tables, whereas one of them is the table mostly refereed to and the others are complementary tables. ...
0
votes
1answer
30 views

how to start AWS SAM using a dockerfile

I am trying to build two docker containers inspired by Containerizing Serverless APIs. I want to run my my API and DynamoDB locally in two different containers as specified by my Dockerfile (for API) ...
0
votes
1answer
19 views

Groovy script issue with escaping quotes

I'm running this shell command using groovy (which worked in bash): aws --profile profileName --region us-east-1 dynamodb update-item --table-name tableName --key '{"group_name": {"S": "group_1"}}' --...
1
vote
0answers
27 views

Save the data with a hierarchical key or replicate the data in a DynamoDB table

I have a table in dynamodb with hierarchical information, example agency A -> agency B -> agency C, etc. In another table I need to keep data related to this hierarchy of agencies, this data has ...
0
votes
1answer
14 views

DynamoDB, can't save encrypted data, “not authorized to perform: kms:GenerateDataKey on resource”

I'm trying to save encrypted data to DynamoDB with the help of the "Amazon DynamoDB Encryption Client for Java". I also use the Serverless framework to deploy my application (some Lamdba functions ...
0
votes
0answers
16 views

How to fix dynamodb local call using docker-compose

I'm starting a springboot app and dynamodb local in docker containers via docker-compose. Both containers come up successfully. When I use the container name for the AMAZON_AWS_DYNAMODB_ENDPOINT ...
0
votes
0answers
37 views

Error while trying to upload CSV file from S3 to DynamoDB using AWS Lambda

I am trying to upload CSV files from S3 to Amazon DynamoDB using AWS Lambda. I am using Python 2.7. The file has just 2 columns: Name and ID. The code is as follows: import boto3 s3 = boto3.client('...
0
votes
1answer
21 views

An error occurred (ResourceInUseException) when calling the CreateTable operation: Table already exists:

Getting below error while creating a table in dynamodb to put data from s3 bucket and load into the table having more than 4-columns. error in cloudwatchlogs:"module initialization error: An error ...
0
votes
1answer
13 views

dynamodb query to select all items that match a set of values

In a dynamo table I would like to query by selecting all items where an attributes value matches one of a set of values. For example my table has a current_status attribute so I would like all items ...
0
votes
0answers
7 views

Strategies to deal with ConditionalCheckFailedException

A piece of code I inherited is run in a AWS Lambda function to update a DynamoDB table and in the process getting a ton of ConditionalCheckFailedExceptions. What the code does is that it has a list of ...
0
votes
1answer
22 views

DynamoDB ReturnValues UPDATED_OLD in AppSync

Im trying to update an item attribute in a DynamoDb table with AppSync. Once successful i want to use the previous value of that attribute as the key in my next call (I'm using pipeline resolvers). ...
0
votes
0answers
29 views

How to find if the particular emailID exists or not dynamically in the DynamoDB?

I am using node js in the lambda function. I need to save some of the details in the dynamo db..While passing the values i need to check whether the emailid exists in the dynamo db or not..If the ...
0
votes
0answers
20 views

How to identify and remove describe table calls to my dynamodb?

I am using dynamodb with dynamoose and have a problem with the describe table calls that are being fired to the DB with every query. How can I remove these calls at a config level so as to avoid the ...
0
votes
0answers
18 views

Techniques to distribute workload uniformly in DynamoDB

I am writing to a DynamoDB table with 15k WCU and auto scaling enabled. However, I get upto 40k throttled write requests and my use capacity only reaches 5k WCU. The problem is that my data is heavily ...

http://mssss.yulina-kosm.ru