---
id: teradata
version: "15.10.0.21"
license: MIT
license_treatment: permissive
maintenance: abandoned
---

# teradata — The Teradata python module for DevOps enabled SQL scripting for Teradata UDA.

License: permissive · Maintenance: abandoned · Downloads: 87.0K/mo

## 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 above — 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

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

- License: MIT (permissive)
- Python support: unspecified
- Install friction: high
- Maintenance: abandoned
- Downloads: 87.0K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

teradata python driver, teradata sql execution, teradata database client, teradata devops scripting, teradata odbc python, teradata query banding, deprecated, teradata-legacy

[View on SkillFed](https://skillfed.io/packages/teradata) · [View on PyPI](https://pypi.org/project/teradata/)