How to Upload JSON File to Amazon DynamoDB using Python?

Last Updated : 24 Oct, 2023

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. It offers scalability, reliability, and fast access to data for applications of any scale. DynamoDB supports both document and key-value data models and handles administrative tasks, allowing developers to focus on their applications.

Features Of DynamoDB

DynamoDB excels in scalability, automatically handling millions of requests per second and supporting read and write scalability. It partitions data across servers to ensure high throughput. The service provides low-latency access to data using SSD storage and in-memory caching, making it suitable for real-time applications.
The database offers flexible data models. In the key-value model, data is stored and retrieved using a primary key. The document model allows nesting attributes within items and performing complex queries on the document structure.
ACID transactions are supported, ensuring atomicity and consistency for multiple operations. Security features include encryption at rest and in transit, fine-grained access control, and auditing capabilities.
DynamoDB’s Global Tables enable multi-region replication for high availability and disaster recovery. Integration with AWS services like Lambda, AppSync, Kinesis, and Glue streamlines application development.
With its versatility, scalability, and managed nature, DynamoDB is widely used in web applications, gaming, mobile apps, IoT, ad tech, and more. Developers appreciate its ability to handle large workloads, provide low-latency access, and simplify database management.

Steps To Create a DynamoDB Table

Step 1: Sign in to your AWS account and click on Services. To create a free tier AWS account refer to Amazon Web Services – Setting Up an AWS Account.

Step 2: Search for DynamoDB and click on Create Table.

DynamoDB Create Table

Step 3: Configure the DynamoDB table by providing the table name and partition key values

DynamoDB Create Table

Step 4: Click on Create Table after the configuration

Uploading Json Objects to AWS DynamoDB using Python

Here we will be using Visual Studio Code for developing the Python Code. The boto3 package is used in the below code. This package can be installed using ‘pip install boto3‘ from the terminal. Boto3 is the SDK in Python for interacting with AWS Services directly.

details.json

[
    {
        "id": "1",
        "first_name": "Mihir",
        "last_name": "Panchal",
        "email": "mihirpanchal5400@gmail.com"
    },
    {
        "id": "2",
        "first_name": "Geeks",
        "last_name": "ForGeeks",
        "email": "geeksforgeeks@gmail.com"
    }
]

Python Boto3 Library

The boto3 library is a Python library that provides an interface to Amazon Web Services (AWS) services, including Amazon DynamoDB. The put_item() method on the DynamoDB client is used to insert an item into a table. The Item parameter of the put_item() method is a dictionary that contains the key-value pairs for the item.

Python3

import boto3 
import json 
  
dynamodb = boto3.client('dynamodb') 
  
with open('details.json') as f: 
    data = json.load(f) 
  
for item in data: 
    response = dynamodb.put_item( 
        TableName='GeeksForGeeks', 
        Item={ 
            'ID': {'S': item['id']}, 
            'first_name': {'S': item['first_name']}, 
            'last_name': {'S': item['last_name']}, 
            'email': {'S': item['email']}, 
        } 
    ) 
    print(response)