INSERT
Use the INSERT
command to add one or more Amazon Ion documents to a
table in Amazon QLDB.
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_name
VALUEdocument
Insert multiple documents.
INSERT INTO
table_name
<<document
,document
, ... >>
Parameters
table_name
-
The name of 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.
document
-
A valid QLDB document. You must specify at least one document. Multiple documents must be separated by commas.
The document must be denoted by curly braces (
{...}
).Each field name in the document is a case-sensitive Ion symbol that can be denoted by single quotation marks (
'...'
) in PartiQL.String values are also denoted by single quotation marks (
'...'
) in PartiQL.Any Ion literals can be denoted with backticks (
`...`
).
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': 'IN7MvYtUjkp1GMZu0F6CG9' } ] }, 'ValidFromDate' : `2017-09-14T`, --Ion timestamp literal with day precision 'ValidToDate' : `2020-06-25T` }
This statement returns the unique ID of the document that you inserted, as follows.
{
documentId: "2kKuOPNB07D2iTPBrUTWGl"
}
Insert multiple 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' } >>
This statement returns the unique ID of each document that you inserted, as follows.
{
documentId: "6WXzLscsJ3bDWW97Dy8nyp"
},
{
documentId: "35e0ToZyTGJ7LGvcwrkX65"
},
{
documentId: "BVHPcH612o7JROQ4yP8jiH"
}
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:
-
Node.js: Quick start tutorial | Cookbook reference
-
Python: Quick start tutorial | Cookbook reference