Load External CSV Data | Native Object Store ( NOS ) | Teradata Vantage - 17.00 - Loading External CSV Data into the Database - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
September 2020
category
Programming Reference
featnum
B035-1214-170K
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