Analytics Database (SQL Engine) 17.20 | NOS Changes & Additions | Vantage - Changes and Additions - Analytics Database - Teradata Vantage

Teradata Vantage™ - Native Object Store Getting Started Guide - 17.20

Analytics Database
Teradata Vantage
Release Number
June 2022
English (United States)
Last Update
Product Category
Teradata Vantage
Date Release Description
March 2024
  • The maximum page size supported is 512 MB for Parquet and CSV.
  • Updated Supported External Object Storage Platforms to include Cohesity SmartFiles, update Cloudera to Cloudera Ozone, and update Vast Data to Vast DataStore.
  • Support for AWS Assume Role:
    • AWS Assume Role allows existing AWS IAM users and service accounts temporary access to AWS resources in other accounts. See Using AWS Assume Role and CREATE AUTHORIZATION in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
November 2022
  • Updated Parquet External Files with information about setting the binpacking algorithm to use when reading Parquet files.
  • Cloudian HyperStore is a supported external store.
June 2022 17.20
  • Added support for Delta Lake. See Using Delta Lake Manifest Files.
  • JSON External Files updated.
  • For Parquet data, the FULLSCAN option limitation has been removed. NOSREAD_SCHEMA is now equivalent to NOSREAD_PARQUET_SCHEMA.
  • Reorganized content and fixed minor errors.
July 2021 17.10
  • NOS is enabled by default.
  • NOS supports both Google S3-compatible and native connectors. See Authentication for External Object Stores.
  • READ_NOS now supports Parquet data format.
  • SQL syntax has been simplified for NOS and all examples have been updated accordingly:
    • CREATE FOREIGN TABLE syntax is updated to include columns for each field in the CSV data instead of using a complex data type in the payload column. This eliminates the need to use dot notation and it is more efficient.
    • Authorization examples are updated to use simplified system-wide authorization model new in this release.
    • 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').
    • READ_NOS syntax has been simplified so that the SELECT statement does not require the READ_NOS table operator in the statement.
January 2021 17.05 Added WRITE_NOS feature.
September 2020 17.00 Google Cloud Storage is a supported external object store.