Move SFTP Bulk data anywhere it matters.

Sync SFTP Bulk data to any warehouse or AI app.

Sync SFTP Bulk free Read the docs

Source

SFTP Bulk

Snowflake
BigQuery
Postgres
Databricks
Claude

Destinations: 50+
Standard support: 1.9.3

Overview

What is the Airbyte SFTP Bulk connector?

The Airbyte SFTP Bulk connector extracts data from SFTP Bulk and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes tables and events you can select per connection.

01
Sync to your warehouse
Land SFTP Bulk data in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
File transfer
Move files through the pipeline as-is, without parsing them into records first.
04
One authorization
Authenticate SFTP Bulk once and Airbyte keeps every scheduled sync running on it.

Setup

Live in nine steps

Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
Click on the "Create Connection" button and select the "SFTP Bulk" source connector.
Enter a name for the connection and click on the "Next" button.
In the "Connection Configuration" section, enter the following information: - Host: the hostname or IP address of the SFTP server - Port: the port number used for SFTP (usually
Username: the username used to access the SFTP server - Password: the password associated with the username - Private Key: (optional) the private key used for authentication - Passphrase: (optional) the passphrase associated with the private key - Path: the path to the directory containing the files to be synced
Click on the "Test" button to ensure that the connection is successful.
If the test is successful, click on the "Create Connection" button to save the connection.
Once the connection is created, you can configure the sync settings by selecting the desired sync mode (full refresh or incremental) and setting the sync schedule.
Finally, click on the "Create" button to start the sync process.

Configuration fields

SFTP Bulk configuration fields
Field	Type	Description
credentials*	object	Credentials for connecting to the SFTP Server
host*	string	The server host address
streams*	array	Each instance of this configuration defines a stream. Use this to define which files belong in the stream, their format, and how they should be parsed and validated. When sending data to warehouse destination such as Snowflake or BigQuery, each stream is a separate table.
username*	string	The server user
delivery_method	object	Not documented.
folder_path	string	The directory to search files for sync
port	integer	The server port
start_date	string	UTC date and time in the format 2017-01-25T00:00:00.000000Z. Any file modified before this date will not be replicated.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

SFTP Bulk connector questions

What data can I sync from SFTP Bulk with Airbyte?

The SFTP Bulk connector syncs the tables and events published in Airbyte docs.

Does the SFTP Bulk connector support incremental sync?

Yes. The SFTP Bulk connector supports incremental sync on selected streams, and full refresh on every stream.

Where can I run the SFTP Bulk connector?

Run the SFTP Bulk connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales