Snowflake connection

This article provides a guide on how to create a Snowflake connection in Upsolver.

Create a Snowflake connection

1. Enter the connection string in the following format: jdbc:snowflake://ACCOUNT_WITH_REGION.snowflakecomputing.com?db=DB_NAME where:

• ACCOUNT_WITH_REGION.snowflakecomputing.com = connection url in Snowflake

• DB_NAME = name of database

See: Snowflake JDBC Driver connection string

2. Enter your Snowflake username.

3. Select the Authentication type:

• For User-Password Authentication, enter the corresponding password.

• For Key Pair Authentication:

  • Upload the private key to Upsolver's server. Use the resulting file path on the server as the Private Key File parameter for the connection setup. For detailed instructions on uploading the key, refer to this guide.

  • (Optional) Specify the Private Key File Password required to decrypt the private key file if it is encrypted. This parameter must be used alongside Private Key File.

4. Name this connection.

5. (Optional) Enter in the number of concurrent connections.

6. Click Create.