Snowflake Authentication Types

Listed below are details about each of the Snowflake authentication types listed in the Authentication Type dropdown.

User / Password: Use this type if you authenticate to Snowflake with only a user and a password. If your organization has push notifications set up to approve the login attempt, you may be asked for approval for the login on another device. Enter your user name in the Login field and your password in the Password field.

User / Password + Authenticator Passcode: Use this option if you login to Snowflake with a user and password, and need to enter a code from an authenticator app in addition to the user and password. RazorSQL will display a pop-up window after the Connect button is pressed that will ask for the code from the Authenticator app. Enter your user name in the Login field and your password in the Password field.

Private Key File: If your user id is set up in Snowflake to be allowed to authenticate via a private key file, use this option. Browse to the location of the private key file on your machine. If your private key file is password protected, enter the private key file password in the Private Key File Password field. Enter your user name in the Login field.

External Browser SSO: If authentication is handled outside of Snowflake, such as via Microsoft Azure services or another single sign-on provider, select the External Browser SSO option. You will need to enter the user name in the Login field. After clicking connect, the Snowflake driver will open a web browser to handle the authentication if necessary.