Python连接Snowflake数据库

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()