SFTP JSON
Overview
This destination writes your data to a directory on an SFTP server.
Sync overview
Output schema
Each stream is written to a separate file.
Each file contains json objects that correspond directly to the data supplied by the source.
Performance considerations
Performance depends on your SFTP connection speed and how quickly the server accepts writes.
Supported sync modes
| Sync mode | Supported? |
|---|---|
| Full Refresh - Overwrite | Yes |
| Full Refresh - Append | Yes |
| Full Refresh - Overwrite + Deduped | No |
| Incremental Sync - Append | Yes |
| Incremental Sync - Append + Deduped | No |
Getting started
The destination_path can refer to any path where the associated account has write permission.
In the configuration, the filename should not have an extension because the connector adds .jsonl.
Example
Set destination_path to /myfolder/files and filename to mydata. The resulting file will be /myfolder/files/mydata.jsonl.
You can access these files by connecting to the server through SFTP and navigating to the destination_path.
Namespace support
This destination doesn’t support namespaces.
Changelog
Expand to review
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 0.2.16 | 2026-05-15 | 78111 | Fixed SFTP connection checks for passwords with URI-reserved characters. |
| 0.2.15 | 2025-05-27 | 60870 | Update dependencies |
| 0.2.14 | 2025-05-10 | 59809 | Update dependencies |
| 0.2.13 | 2025-05-03 | 59353 | Update dependencies |
| 0.2.12 | 2025-04-26 | 58727 | Update dependencies |
| 0.2.11 | 2025-04-19 | 58238 | Update dependencies |
| 0.2.10 | 2025-04-12 | 57592 | Update dependencies |
| 0.2.9 | 2025-04-05 | 57114 | Update dependencies |
| 0.2.8 | 2025-03-29 | 56615 | Update dependencies |
| 0.2.7 | 2025-03-22 | 56090 | Update dependencies |
| 0.2.6 | 2025-03-08 | 55369 | Update dependencies |
| 0.2.5 | 2025-03-01 | 54868 | Update dependencies |
| 0.2.4 | 2025-02-22 | 54265 | Update dependencies |
| 0.2.3 | 2025-02-15 | 53941 | Update dependencies |
| 0.2.2 | 2025-02-08 | 53405 | Update dependencies |
| 0.2.1 | 2025-02-01 | 52883 | Update dependencies |
| 0.2.0 | 2024-10-14 | 46873 | Migrated to Poetry and Airbyte Base Image |
| 0.1.0 | 2022-11-24 | 4924 | 🎉 New Destination: SFTP JSON |