snowflake Connection error in python " snowflake.connector.errors.ProgrammingError: 251005: User is empty"

Question

I'm a newbie to snowflake and trying to connect to the db using python but when executing the code i get this error "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()

Gokhan Atil · Accepted Answer · 2020-04-13 11:38:07Z

5

You should use "user" parameter instead of "username". Here's sample:

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

Please check: https://docs.snowflake.com/en/user-guide/python-connector-example.html#setting-session-parameters

answered Apr 13, 2020 at 11:38

Gokhan Atil

10.6k2 gold badges13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

HungryOctopus · Accepted Answer · 2023-01-12 16:20:59Z

0

Also, it's case sensitive (I had the same error message with USER)

answered Jan 12, 2023 at 16:20

HungryOctopus

14 bronze badges

Collectives™ on Stack Overflow

snowflake Connection error in python " snowflake.connector.errors.ProgrammingError: 251005: User is empty"

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related