> For the complete documentation index, see [llms.txt](https://learn.capstorm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.capstorm.com/reference/main-tab/snowflake-connection.md).

# Snowflake Connection

## Initial Steps

Before running CopyStorm for the first time, create a dedicated Snowflake database for your Salesforce data.

## Connection String

Compared to the other Database types, Snowflake’s connection string is more complex and carries more information. For this reason, it is recommended to use the Connection String Builder to create a valid Connection String.

![](https://4057376488-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsbSqfKw3vSfr8qwXao4j%2Fuploads%2Fgit-blob-f153d4eb5b2cdc1ca85dbaa5a583a75a84e548d5%2F48942243-snowflake-Connection-main.png?alt=media)

## Connection String Builder

After clicking on the “Connection String Builder” button, a dialog menu will open, as seen below.

![](https://4057376488-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsbSqfKw3vSfr8qwXao4j%2Fuploads%2Fgit-blob-25142c76b59c7ff6a18b1012ab2c067171cbd2ea%2Fa1c65906-snowflake-Connection-StringBuilder-1.png?alt=media)

| Parameter                 | Description                                                                                                                                                                                                           |
| ------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Server Name               | The IP Address, URL, or server name of the snowflake instance. Port number is optional.                                                                                                                               |
| Database Name             | The name of the Snowflake database that CopyStorm will populate with Salesforce data.                                                                                                                                 |
| Private Key File          | The file path to the Snowflake Private key. For more information on Private Keys and Snowflake’s key-pair authentication, refer to [Snowflake Documentation](https://docs.snowflake.com/en/user-guide/key-pair-auth). |
| Key File Password         | If your Private key was configured to require a password for use in authentication, enter it here. If your Snowflake Private key was configured as to not require a password, this field can be left blank.           |
| Warehouse (optional)      | The name of a Warehouse in Snowflake that you wish to use. For more information on Snowflake Warehouses, refer to [Snowflake Documentation](https://docs.snowflake.com/en/user-guide/warehouses-overview).            |
| Proxy Host (optional)     | The IP address, or URL of a proxy used to connect to a Snowflake instance.                                                                                                                                            |
| Proxy Port (optional)     | The port number associated with a proxy used to connect to a Snowflake instance.                                                                                                                                      |
| Proxy User (optional)     | The username to authenticate a request with a proxy used to connect to a Snowflake instance.                                                                                                                          |
| Proxy Password (optional) | The password used to authenticate a request to a proxy used to connect to a Snowflake instance                                                                                                                        |
| Proxy Protocol (optional) | The protocol by which a connection will be made to a proxy used to connect to a Snowflake instance. Select either HTTP, or HTTPS.                                                                                     |