R and Python Support in Teradata Vantage™ - Teradata Vantage

Teradata Python Package
Teradata R Package
Teradata Vantage
July 2019
Fast Facts

R and Python Support in Teradata Vantage

Teradata Vantage supports R and Python languages both at client side and in database.

The client side and in-database options for R and Python enable users to jointly perform analytics with no SQL coding required, provide users with functions for data manipulation and transformation, data filtering and sub-setting, and can be used in conjunction with open source libraries.

Client Side

The Teradata R and Python packages include access to powerful Vantage analytic functions together with data manipulation functions to provide extensive analytic capabilities at client side. They combine the benefits of the open source language environment with the massive parallel processing capabilities of Vantage, which includes Teradata® Machine Learning Engine analytic functions and Teradata NewSQL Engine in-database analytic functions.

The language interpreters are installed on a client machine that connects to Vantage.

Teradata R Package tdplyr (R library package)

Installation: See Teradata R Package User Guide

The tdplyr package conforms and works with the verbs and functions of the dplyr and dbplyr libraries.

Functions: See Teradata R Package Function Reference

Teradata Python Package teradataml (Python library package)

Installation: See Teradata Python Package User Guide

The teradataml package uses SQLAlchemy and works with verbs and functions of Pandas library.

Functions: See Teradata Python Package Function Reference


R and Python in-database analytics requires the R or Python interpreter and corresponding add-on library packages for R and Python script execution using ExecR Table Operator and Script Table Operator. The language interpreters and corresponding R and Python add-on libraries are installed on each NewSQL Engine node. For information, see Teradata Vantage SQL External Routine Programming and Teradata Vantage SQL Operators and User-Defined Functions or contact your Teradata Account Representative.