Load External JSON Data | Native Object Store ( NOS ) | Teradata Vantage - 17.05 - Loading External JSON 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.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1214-175K
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