Dataphin计算任务如何通过Python操作ODPS_SQL

#!/usr/bin/env python
# -*- coding: utf-8 -*-
################################################
import pandas as pd
from odps import ODPS
o=ODPS('access_id_XXX', 'access_key_XXX', 'project_name_XXX',
endpoint='http://service.odps.aliyun.com/api')
o.execute_sql('''
drop TABLE if exists luyao_online_proj.s_store_zr11;
CREATE TABLE IF NOT EXISTS luyao_online_proj.s_store_zr11
(
s_store_sk STRING ,
s_store_id STRING ,
s_rec_start_date STRING ,
s_rec_end_date STRING
)
PARTITIONED BY (
`ds` STRING
);
''',hints={"odps.sql.submit.mode":"script"})

#!/usr/bin/env python
# -*- coding: utf-8 -*-
################################################
import pandas as pd
from odps import ODPS
o=ODPS('access_id_XXX', 'access_key_XXX', 'project_name_XXX',
endpoint='http://service.odps.aliyun.com/api')
o.execute_sql('''
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10001,'c0001','20200618','20200619');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10002,'c0002','20200519','20200520');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10003,'c0003','20200520','20200521');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10004,'c0004','20200519','20200520');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10005,'c0005','20200517','20200518');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10005,'c0005','20200515','20200520');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10007,'c0007','20200515','20200519');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10008,'c0008','20200514','20200518');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(10009,'c0009','20200515','20200517');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(100010,'c00010','20200513','20200516');
insert into table luyao_online_proj.s_store_zr11 partition (ds ='20221024') values(100011,'c00011','20200519','20200516');
''',hints={"odps.sql.submit.mode":"script"})