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
69
votes
3 answers

When does DynamoDB throttle request?

In the answer to "How is Amazon DynamoDB throughput calculated and limited?" it's been suggested, that DynamoDB throttles request whenever you exceed provisioned throughput on per second basis. However, this contradicts my experience. I've table…
vartec
  • 131,205
  • 36
  • 218
  • 244
67
votes
4 answers

How do you query for a non-existent (null) attribute in DynamoDB

I'm trying to query a DynamoDB table to find all items where the email attribute is not set. A global secondary index called EmailPasswordIndex exists on the table which includes the email field. var params = { "TableName": "Accounts", …
Jordan Mack
  • 8,223
  • 7
  • 30
  • 29
65
votes
10 answers

DynamoDB : The provided key element does not match the schema

Is there a way to get an item depending on a field that is not the hashkey? Example My Table Users: id (HashKey), name, email And I want to retrieve the user having email as 'test@mail.com' How this can be done? I try this with boto: user =…
user1635536
63
votes
3 answers

Terraform + DynamoDB: All attributes must be indexed

I want to create a Terraform configuration for DynamoDB table with multiple (> 10) attributes. And I have no need to add all attributes as an index to global_secondary_index or local_secondary_index. But when I run terraform plan command I have…
Kateryna Khotkevych
  • 1,248
  • 1
  • 12
  • 22
63
votes
21 answers

Export data from DynamoDB

Is it possible to export data from DynamoDB table in some format? The concrete use case is that I want to export data from my production dynamodb database and import that data into my local dynamodb instance so my application can work with local…
63
votes
5 answers

Is there a way to enforce unique constraint on a property (field) other than the primary key in dynamodb

In dynamodb, if you want to enforce uniqueness in a field other than the primary key (like were you have a users table and want unique email addresses for users while primary key is a userid which is a number) is there a way other thans scanning the…
Ali
  • 18,665
  • 21
  • 103
  • 138
63
votes
15 answers

Copying one table to another in DynamoDB

What's the best way to identically copy one table over to a new one in DynamoDB? (I'm not worried about atomicity).
ensnare
  • 40,069
  • 64
  • 158
  • 224
62
votes
7 answers

How can I join tables in AWS DynamoDB?

I know the whole design should be based on natural aggregates (documents), however, I'm thinking to implement a separate table for localisations (lang, key, text) and then use keys in other tables. However, I was unable to find any example on doing…
Centurion
  • 14,106
  • 31
  • 105
  • 197
62
votes
4 answers

How do we query on a secondary index of dynamodb using boto3?

Is there a way at all to query on the global secondary index of dynamodb using boto3. I dont find any online tutorials or resources.
ZZzzZZzz
  • 1,800
  • 3
  • 29
  • 51
61
votes
3 answers

Dynamodb scan in sorted order

Hi I have a dynamodb table. I want the service to return me all the items in this table and the order is by sorting on one attribute. Do I need to create a global secondary index for this? If that is the case, what should be the hash key, what is…
Erben Mo
  • 3,528
  • 3
  • 19
  • 32
60
votes
4 answers

How to convert a boto3 Dynamo DB item to a regular dictionary in Python?

In Python, when an item is retrieved from Dynamo DB using boto3, a schema like the following is obtained. { "ACTIVE": { "BOOL": true }, "CRC": { "N": "-1600155180" }, "ID": { "S": "bewfv43843b" }, "params": { "M": { …
manelmc
  • 937
  • 2
  • 7
  • 17
58
votes
1 answer

Append a new object to a JSON Array in DynamoDB using NodeJS

I am using a JSON structure to store details of a person. Basically name, phone, registeredTimestamp etc., will be other attributes, and Primary key will be the email address. markedLocations, visitedLocations, searchHistory and recommendation are…
bozzmob
  • 12,364
  • 16
  • 50
  • 73
56
votes
4 answers

Localhost Endpoint to DynamoDB Local with Boto3

Although Amazon provides documentation regarding how to connect to dynamoDB local with Java, PHP and .Net, there is no description of how to connect to localhost:8000 using Python. Existing documentation on the web points to the use of the…
R J
  • 4,473
  • 2
  • 22
  • 29
55
votes
3 answers

How do you query DynamoDB?

I'm looking at Amazon's DynamoDB as it looks like it takes away all of the hassle of maintaining and scaling your database server. I'm currently using MySQL, and maintaining and scaling the database is a complete headache. I've gone through the…
chriserwin
  • 1,222
  • 1
  • 10
  • 13
54
votes
2 answers

Scan Function in DynamoDB with reserved keyword as FilterExpression NodeJS

My scan function : var tableName = 'faasos_orders', filterExp = 'status = :delivered OR status = :void OR status = :bad', projectionValues = '', expressionAttr = {}; expressionAttr[":delivered"] = "delivered"; …
Saleem Ahmed
  • 2,719
  • 2
  • 18
  • 31