Changes/Additions | Data Manipulation Language | Teradata Vantage - Changes and Additions - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™
Date Release Description
August 2024 17.20.03.29 DURATION_SECONDS clause for Assume Role
  • DURATION_SECONDS is an optional custom clause to set the duration of AWS Assume Role. You or your administrator can create an authorization object with the optional DURATION_SECONDS clause to store duration in seconds, used in the execution of CREATE FOREIGN TABLE, SELECT, READ_NOS, and WRITE_NOS. See Examples: Using READ_NOS, WRITE_NOS Examples, and Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
March 2024 17.20.03.24 Support for AWS Assume Role
  • AWS Assume Role allows existing AWS IAM users and service accounts temporary access to AWS resources in other accounts. You or your administrator can create an authorization object to allow this type of access for READ_NOS and WRITE_NOS. See and CREATE AUTHORIZATION in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

June 2023 17.20.03.14 Changes to WRITE_NOS ROWFORMAT clause:
  • Now optional for CSV data and disallowed for other data types.
  • No longer includes character_set.

See WRITE_NOS Syntax Elements.

December 2022 17.02.03.08

Added CSV option to STOREDAS clause of WRITE_NOS Syntax.

October 2022 17.20.03.06 Added SCANPCT clause to READ_NOS Syntax.
July 2022 17.20.03.03 WRITE_NOS changes:
  • In WRITE_NOS, subquery can include expression that generates destination path name to reference in PARTITION BY clause. See Generate Destination Path Name in Subquery.
  • New WRITE_NOS examples show how PARTITION_BY and INCLUDE_ORDERING interact.
June 2022 17.20.03.01
July 2021 17.10

Error tables for foreign tables: Updated Working with External Data.

Updated READ_NOS Syntax to simplify authorization syntax. Old authorization syntax is still valid.

Updated Google Cloud Authorizations for Foreign Tables: See READ_NOS Syntax Elements and Example: Using READ_NOS to Query a File in Google Cloud Storage.

Updated Azure LOCATION syntax for NOS. See following:

WRITE_NOS ACCESS_ID and ACCESS_KEY

Updated WRITE_NOS Syntax.

June 2020 17.00

Native Object Store

Added Working with External Data topics.