authentication

[kpejman]

hi,

my company uses SSO to connect to SNOW.
when the authentication windows shows up, I tried all the authentication methods but it fails regardless of how I'm trying to authenticate. is there any way to Make this work ?

[aduguid]

I use a service account to access Service Now using a "Basic" data source connection type.

[kpejman]

thanks for the reply. that option is not working for me since it uses SSO to access. my personal account has access and SN uses SSO to login.

[Siddharth-Latthe-07]

To resolve the issue of connecting to Snowflake using SSO, especially when authentication windows fail, you can try the following steps and approaches:-

1. Verify SSO Configuration
   Ensure that the SSO configuration in your Snowflake account is set up correctly. This involves making sure that your Identity Provider (IdP) is properly configured and integrated with Snowflake.
2. Use Browser-Based SSO
   Sometimes, browser-based SSO can help in cases where direct SSO from the application fails.
   example snippet:-

import snowflake.connector

# Replace with your actual credentials and account information
user = 'your_user'
account = 'your_account'
authenticator = 'externalbrowser'  # For browser-based SSO

# Connect to Snowflake
ctx = snowflake.connector.connect(
    user=user,
    account=account,
    authenticator=authenticator
)

# Test the connection
cs = ctx.cursor()
try:
    cs.execute("SELECT CURRENT_VERSION()")
    one_row = cs.fetchone()
    print(one_row[0])
finally:
    cs.close()
ctx.close()

3. Check Network and Browser Settings and update the Snowflake Connector

Hope the above helps, do let me know, if it works or not
Thanks