Skip to content
Related Articles
Open in App
Not now

Related Articles

AWS DynamoDB – PartiQL Insert Statement

Improve Article
Save Article
  • Last Updated : 20 Jan, 2022
Improve Article
Save Article

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.

Insert data into DynamoDB Table using PartiQL:


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.


'bookId':  1,
'bookName': ‘Book Name’,
'bookAuthor': ‘Book Author’,
'quantity': 20  

Using PartiQL in AWS Management Console:

Pre – Requisites: 

  1. AWS Account
  2. DynamoDB table


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.

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!