INSERT - Amazon Quantum Ledger Database (Amazon QLDB)

INSERT

Use the INSERT command to add one or more Amazon Ion documents to a table in Amazon QLDB.

Note

To learn how to control access to run this PartiQL command on specific tables, see Getting started with the standard permissions mode in Amazon QLDB.

Syntax

Insert a single document.

INSERT INTO table VALUE doc

Insert multiple documents.

INSERT INTO table << doc, doc, ... >>

Parameters

table

The user table where you want to insert the data. The table must already exist. DML statements are only supported in the default user view.

doc

A valid QLDB document. You must specify at least one document. Multiple documents must be separated by commas.

The document must be denoted with curly braces ( {...} ).

Each field name in the document is a case-sensitive Ion symbol that can be denoted with single quotation marks ('...') in PartiQL.

String values are also denoted with single quotation marks ('...') in PartiQL.

Any Ion literals can be denoted with backticks (`...`).

Note

Double angle brackets ( <<...>> ) denote an unordered collection (known as a bag in PartiQL) and are required only if you want to insert multiple documents.

Return value

documentId – The unique ID of each document that you inserted.

Examples

Insert a single document.

INSERT INTO VehicleRegistration VALUE { 'VIN' : 'KM8SRDHF6EU074761', --string 'RegNum' : 1722, --integer 'State' : 'WA', 'City' : 'Kent', 'PendingPenaltyTicketAmount' : 130.75, --decimal 'Owners' : { --nested struct 'PrimaryOwner' : { 'PersonId': '294jJ3YUoH1IEEm8GSabOs' }, 'SecondaryOwners' : [ --list of structs { 'PersonId' : '1nmeDdLo3AhGswBtyM1eYh' }, { 'PersonId': '1nmeDdLo3AhGswBtyM1eYh' } ] }, 'ValidFromDate' : `2017-09-14T`, --Ion timestamp literal with day precision 'ValidToDate' : `2020-06-25T` }

Insert multiple documents (that is, a bag of documents).

INSERT INTO Person << { 'FirstName' : 'Raul', 'LastName' : 'Lewis', 'DOB' : `1963-08-19T`, 'GovId' : 'LEWISR261LL', 'GovIdType' : 'Driver License', 'Address' : '1719 University Street, Seattle, WA, 98109' }, { 'FirstName' : 'Brent', 'LastName' : 'Logan', 'DOB' : `1967-07-03T`, 'GovId' : 'LOGANB486CG', 'GovIdType' : 'Driver License', 'Address' : '43 Stockert Hollow Road, Everett, WA, 98203' }, { 'FirstName' : 'Alexis', 'LastName' : 'Pena', 'DOB' : `1974-02-10T`, 'GovId' : '744 849 301', 'GovIdType' : 'SSN', 'Address' : '4058 Melrose Street, Spokane Valley, WA, 99206' } >>

Running programmatically using the driver

To learn how to programmatically run this statement using the QLDB driver, see the following tutorials in Getting started with the driver: