Connect Python to Snowflake (with password and external authentication)

[@gilissantos6532]

I'm having connection problems, but this video is solving them, thank you very much!

[@qwerty-ux7ox]

Thanks a lot for this. It was exactly what I am looking for, u helped me solve it very easily.

[@dotpi5907]

That's really great to hear thanks @qwerty-ux7ox

[@o.chatri]

Thanks a lot for this ! It's working for me.

[@marcinpawlak5877]

Can you help me ? I want to connect to snowflake but i can only use azure to login on. Can you know how use azure in python ?

[@dotpi5907]

Hi Marcin,
This should work if you make sure you're logged into your Azure account. Then in your Python script set authenticator = 'externalbrowser'. There is an example (second one down) on the dotpi website dot-pi.com/connect-python-to-snowflake/
Hope that helps!

[@marcinpawlak5877]

@@dotpi5907 thx! work ! :D

[@subhamchakraborty6822]

Hi, how to download that data and store it in excel or csv? Thanks in advance.

[@maheshsharma-zq2uc]

Can you please guide me , how can connect snowflake with python if SSO integration required

[@pshyra1976]

I am trying connect to snowflake using spyder (Anaconda)
and have Error -"Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can't see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again..."
maybe you know the solution to this problem?

[@dotpi5907]

Hi Alex, thanks for the question. Do you have Google Chome set as your default browser? Ive had some problems trying to get the browser window to open with other browsers.

[@pshyra1976]

yes. Chrome default

[@jeevithachouta8812]

how do i connect through proxy, any help is appreciated

[@kycdoe]

The fonts are too small but thanks for the video

[@dotpi5907]

Thanks for the feedback

[@MC-8]

agree, I can't see so I can't follow sadly