Analytic Languages - Teradata Vantage

Configuring Teradata Vantage™ After Installation

Product
Teradata Vantage
Release Number
1.1
Published
July 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
qyu1559916244734.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4014
lifecycle
previous
Product Category
Analytical Ecosystem
Software
Teradata Vantage

The following table lists supported analytic languages for Vantage along with links to installation and user guides.

Application Description References
Python Teradata provides an SQL driver and an analytic library for Python that can be loaded into the client Python environment. These packages allow you to develop Python scripts that access data in the Vantage system and run Vantage analytic functions. Vantage also allows execution of Python scripts on the server.

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

Teradata Python package:
R Teradata provides an ODBC driver and an analytic library for R that can be loaded into the client R environment. These packages allow you to develop R scripts that access data in the Vantage system and run Vantage analytic functions. Vantage also allows execution of R scripts on the server through the ExecR system table operator.

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

Teradata R package:
SQL Analytic functions can be called from SQL. The analytic functions run in-database on Advanced SQL Engine or on Machine Learning Engine. Analytic functions:
  • Teradata Vantage™ - Advanced SQL Engine Analytic Functions, B035-1206
  • Teradata Vantage™ Machine Learning Engine Analytic Function Reference, B700-4003