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.