teradata

What it is and what it does

The Teradata Python Module is a library for scripting interactions with Teradata databases, emphasizing DevOps workflows by handling operational concerns like query banding, logging, and external configuration automatically. It wraps Teradata ODBC and REST Services to provide a SQL execution engine where developers write SQL and procedural logic without managing connection details themselves.

The package is now deprecated and abandoned, with the latest release on 2017-04-29. Teradata explicitly recommends using a newer implementation for new projects. The module depends on external Teradata system libraries (ODBC driver) and REST Services access, creating significant installation and maintenance friction. It carries no known security vulnerabilities but offers no ongoing support or updates.

Use it for:

• Maintaining legacy Teradata database automation scripts that were written against this module
• DevOps pipelines for Teradata that predate newer implementations and cannot be easily migrated
• Educational or historical reference for understanding older Teradata Python integration patterns
• Systems locked into older Teradata infrastructure where alternatives are not yet available

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides Python bindings to execute SQL scripts and procedural logic against Teradata databases with DevOps-focused features like query banding and logging.

No. This package is deprecated and abandoned since 2017-04-29; Teradata's own recommendation is to use a newer implementation instead. The high install friction (external ODBC and REST Services dependency), lack of maintenance, and explicit deprecation notice make this a poor choice for new projects. Only consider if maintaining legacy code that already depends on it and cannot migrate.

Install

teradata on PyPI

pip install teradata

uv add teradata

poetry add teradata

Installing teradata

Before you install

High install friction due to external system dependencies. Package is abandoned; latest release was 2017-04-29 with no updates since. Teradata recommends migrating to a newer implementation.

License in practice

MIT license permits commercial and private use with minimal restrictions, though the abandoned status makes ongoing support unlikely.

Quickstart

pip install teradata

import teradata

# Requires connection info in udaexec.ini or environment
with teradata.UdaExec(appName='myapp') as udaexec:
    for row in udaexec.execute('SELECT * FROM table'):
        print(row)

Requires Teradata ODBC driver installed on system and access to Teradata REST Services; connection configuration via udaexec.ini file or environment variables needed.

Verify before relying

• Whether Teradata ODBC driver installation and configuration is straightforward on target systems
• Compatibility with modern Python versions and current Teradata database releases
• Whether REST Services access requirement is still applicable or has changed
• Migration path and effort required to move legacy code to the recommended replacement

Package facts

Evidence: teradata-15.10.0.21.tar.gz

Tags

More Database packages