Questions tagged [amazon-dynamodb]

Amazon DynamoDB is a proprietary closed-source cloudnative key-value and document database optimized for horizontal scaling. 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. Used on amazon.com.

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. It enables customers to offload the administrative burdens of operating and scaling distributed databases to AWS so they don’t have to worry about hardware provisioning, setup and configuration, replication, software patching, or cluster scaling.

With a few clicks in the AWS Management Console or by making use of the Amazon Dynamo DB API, customers can launch a new Amazon DynamoDB database table, scale up or down their request capacity for the table without downtime or performance degradation, and gain visibility into resource utilization and performance metrics.


Related tags :

13785 questions
54
votes
9 answers

Is it possible to save datetime to DynamoDB?

I have the next code: users_table = Table(users_table_name, connection=Core.aws_dynamodb_connection) users_table.put_item(data={ "login": login, "password": hashlib.sha256(password.encode("utf-8")).hexdigest(), "profile": profile, …
53
votes
3 answers

Dynamo Local from Node-aws: all operations fail "Cannot do operations on a non-existent table"

I have a local dynamo-db running. I have set up my tables using the JavaScript console and they list OK from there. I can also put and get items to my tables from the JavaScript console: var params = { TableName:"environmentId", Item: {…
Rog
  • 17,070
  • 9
  • 50
  • 73
52
votes
8 answers

ItemSize in DynamoDB

I'm trying to compute the size of an item in dynamoDB and I'm not able to understand the definition. The definition I found : An item size is the sum of lengths of its attribute names and values (binary and UTF-8 lengths). So it helps if you keep…
Mike
  • 2,354
  • 3
  • 23
  • 37
52
votes
3 answers

How to query DynamoDB by date (range key), with no obvious hash key?

I need to keep local data on an iOS app in sync with data in a DynamoDB table. The DynamoDB table is ~2K rows, with only a hash key (id), and the following attributes: id (uuid) lastModifiedAt (timestamp) name latitude longitude I am currently…
James Skidmore
  • 49,340
  • 32
  • 108
  • 136
52
votes
5 answers

User is not authorized to perform: dynamodb:PutItem on resource

I am trying to access DynamoDB from my Node app deployed on AWS ElasticBeanStalk. I am getting an error User is not authorized to perform: dynamodb:PutItem on resource It works perfectly fine locally, but when I deploy to the AWS it stops…
52
votes
6 answers

DynamoDB - Put item if hash (or hash and range combination) doesn't exist

Here are my use cases: I have a Dynamo table with a hash + range key. When I put new items in the table, I want to do a uniqueness check. Sometimes I want to guarantee that the hash is unique (ignoring the range). Other times I want to allow…
mrog
  • 1,930
  • 3
  • 21
  • 28
52
votes
18 answers

How can I import bulk data from a CSV file into DynamoDB?

I am trying to import a CSV file data into AWS DynamoDB. Here's what my CSV file looks like: first_name last_name sri ram Rahul Dravid JetPay Underwriter Anil Kumar Gurram
Hemanth Kumar
  • 521
  • 1
  • 4
  • 4
51
votes
9 answers

node.js AWS dynamodb updateItem

Is there a way to achieve the following few points with updateItem: Add attributes if the attributes not exist in DynamoDB Update attributes if the attributes exist in DynamoDB Leave those attributes as what they are if the attributes are not…
Pano
  • 2,099
  • 6
  • 16
  • 24
50
votes
7 answers

UUIDs for DynamoDB?

Is it possible to get DynamoDB to automatically generate unique IDs when adding new items to a table? I noticed the Java API mentions @DynamoDBAutoGeneratedKey so I'm assuming there's a way to get this working with PHP as well. If so, does the…
Adam Biggs
  • 3,527
  • 4
  • 23
  • 27
50
votes
5 answers

Export a DynamoDB table as CSV through AWS CLI (without using pipeline)

I am new to AWS CLI and I am trying to export my DynamoDB table in CSV format so that I can import it directly into PostgreSQL. Is there a way to do that using AWS CLI? I came across this command: aws dynamodb scan --table-name - but…
Vibhor Nigam
  • 732
  • 1
  • 5
  • 12
49
votes
7 answers

connecting AWS SAM Local with dynamodb in docker

I've set up an api gateway/aws lambda pair using AWS sam local and confirmed I can call it successfully after running sam local start-api I've then added a local dynamodb instance in a docker container and created a table on it using the aws…
Paul D'Ambra
  • 7,629
  • 3
  • 51
  • 96
49
votes
3 answers

How does the DynamoDB partition key work?

I'm trying to understand how the partition created for DynamoDB tables. According to this blog, "All items with the same partition key are stored together", so if I have a table with user id from 1 to 1000, does that mean I will have 1000 partition?…
user1883793
  • 4,011
  • 11
  • 36
  • 65
49
votes
3 answers

How to do basic aggregation with DynamoDB?

How is aggregation achieved with dynamodb? Mongodb and couchbase have map reduce support. Lets say we are building a tech blog where users can post articles. And say articles can be tagged. user { id : 1235, name : "John", …
49
votes
4 answers

How to update multiple items in a DynamoDB table at once

I'm using DynamoDB and I need to update a specific attribute on multiple records. Writing my requirement in pseudo-language I would like to do an update that says "update table persons set relationshipStatus = 'married' where personKey IN (key1,…
Stanley
  • 5,261
  • 9
  • 38
  • 55
49
votes
2 answers

what will happen if we insert into dynamo DB with a duplicate hash key?

I am trying to insert into dynamo DB. When I call the putItem function what will happen if the hash key is already present in the DB? Does the PutItemResult object contain something which can tell us if a duplicate hash entry was attempted? I want…
coder
  • 823
  • 2
  • 10
  • 17