How can i connect snowflake with Oauth via python?

Question

I need to connect from google. Example from snowflake is

ctx = snowflake.connector.connect(
    user="<username>",
    host="<hostname>",
    account="<account_identifier>",
    authenticator="oauth",
    token="<oauth_access_token>",
    warehouse="test_warehouse",
    database="test_db",
    schema="test_schema")

but how can i get <oauth_access_token> value? Please help

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — henrycjc
– henrycjc, Commented Oct 22, 2021 at 6:19

Srinath Menon · Accepted Answer · 2021-10-22 05:27:59Z

5

You need to generate the OAuth Token based on the OAuth security that you have set up. Whether it is a Snowflake OAuth or External OAuth is entirely based on your technical and business requirement. Details for it are here: https://docs.snowflake.com/en/user-guide/oauth-intro.html

There are some great KB's as well which gives exact set of steps for setting it up:

https://community.snowflake.com/s/article/Create-External-OAuth-Token-Using-Azure-AD-For-The-OAuth-Client-Itself

https://community.snowflake.com/s/article/External-oAuth-Token-Generation-using-Azure-AD

https://community.snowflake.com/s/article/How-To-Create-External-Oauth-Token-Using-Okta-For-The-Client-Itself-Service-Flow

answered Oct 22, 2021 at 5:27

Srinath Menon

1,6909 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

How can i connect snowflake with Oauth via python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related