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

Feature Score: 20/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Resources

Official Documentation

SQLAlchemy Dialect Documentation

Help improve this documentation by editing the engine spec:

Edit odps.py