Inserting Data into Apache Iceberg Tables

The INSERT command inserts records into a table, either from values provided in the SQL command or from rows returned by a SELECT statement.

If the table does not exist or the schema does not match, the INSERT operation fails.

Syntax

INSERT INTO <table_path>.<table_name>
[ ( <column_name> [, <column_name> ...]) ]
{
   select_statement
   | VALUES (value [, value ...]) [, (value [, value ...]) ...] 
}

Parameters

{{< sql-section file="data/sql/apache-iceberg-tables.json" data="insertingData" >}}

Example

Inserts three records

INSERT INTO myTable VALUES 
    (21, 'Ruth Asawa', 'American, 1926–2013', 'American', 'Female', 1926, 2013, 'Q7382874', '500077806'), 
    (38, 'Magdalena Abakanowicz', 'Polish, 1930–2017', 'Polish', 'Female', 1930, 2017, 'Q158080', '500084577'),
    (56, 'Luis Alberto Acuña', 'Colombian, 1904–1994', 'Colombian', 'Male', 1904, 1994, null, null)