Snowflake OAuth authentication

Team Edition supports multiple authentication methods for Snowflake: username/password, private key, OAuth, and SSO.

Username/password¶

From the Authentication dropdown, select Snowflake username/password.
Enter your Snowflake username and password in the User name and User password fields.
Optionally, enter the Snowflake role you want to use in the Role field.
Click Test to verify the connection.

From the Authentication dropdown, select Private key.
Enter your Snowflake username in the User name field, then click Upload file to select your private key file (.p8 or .pem).

Info
To generate a key pair for Snowflake, see the Snowflake key pair authentication guide.
If your private key is encrypted, enter the passphrase in the Passphrase field.
Optionally, enter the Snowflake role you want to use in the Role field.
Click Test to verify the connection.

Info

To set up an OAuth integration in Snowflake, see the Snowflake OAuth documentation.

From the Authentication dropdown, select Snowflake OAuth.
Enter the Client ID of your Snowflake OAuth integration.
Optionally, enter the Client Secret for a more secure connection.
Enter the authorization and token endpoint URLs in the OAuth Authentication URL and OAuth Token URL fields.
Optionally, enter any required scopes in the OAuth Scopes field.

Info
For information on OAuth scopes, see OAuth scopes.
Click Test to verify the connection.
In the Open External Link dialog, click Open Link.
Sign in to your Azure account and allow access if prompted.
After authentication is complete, return to Team Edition.

Note

SSO authentication is deprecated. Consider switching to Snowflake OAuth for a more secure and supported option.

From the Authentication dropdown, select SSO (Deprecated).
Enter the identity provider ID configured in Snowflake in the Identity Provider ID field.
Optionally, enter the Snowflake role you want to use in the Role field.
Click Test to verify the connection.