Search documentation...

K

SFTP

SFTP

Overview

Hightouch supports syncing data from CSV files stored on a remote server via SFTP.

Setup

You will need your hostname, port, credentials for a SFTP user. This user needs to have permission to read the file you would like to use as a source. A "permission denied" error message during a sync indicates the user may not have write permissions for both the directory and the file.

You'll need to allowlist Hightouch's IP addresses to allow our systems to contact your SFTP server. Reference our docs to determine which IPs you need to allowlist.

Supported Authentication Methods

We support three authentication methods:

  • Username + password
  • Username + SSH private key
  • Username + SSH private key + passphrase

We support two formats for the SSH private key:

  • OpenSSH
  • RSA

Provide the full private key for the user, including the header and footer.

For example:

-----BEGIN OPENSSH PRIVATE KEY-----
<private key body>
<private key body>
<private key body>
-----END OPENSSH PRIVATE KEY-----

Source file format

Currently Hightouch supports syncing data from a single CSV file that has a header row. The values in the header row will be automatically available as column names when you set up a sync.

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    Feature Requests?

    If you see something that's missing from our app, let us know and we'll work with you to build it!

    We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.

On this page

OverviewSetupSupported Authentication MethodsSource file format

Was this page helpful?