Snowflake Connection Help

RazorSQL can connect to Snowflake via the Snowflake JDBC driver. Clicking the Auto-Download button when adding a Snowflake connection in RazorSQL will automatically download the driver. After the driver is downloaded, enter the information below to make a connection.

Profile Name: This is the name of the connection in RazorSQL. This name will be displayed in the connection name list.

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.



Account Identifier:: Usually this is the Organization Name followed by a dash followed by the Account Name. For example, QHVVTTT-ZH72777

If using a private link, usually .privatelink is appended to the Account Identifier.

Connection Properties: If you would like to configure custom properties for the connection, click the button here. These include default schema, default database, default warehouse, security role, etc.