---
id: pyodps
version: "0.13.1"
license: Apache License 2.0
license_treatment: permissive
maintenance: active
---

# pyodps — ODPS Python SDK and data analysis framework

License: permissive · Maintenance: active · Downloads: 5.8M/mo

## What it is and what it does

pyodps is a Python SDK for Aliyun's ODPS (Open Data Processing Service), a cloud-based distributed data warehouse. It provides programmatic access to ODPS clusters, allowing you to query tables, execute SQL, retrieve schemas, and manage data processing jobs directly from Python code. The package wraps the ODPS REST API and handles authentication, serialization, and result marshaling through its runtime dependencies requests and pyarrow.

The SDK is designed for data engineers and analysts working with Aliyun's cloud infrastructure. It includes support for IPython/Jupyter integration via magic commands, a Python UDF debugging tool for custom functions, and both synchronous and asynchronous execution modes. The package supports Python versions from 3.7 onward and is actively maintained.

Use it for:

- Query and retrieve data from ODPS tables programmatically within Python data analysis workflows.
- Execute SQL statements against ODPS clusters and process results in Python data structures.
- Develop and debug Python UDFs (User Defined Functions) for use in ODPS SQL queries.
- Automate ETL pipelines that read from or write to Aliyun ODPS data warehouses.
- Integrate ODPS data access into Jupyter notebooks using IPython magic commands for interactive exploration.

## Worth the install?

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

pyodps is a Python SDK for accessing Aliyun ODPS clusters, providing APIs to query tables, execute SQL, and manage data processing jobs through a REST interface.

Yes, if you work with Aliyun ODPS. The package is actively maintained, has no known vulnerabilities, supports modern Python versions, and carries a permissive Apache License 2.0. Install friction is moderate due to compiled wheels, but pre-built binaries are available for common platforms. Not relevant for non-Aliyun cloud environments.

## Install

pip install pyodps
uv add pyodps
poetry add pyodps

## Installing pyodps

Before you install: Medium install friction due to compiled wheels for multiple Python versions and architectures. Active maintenance with a recent release (2026-08-14) and ongoing repository activity; supports Python 3.7 through 3.14, including PyPy.

License in practice: Licensed under Apache License 2.0 (permissive), allowing free use, modification, and distribution with minimal restrictions—suitable for both open-source and commercial projects.

Quickstart:

pip install pyodps

import os
from pyodps import ODPS

o = ODPS(
    os.getenv('CLOUD_ACCESS_KEY_ID'),
    os.getenv('CLOUD_ACCESS_KEY_SECRET'),
    project='your-project',
    endpoint='your-endpoint'
)
table = o.get_table('dual')
print(table.name)

Requires CLOUD_ACCESS_KEY_ID and CLOUD_ACCESS_KEY_SECRET environment variables set with valid Aliyun credentials; access to an ODPS endpoint is also required.

Verify before relying:

- Whether pyarrow is required for all workflows or only for specific data operations.
- Performance characteristics and scalability limits for large table operations.
- Compatibility details with different ODPS service versions or regions.

## Package facts

- License: Apache License 2.0 (permissive)
- Python support: supports_current
- Install friction: medium
- Maintenance: active
- Downloads: 5.8M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

aliyun odps python client, odps data processing sdk, aliyun data warehouse python, odps table query api, distributed data processing python, odps sql execution, aliyun cloud data sdk, aliyun-cloud, data-warehouse, distributed-computing

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