INSERT Statement | Object File System Tables | VantageCloud Lake - INSERT Statement - Teradata VantageCloud Lake

Lake - Manage and Move Data

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-05-16
dita:mapPath
atx1683670417382.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
atx1683670417382

You can use the INSERT statement to add new rows to an Object File System table by directly specifying the row data to be inserted or by retrieving the new row data from another table. See SQL Data Manipulation Language for details of syntax and usages of the INSERT statement.

Singleton and array INSERTs are supported for Object File System tables. Inserting rows using these INSERT statements creates single-row and few-row objects. If such INSERTs are done in large scale, there might be a potential impact on read performance.