NOS Functionality | Teradata Vantage Trial - NOS Functionality - Vantage Trial

Teradata Vantageā„¢ Trial Quick Start Guide

Product
Vantage Trial
Release Number
2.7
Published
August 2022
Language
English (United States)
Last Update
2022-08-04
dita:mapPath
jzh1567636979792.ditamap
dita:ditavalPath
pnw1578847806387.ditaval
dita:id
B035-2820
With NOS you can do the following:
  • Analyze data stored on an external object store.
  • Read data in CSV, JSON, or Parquet format stored on an external object store.
  • Join or aggregate external data to relational data stored in SQL Engine
  • Query cold data offloaded to an external object store.
  • Load data from external object store into the database using one SQL request.
  • Write SQL Engine data to an external object store. The data to be written can come from a table, derived results, another object store, QueryGrid federated query, and so on.

You can use WRITE_NOS to transform CSV and JSON data without having to write it locally to a relational table. Read the CSV or JSON data using CREATE FOREIGN TABLE or READ_NOS, then use WRITE_NOS to write the data in Parquet format.