SnowFlake

​

Prerequisites

• Account
• User
• Password
• Database Name
• Role
• Warehouse
• Http Proxy

1. To get the Account information, follow these steps:
   • Log in to your Snowflake account. If you are logging in for the first time, use the email you have received from Snowflake.
   • At the bottom left, click on your generated account name next to the Snowflake icon.
   • Copy the Account name shown and store them in a safe place.
2. To get the User and Password information, follow these steps:
   • User and Password fields are your Snowflake account’s login credentials.
3. To get the Database Name information, follow these steps:
   • This is the name of your database before creation. If you haven’t created a database yet, you will need to do so.
4. To get the Role information, follow these steps:
   • Navigate to Admin > Users & Roles in the left-hand menu.
   • Select the Roles tab, and your roles will be displayed. Copy the necessary role.
5. To get the Warehouse information, follow these steps:
   • Navigate to Admin > Warehouses in the left-hand menu.
   • Your warehouses will be shown. Copy the required warehouse.
6. To get the Http Proxy information, follow these steps:
   • If you need to set up an HTTP Proxy, refer to the following articles:
     • AWS
     • Google Cloud

​

Connecting SnowFlake to Upsolve

1. Navigate to the data model page in Upsolve.
2. In the side menu bar, click the “New Data Source” button to initiate the connection process.
3. In the modal that appears, select “SnowFlake” as your data source.
4. Enter a name for your data source name and paste values that you before.

5. Click “Next” to create your SnowFlake data source.