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 Using AWS Assume Role and CREATE AUTHORIZATION in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
|
March 2024 |
17.20.03.24 |
- 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 |
17.20.03.07 |
- 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. |