蟒蛇" snowflake.connector.errors.ProgrammingError: 251005: User is empty"中的雪花连接错误

Question

我是snowflake的新手，试图使用python连接到数据库，但在执行代码时，我得到了以下错误"snowflake.connector.errors.ProgrammingError:251005:User is empty">

import snowflake.connector
ctx = snowflake.connector.connect(
username = 'xxx',
password = 'xxxx',
account = 'xxxx'
)
cs = ctx.cursor()
try:
cs.execute(''' some query''')
one_row = cs.fetchone()
print(one_row[0])
finally:
cs.close()
ctx.close()

Answer 1

您应该使用"user"参数而不是"username"。这是样品：

con = snowflake.connector.connect(
user='XXXX',
password='XXXX',
account='XXXX'
)

请检查：https://docs.snowflake.com/en/user-guide/python-connector-example.html#setting-会话参数

Answer 2

此外，它区分大小写(我与USER有相同的错误消息(