The INSERT INTO SQL can be used to insert a single row into an OTF table.
Syntax
INSERT INTO <datalake_name>.<OTFdatabase_name>.<OTFtable_name>
VALUES (<value>[, ...]);
<datalake_name> ::= !! name of the data lake object
<OTFdatabase_name> ::= !! name of the database in the OTF catalog
<OTFtable_name> ::= !! name of the OTF table
Example
INSERT INTO datalake_glue.MyDatabase.Tab1
VALUES ('testing', 1, 'field3', 'France');
Usage Considerations
The following are not supported:
- Non-positional inserts.
- Writing ORC data files in Iceberg.
- Writing to a CLOB column.
- Parameterized SQL for Array Insert for an OTF table.