SSH File Transfer Protocol (SFTP) link
Updated November 21, 2023
Fivetran supports syncing files from your SSH server to your destination using SFTP.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | check | All tables and fields |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step SFTP connector setup guide to start syncing files from your SSH server to your destination using SFTP.
Syncing empty columnslink
The SFTP connector doesn't support the creation of empty columns in your destination.
We create a column in the destination table only if the column in your source file is not empty.
Upsert with custom primary keys Betalink
For upserting with primary keys, use the Primary Key used for file process and load field.
You can select the custom primary keys during the connector setup and use them to update or insert new rows to the destination. We process the files in order of their modified time.
If we detect that one of the selected primary keys has a null
value in your files, we display a warning on the connector dashboard but insert the record with a null
value in your destination.
If the destination does not support null values, we insert the row with the default value for the column.
You can choose the primary keys only before the initial sync. Once you perform the initial sync, you won't be able to modify the primary keys.
NOTE: You can modify the primary keys if your initial sync fails. If your initial sync is successful, you won't have the option to modify the primary keys.
NOTE: If you want to use this feature, contact our support team.
Types of primary keyslink
The file connectors uses the following types of primary keys:
- Primary key - is a field that contains values that uniquely identifies each row in your data.
- Composite primary key - is a set of fields which, in combination, uniquely identifies a row in your data.
- Surrogate primary key - is a column or columns that the system adds to your data in order to provide a unique identifier for a row in your data.