Load External Data | Native Object Store ( NOS ) | Teradata Vantage - 17.10 - Loading External Data into the Database - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1214-171K
Language
English (United States)
The methods for loading external data into the database are as follows:
Method Description
CREATE TABLE AS … WITH DATA Accesses table definitions and data from an existing foreign table and creates a new permanent table inside the database
CREATE TABLE AS … FROM READ_NOS Accesses data directly from the object store and creates a permanent table inside the database
INSERT ... SELECT Stores values from external data in a persistent database table using an INSERT ... SELECT statement