Loading and Accessing Data | VantageCloud Lake - Loading and Accessing Data Using SQL - 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

For the current release, you cannot use load utilities to load data into Object File System tables. However, you can use the load utilities to load data into a file system table and then use insert statements to load the data from the file system table into the Object File System table.

You can use these statements to insert and update data in Object File System tables:

To access data in Object File System tables, see Querying Object File System Data.

To access data in the foreign tables on external object storage, use READ_NOS and WRITE_NOS. See Use Native Object Store to Work with Data in External Object Storage for details of their syntax and usages.