Advanced Analytica Advanced Analytica: IBOM
← All connectors
SFTP-JSON logo

Destination connector

SFTP-JSON

Send governed data into SFTP-JSON with a clear, practical setup guide.

Version 0.2.16 community alpha

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 modeSupported?
Full Refresh - OverwriteYes
Full Refresh - AppendYes
Full Refresh - Overwrite + DedupedNo
Incremental Sync - AppendYes
Incremental Sync - Append + DedupedNo

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
VersionDatePull RequestSubject
0.2.162026-05-1578111Fixed SFTP connection checks for passwords with URI-reserved characters.
0.2.152025-05-2760870Update dependencies
0.2.142025-05-1059809Update dependencies
0.2.132025-05-0359353Update dependencies
0.2.122025-04-2658727Update dependencies
0.2.112025-04-1958238Update dependencies
0.2.102025-04-1257592Update dependencies
0.2.92025-04-0557114Update dependencies
0.2.82025-03-2956615Update dependencies
0.2.72025-03-2256090Update dependencies
0.2.62025-03-0855369Update dependencies
0.2.52025-03-0154868Update dependencies
0.2.42025-02-2254265Update dependencies
0.2.32025-02-1553941Update dependencies
0.2.22025-02-0853405Update dependencies
0.2.12025-02-0152883Update dependencies
0.2.02024-10-1446873Migrated to Poetry and Airbyte Base Image
0.1.02022-11-244924🎉 New Destination: SFTP JSON
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.