Introduction to Teradata Python Package - Teradata Python Package

Teradata® Python Package User Guide

Product
Teradata Python Package
Release Number
16.20
Published
February 2020
Language
English (United States)
Last Update
2020-02-29
dita:mapPath
rkb1531260709148.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-4006
lifecycle
previous
Product Category
Teradata Vantage

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.

The Teradata® Python Package product combines the benefits of the open source Python language environment with the massive parallel processing capabilities of Teradata Vantage, which includes the Machine Learning Engine analytic functions and the Advanced SQL Engine in-database analytic functions. The Teradata Python package allows users to develop and run Python programs that take advantage of the Big Data and Machine Learning analytics capabilities of Vantage.

The Teradata Python Package is teradataml, a Python library package like other open source Python packages. The package interface makes available to Python users a collection of functions for analytics that reside on Vantage, so that Python users can perform analytics with no SQL coding required. Specifically, the teradataml package provides functions for data manipulation and transformation, data filtering and sub-setting, and can be used in conjunction with open source Python libraries. The teradataml package uses SQLAlchemy and provides an interface similar to the Pandas Python library.

The Teradata Python Package works over connections to:

  • Teradata Vantage with Advanced SQL Engine and ML Engine
  • Teradata Vantage with Advanced SQL Engine only
    For the Teradata Vantage with Advanced SQL Engine only type of connection, only Advanced SQL Engine analytic functions are accessible.

Teradata Vantage Modules for Jupyter

Teradata Python Package is included in the Docker image of Teradata Vantage™ Modules for Jupyter, which also includes JupyterLab and other components to run as a Docker container on a client machine.

Teradata Vantage Modules for Jupyter allows users to access Vantage in Python, R or SQL from JupyterLab notebooks.

See Teradata Vantage™ Modules for Jupyter Installation Guide, B700-4010.