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 RoleAWS 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.
|