Python连接Snowflake数据库

Python连接Snowflake数据库import snowflake.connectorprint("Connecting...")con = snowflake.connector.connect(user='账号',password='密码',account = '账户',warehouse = '仓库',database = '数据库',schema = '模式')cs = con.cu

梦想不断超越

1745人浏览 · 2022-02-17 14:40:36

梦想不断超越 · 2022-02-17 14:40:36 发布

Python连接Snowflake数据库

import snowflake.connector
print("Connecting...")
con = snowflake.connector.connect(
    user='账号',
    password='密码',
    account = '账户',
    warehouse = '仓库',
    database = '数据库',
    schema = '模式'
    )

cs = con.cursor()
try:
    cs.execute("SELECT current_version()")
    one_row = cs.fetchone()
    print(one_row[0])
finally:
    cs.close()
con.close()