ODPS (MaxCompute)

https://www.alibabacloud.com/product/maxcompute

Alibaba Cloud MaxCompute (formerly ODPS) is a fully managed, multi-tenancy cloud data warehousing platform for large-scale batch and streaming analytics.

Installation

Required packages: pyodps

Connection String

odps://{access_id}:{secret_access_key}@{project}/?endpoint={endpoint}

Parameter	Description
access_id	Aliyun Access Key ID
secret_access_key	Aliyun Access Key Secret
project	MaxCompute project name
endpoint	MaxCompute service endpoint URL

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Aggregate Functions

The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.

MEDIANSTDDEV_SAMPVAR_SAMP

Resources

Official Documentation

SQLAlchemy Dialect Documentation

Help improve this documentation by editing the engine spec:

Edit odps.py