---
id: apache-airflow-providers-teradata
version: "3.6.2"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# apache-airflow-providers-teradata — Provider package apache-airflow-providers-teradata for Apache Airflow

License: permissive · Maintenance: active · Downloads: 471.9K/mo

## What it is and what it does

This is an Apache Airflow provider package that adds Teradata database support to Airflow workflows. It supplies operators, hooks, and connection types that allow you to build data pipelines that query, load, or manage data in Teradata systems as part of your DAG tasks. The package wraps teradatasql and teradatasqlalchemy drivers and integrates with Airflow's common SQL provider framework.

You install it alongside an existing Airflow deployment (>=2.11.0) and configure Teradata connections through Airflow's UI or environment. Once configured, you can use Teradata operators in your DAGs to execute SQL, manage data movement, or orchestrate Teradata-dependent workflows. It supports Python 3.10 through 3.14 and is actively maintained by the Apache Airflow project.

Use it for:

- Schedule and monitor recurring SQL queries or stored procedures against Teradata as part of a larger data pipeline.
- Load data from external sources into Teradata tables on a scheduled basis using Airflow task orchestration.
- Build multi-step ETL workflows where Teradata is one of several data sources or destinations.
- Trigger Teradata operations conditionally based on upstream task results or external events in an Airflow DAG.
- Integrate Teradata data operations with cloud storage (AWS S3, Azure Blob) using optional cross-provider dependencies.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Integrates Apache Airflow with Teradata databases, providing operators, hooks, and connection management for building data pipelines that interact with Teradata.

Yes. Install this if you are running Apache Airflow and need to orchestrate Teradata database operations. The package is actively maintained, has no known vulnerabilities, carries a permissive Apache-2.0 license, and integrates cleanly with Airflow's provider ecosystem. Verify that your Airflow version meets the >=2.11.0 requirement and that you have Teradata JDBC drivers available in your environment.

## Install

pip install apache-airflow-providers-teradata
uv add apache-airflow-providers-teradata
poetry add apache-airflow-providers-teradata

## Installing apache-airflow-providers-teradata

Before you install: Low friction installation as a pure-Python wheel. Active maintenance with a release 6 days old. Depends on apache-airflow (>=2.11.0) and Teradata-specific drivers (teradatasql, teradatasqlalchemy); ensure your Airflow environment meets the minimum version.

License in practice: Apache-2.0 permissive license allows commercial and private use with minimal restrictions; suitable for most enterprise and open-source projects.

Quickstart:

pip install apache-airflow-providers-teradata

from airflow.providers.teradata.operators.teradata import TeradataOperator
from airflow import DAG

with DAG('my_teradata_dag') as dag:
    task = TeradataOperator(
        task_id='query_teradata',
        sql='SELECT * FROM my_table',
        teradata_conn_id='teradata_default'
    )

Requires apache-airflow >=2.11.0 and Python >=3.10; Teradata JDBC drivers (teradatasql >=17.20.0.28, teradatasqlalchemy >=17.20.0.0) must be installed and a Teradata connection configured in Airflow.

Verify before relying:

- Whether the package includes specific operators beyond generic SQL execution (e.g., bulk load, export utilities).
- Performance characteristics and connection pooling behavior under high-volume DAG execution.
- Support for Teradata-specific authentication methods beyond standard SQL connection strings.

## Package facts

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 471.9K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

airflow teradata integration, teradata operator airflow, airflow teradata connection, teradata sql airflow, airflow teradata provider, teradata dag tasks, airflow database provider, airflow-provider, teradata-integration, data-orchestration

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