Insert data into DynamoDB Table using PartiQL
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 };
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.