问Snowflake与Sharepoint集成

EN

##Getting Imports
from snowflake.sqlalchemy import URL
from shareplum import Office365
from shareplum import Site
from shareplum.site import Version
import pandas as pd
import json
import snowflake.connector


##Connecting to snowflake
con_var = snowflake.connector.connect(
   user = 'your_username',
   password = 'your_password',
   account = 'account_name',
   warehouse = 'snowflake_warehouse',
   database = 'database_name',
   schema = 'schema_type'
)

## Connecting to sharepoint
server_url = "https://yourlink.sharepoint.com/"
site_url = server_url + "sites/your_site_name"
Username = "sp_userid"
Password = "sp_password"

sql_stmt = """ select * from "DB".table_name """

##Writing query result to sharepoint
authcookie = Office365(server_url, username = Username, password=Password).GetCookies()
site = Site(site_url, version=Version.v365, authcookie=authcookie)
folder = site.Folder('Shared Documents/Your_Folder')

df = pd.read_sql(sql_stmt,con_var)
folder.upload_file(df.to_json(orient='records'),'out_file.json')