# SFTP Routes

> To access the SFTP Routes feature - drop us a line at <support@vgs.io>

SFTP stands for Secure Shell (SSH) File Transfer Protocol, a network protocol used for secure transfer of data over the internet. The protocol supports the full security and authentication functionality of SSH, and is widely used to exchange data between business partners in a variety of industries including financial services, healthcare, retail, and advertising.

## Connection Configuration

To configure the upstream connection, start with creating the SFTP route. Go to the SFTP page, click **Add Route** and select **New SFTP Route** from the drop-down menu.

<figure><img src="/files/IOOXiKuWSEBO7poC4EPp" alt=""><figcaption></figcaption></figure>

Next, set up the upstream connection by clicking the **Add** button and filling in the form.

<figure><img src="/files/nKpG2YMtpwKxFb6EE75B" alt=""><figcaption></figcaption></figure>

* **Upstream Host** - Host of the upstream SFTP server
* **Port** - Port of the upstream SFTP server
* **Username** - Username to connect to upstream SFTP server
* **Password** - Password to connect to upstream SFTP server
* **Allow for the next credentials** - to connect to SFTP proxy server

After filling in a form and configuring filters, click **Save**. The new SFTP route will be created and a success alert message will show up.

## Connect to upstream

Run the following command:

```bash
sftp -P 8022 <USERNAME>@<VAULT_ID>.<ENVIRONMENT>.verygoodproxy.com
```

* **access-credentials-username** - Username from [Access credentials](/enterprise-platform/developer-resources/api-reference/useraccess.md)
* **vault-id** - [Vault Dashboard](https://dashboard.verygoodsecurity.com/)
* **environment** - [Environment](/vault/vaults.md#environments)

Next, enter the dashboard Access Credential password.

<figure><img src="/files/FvHeYGHw87GvVNpZEut1" alt=""><figcaption></figcaption></figure>

Congratulations! Now you are successfully connected to SFTP.

<figure><img src="/files/EMXytyAMBEydlCsGXIGu" alt=""><figcaption></figcaption></figure>

## Process CSV files

SFTP route editor supports redact/reveal of particular columns in .csv files. It also allows excluding the column header from processing.

For CSV redact/reveal:

* Select the CSV tab in the filter editor
* Add columns to be redacted/revealed in square braces separated by a comma. For example, to redact the first column and second column of a file add \[0,1]. The first column starts with a zero index.
* Uncheck CSV has headers? If it's not needed to process CSV headers
* Save the route.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.verygoodsecurity.com/vault/batch-file-transmission/sftp-proxy/sftp.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.