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 | ||
| 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.