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 | |
| Priority-first sync | ||
| Private networking | ||
| Fivetran data models |
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.