Inserting a Single Row into an OTF Table - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

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.