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: Iceberg
- The following are not supported:
- Non-Positional inserts.
- Writing ORC data files.
- Writing to a BLOB column.
- Parameterized SQL for Array Insert for an OTF table.