.execute("copy into tmp_cdp_score_feature from @cdp_json_acpt/data/1 file_format = (type=json)"
as the last value will be varying from 1 to 100 like data/2, data/3, so I  need to pass as variable .
something like 
.execute("copy into tmp_cdp_score_feature from @cdp_json_acpt/data/(%s) file_format = (type=json),(2)"
copy into tmp_stg from @stg_json_acpt/"'%s'" file_format = (type=json), Force=True" %(des1)
des1= path of the s3 object file
It works fine, tested
How to pass the bind variable to the copy into statement in snowflake from python