Introduction to Teradata Package for Python - 17.00 - Introduction to Teradata Package for Python - Teradata Package for Python

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Release Date
November 2021
Content Type
User Guide
Publication ID
B700-4006-070K
Language
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 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 Package for Python 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 Package for Python allows users to develop and run Python programs that take advantage of the Big Data and Machine Learning analytics capabilities of Vantage.

The Teradata Package for Python 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 Package for Python 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 Package for Python 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.