Vantage Analytics Library Functions | Analytics Library - 2.0 - Vantage Analytics Library Functions - Vantage Analytics Library

Vantage Analytics Library User Guide

Vantage Analytics Library
Release Number
Release Date
May 2021
Content Type
User Guide
Publication ID
English (United States)

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata® Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage.

Advanced SQL Engine (was NewSQL Engine) is a core capability of Teradata Vantage, based on our best-in-class Teradata Database. Advanced SQL refers to the ability to run advanced analytic functions beyond that of standard SQL.

Vantage Analytics Library provides the Data Scientist with over 50 advanced analytic functions built directly in the Advanced SQL Engine. These functions support the entire data science process— exploratory data analysis, data preparation and feature engineering, hypothesis testing, statistical and machine learning model building, and scoring.

To call a Vantage Analytics Library function, use Teradata Studio™ or Basic Teradata Query (BTEQ). The controlling program for these analytic functions is the custom Teradata External Stored Procedure td_analyze. Some functions also use custom Teradata Table Operators. To use the Vantage Analytics Library functions, these user-defined functions (UDFs) must be installed in the Vantage database using scripts supplied with the product.

To run the Statistical Tests described in this guide, the Statistical Test Metadata tables must be loaded into a database on the system to be analyzed. You can use the supplied scripts to accomplish this. (Each Statistical Test function has a statsdatabase parameter for specifying the database in which these tables are installed.)

You can use the Analytics Library with any SQL processing tool that Teradata supports.

  • If td_analyze is not installed in a public access account on Vantage, you must qualify td_analyze calls with the database where it is installed. Example: val_user.td_analyze.
  • By default, before an analytic function creates an output table, it drops the existing table. To prevent dropping existing output tables, specify overwrite=false.
  • You can copy and use the examples in this document on a system where the UDF is installed and the tutorial environment is set up. The tutorial environment includes the val_user default user name, val_source database with tutorial tables installed, and val_results database.
  • Starting with Vantage Release 16.20 Update 2, during the initialization of Vantage on newer platforms, the Always Fallback property is selected. Therefore, any FALLBACK parameter set in the analytic functions is ignored. However, for older systems or for systems upgraded from them, the FALLBACK parameter for analytic functions may be used effectively.