NOSREAD_SCHEMA | Advanced SQL Engine 17.10 - 17.10 - NOSREAD_SCHEMA RETURNTYPE for JSON, CSV, and Parquet - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Release Definition

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1725-171K
Language
English (United States)

If you need information about the schema of your CSV, JSON, and Parquet data, you can use the NOSREAD_SCHEMA return type in your READ_NOS statement and the schema is detected automatically. The syntax is RETURNTYPE('NOSREAD_SCHEMA').

For Parquet data you can also continue to use the return type NOSREAD_PARQUET_SCHEMA if you are using the FULLSCAN option, as FULLSCAN is not available in NOSREAD_SCHEMA.

See Teradata Vantageā„¢ - SQL Operators and User-Defined Functions, B035-1210, available at https://docs.teradata.com/.