AWS DynamoDB – PartiQL Insert Statement

PartiQL is a SQL-compatible query language that supports querying, modifying, and inserting data. It makes it easier to interact with DynamoDB and run queries in AWS Management Console.

Syntax:

INSERT INTO table-name VALUE item;

• Table name: Required – Name of the table in which you want to insert data
• Item: Required – Value that you want to insert into the table.

Example:

INSERT INTO Books VALUE 
{
'bookId':  1,
'bookName': ‘Book Name’,
'bookAuthor': ‘Book Author’,
'quantity': 20  
};

Pre – Requisites: 

1. AWS Account
2. DynamoDB table

Implementation:

Step 1: Login into your AWS account. Search for “DynamoDB” which will be present under “Services”, select it.

Step 2: Once you are directed to the DynamoDB Management Console, on the left side there is PartiQL editor, select it.

Step 3: After you are directed to the PartiQL editor, Select the table that you want to insert data into.  

Step 4: Type the Query in the editor and click on run, it should be executed successfully.

Step 5: The data gets inserted into the table, and the insert operation is completed.