What's New in VantageCloud Lake | May 2024 - May 2024 - Teradata VantageCloud Lake

Lake - Updates and Changes
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
gze1736983055688.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
gze1736983055688

These enhancements were added for all platforms unless specified in the title for a specific platform.

VantageCloud Lake Supported AWS Regions

VantageCloud Lake on AWS is now available in the following region:

VantageCloud Lake Supported AWS Regions
Region Name Region
Europe (Frankfurt) eu-central-1

VantageCloud Lake Supported Azure Regions

VantageCloud Lake on Azure is now available in the following regions:

VantageCloud Lake Supported Azure Regions
Region Name Region
West US 2 (Washington) westus2
UK South (London) uksouth

Open Table Format Support

Write capability using new Teradata SQL statements and Java table options is now supported by the Apache Iceberg version 2 and Delta Lake version 3.0 formats. See the following table for feature support.
Open Table Format Supported Data File Format Supported Catalogs Supported Object Stores
Iceberg
  • Parquet
  • AVRO
 Iceberg Write Java for Hive and Glue catalogs
  • Amazon Simple Storage Service (S3)
  • Azure Data Lake Storage Gen2
  • Microsoft Azure Blob Storage
Delta Lake Parquet Delta Lake Databricks/Unity catalog on AWS and Azure
  • Amazon Simple Storage Service (S3)
  • Azure Data Lake Storage Gen2

See Open Table Format Data Types for supported compression types and data type mapping information.

See the following topics to review Datalake Form statements:

Unified Query Summary

Queries now offers a Unified Query Summary view which combines active, failed, and completed queries in one view. You can search, refresh, cancel, and narrow down the time period for the view.

OFS MERGE INTO Statement

The MERGE INTO function is now supported on the primary and compute clusters for Object File Storage (OFS) tables.

There can be different execution plans for primary and compute clusters based on different kind of source and target table combinations:

  • Target-OFS, Source-OFS
  • Target-OFS, Source refers more than one OFS tables
  • Target-OFS, Source refers both OFS and BFS tables
  • Target-OFS, Source-BFS
  • Target-BFS, Source-OFS

See MERGE Usage Notes.

Enhanced Diagnostics and Extended Logging Capabilities

The enhanced Extended DBQL statistics allow for more granular data collection, enabling the isolation of specific express step executions at the AMP level and their associated user SQL.

The elapsed times of step execution can be readily determined at the AMP level.

Additionally, you can obtain the associated resource usage to identify potential bottlenecks such as CPU or IO. With this feature, the elapsed times can be as precise as microseconds due to the new data being collected.

See BEGIN QUERY LOGGING and SHOW QUERY LOGGING.

New Unbounded Array Framework Functions

The following Unbounded Array Framework functions were added:

  • TD_KALMAN_FORECASTER. Generates a forecast and related metrics in secondary output layers. This function extends the linear regression model by accepting time-varying regression coefficients. See TD_KALMAN_FORECASTER.
  • TD_SMOOTHMA_FORECASTER. Applies a user-selected smoothing function to an input series, creating new time series highlighting the trend along with a naïve forecast. See TD_SMOOTHMA_FORECASTER.

TD_SHAP

TD_SHAP is a method to explain individual predictions (feature contributions) for a machine learning model based on the cooperative game theory. See TD_SHAP.