teradata

library15.10.0.21pypypi✓ verified 86d ago

The official Teradata Python driver (PyTd) for executing SQL against Teradata UDA (Unified Data Architecture). Version 15.10.0.21 supports Teradata Database 15.10+. The library is in maintenance mode; newer applications should consider using the `teradatasql` driver. Release cadence is intermittent.

database

pip install teradata

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · TERADATA

teradata

databasepythonv15.10.0.21

Install

2.7s avg

Import

169ms

Disk

17MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v15.10.0.21 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

installs and imports cleanly · install 0.0s · import 0.164s · 19.5MB

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 2.7s · import 0.174s · 20MB

17MB installed

● package 17MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

udaExec

✓ import teradata

✗ from teradata import udaExec

udaExec is a module attribute, not a direct import; use 'import teradata' then 'teradata.UdaExec'

teradata.UdaExec

✓ udaExec = teradata.UdaExec(appName='test')

✗ import UdaExec

'UdaExec' is inside the teradata package; direct import does not work.

Connect using ODBC and run a simple query.

import teradata udaExec = teradata.UdaExec(appName='test', version='1.0', logConsole=False) session = udaExec.connect(method='odbc', system='your_td_host', username=os.environ.get('TD_USER', ''), password=os.environ.get('TD_PASS', '')) query = "SELECT DATABASENAME FROM DBC.DATABASESV WHERE DATABASENAME = 'DBC'" df = session.execute(query).fetchall() print(df) session.close()

Debug

Known issues

gotchaDefault ODBC DSN not configured: The driver requires either a DSN or method='odbc' with system/user/pass. Using method='odbc' without a DSN is common but misconfigured if no Teradata ODBC driver is installed.

fix

Install Teradata ODBC driver (Windows) or use method='rest' with REST endpoints (if available).

affects: all

deprecatedLibrary in maintenance: Teradata recommends using `teradatasql` for new projects. `teradata` (PyTd) is no longer actively developed.

fix

Migrate to `pip install teradatasql` and update connection syntax.

affects: >=15.0

gotchaConnection leaks: `execute()` returns a result set that must be closed or fetched entirely; otherwise, subsequent queries may hang.

fix

Always iterate or call `.fetchall()` and ensure result set is consumed or closed.

affects: all

Errors

Common errors & fixes

Error: ('HY000', '[HY000] [Teradata][ODBC Teradata Driver] Not enough memory')

Result set too large for ODBC driver buffer; default fetch size is unlimited.

fix

Use `session.execute(query, fetch_size=1000)` to limit fetch size.

teradata.api.DatabaseError: (3707, '[Teradata Database] [3932] The user is not a privileged user.')

User lacks required privileges (e.g., creating tables, macros).

fix

Grant necessary permissions via Teradata DBA.

AttributeError: module 'teradata' has no attribute 'UdaExec'

Incorrect import; user tried `from teradata import UdaExec`.

fix

Use `import teradata` and reference `teradata.UdaExec`.

Upgrade

Version history

15.10.0.21latest on PyPI · released Apr 29, 2017

Audit

Dependencies

No dependency data recorded yet.

Agent activity

19 hits · last 30 days

node

OpenAI (training)

Resources

githubhttp://github.com/teradata/PyTd ↗

packagehttps://pypi.org/project/teradata/ ↗

homepagehttps://teradata.com ↗