Alibaba MaxCompute

Create an Alibaba MaxCompute Datasource
1.Navigate to: Resources > Data Sources
2.Select the Alibaba MaxCompute Icon:
Data Source Inputs
Name (required)
Description (optional)
Endpoint (required): URL corresponding to the region MaxCompute is hosted
The corresponding values can be found here: Configure Endpoints in in Alibaba Cloud​
Region (required): Specific region for your MaxCompute project
Example: us-west-1
Project (required): Name of your MaxCompute project
Credential Type: See Data Source Security​
AccessKey ID (required - can be entered later): See Configure Authentication​
AccessKey Secret (required - can be entered later): See Configure Authentication ​
Use Alibaba Max Compute
Read
Python
SQL
1
%python
2
from odps.df import DataFrame
3
import pandas as pd
4
​
5
# Create a MaxCompute (ODPS) entrance object
6
o = z.getDatasource("zepl_docs_alibaba_maxcompute")
7
​
8
# Get table reference
9
table = o.get_table('sale_detail')
10
​
11
# Create ODPS DataFrame
12
odps_df = table.to_df()
13
​
14
# Convert to Pandas DataFrame
15
pandas_df = odps_df.to_pandas()
16
​
17
z.show(pandas_df)
Copied!
Use z.getDatasource()  to return MaxCompute entrance object: odps.core.ODPS​
1
%datasource.zepl_docs_alibaba_maxcompute
2
# Uncomment if full table scans are required for this query
3
# SET odps.sql.allow.fullscan=true;
4
​
5
SELECT * FROM sale_detail;
Copied!
If you are experiencing this error ODPS-0130071 , please reference the Common SQL Errors documentation. This often means that you will need to enable full table scans by setting this run time parameter (odps.sql.allow.fullscan) to true
Write
Python
1
%python
2
# Create a MaxCompute (ODPS) entrance object
3
o = z.getDatasource("zepl_docs_alibaba_maxcompute")
4
​
5
# Create data to write. Number of values per list must match the schema dtypes: o.get_table('sale_detail').schema
6
records = [["Samsung", 1234, 1000.00, "2020-01-01", "USA"], ["Apple", 9876, 5000.00, "2020-01-01", "USA"]]
7
​
8
# Write to table 'sale_detail', all records at a specific partition for sale_date and region
9
o.write_table('sale_detail', records, partition='sale_date="2020-01-01", region="USA', create_partition=True)
Copied!
​Open all examples in Zepl​
Configure Authentication
Generate User Access Key and Secret
1.Login to your Alibaba Cloud console
2.Navigate to Resource and Access Management (RAM)
3.Select User > Then you specific user
4.Select Create Access Key. 
5.Download this file and enter the corresponding values in the Zepl Data Source. If you lose this file, you will need to generate new Access Keys for this user.