Estuary

Move your data from SFTP with your free account

Capture data from SFTP and deliver it to your destinations using Estuary's pre-built connectors. Build pipelines for real-time, incremental, or batch data movement based on connector capabilities.

  • <100ms to batch
  • 200+ connectors
  • Managed data pipelines
01. Move from SFTP02. Transform in-flight03. Select a destination
SFTP logo
take a tour
SFTP logo

SFTP connector details

The SFTP capture connector in Estuary captures files from an SFTP server and loads their contents into Estuary collections. It can continuously discover and ingest newly added files from a configured directory and its subdirectories, making it useful for automated file-based data pipelines.

  • Incremental file capture based on file modification time
  • Recursive capture from subdirectories within the configured SFTP directory
  • File filtering with regular expressions to capture only matching files
  • Supports Avro, CSV, JSON, Protobuf, and W3C Extended Log formats
  • Supports ZIP, GZIP, and ZSTD compression, with automatic compression detection
  • Automatic file format and schema detection for most captures
  • Multiple directory bindings within a single capture task
  • Password or SSH key authentication
  • Optional Ascending Keys mode for environments where files are written in strict lexicographical path order

By default, Estuary captures existing files and then incrementally captures newly added files according to their modification timestamps. If a file’s modification time changes, it may be captured again. For controlled file-naming schemes, Ascending Keys mode can instead process newly added files based on lexicographical path ordering.

For more details about the SFTP connector, check out the documentation page.

How to connect SFTP to your destination in 3 easy steps

  1. 1

    Connect SFTP as your data source

    Securely connect SFTP and choose the objects, tables, or collections you need to sync.

  2. 2

    Prepare and transform your data

    Apply transformations and schema mapping as data moves whether you are streaming in real time or loading in batches.

  3. 3

    Deliver to your destination

    Continuously or periodically deliver your data to the destination you choose, based on the capabilities and configuration of your pipeline.

Get Started Free

Trusted by data teams worldwide

All data connections are fully encrypted in transit and at rest. Estuary also supports private cloud and BYOC deployments for maximum security and compliance.

HIGH THROUGHPUT

Distributed, event-driven architecture scales for demanding data workloads.

DURABLE COLLECTIONS

Store data as it moves so you can transform, replay, and deliver it downstream.

FLEXIBLE LATENCY

From <100ms CDC and real-time streaming to scheduled batch, depending on connector capabilities.

From <100ms to batch

Estuary supports CDC, real-time streaming, incremental syncs, and scheduled batch across its connector ecosystem. Capture data from SFTP using the cadence supported by the connector, then transform and deliver it to the destinations your team uses.

  • Connect SFTP to warehouses, databases, data lakes, search platforms, and event systems through Estuary-supported destinations.
  • Capture once and reuse SFTP data across transformations and multiple downstream destinations without rebuilding source extraction.

See where you can send SFTP data:

Details

or choose from these popular destinations:

PostgreSQL logo
PostgreSQL
MySQL logo
MySQL
SQL Server logo
SQL Server
MongoDB logo
MongoDB
Apache Kafka logo
Apache Kafka
Google Bigquery logo
Google Bigquery
Snowflake logo
Snowflake

Don't see a connector?Request and our team will get back to you in 24 hours

Pipelines as fast as Kafka, easy as managed ELT/ETL, cheaper than building it.

Feature Comparison

EstuaryBatch ELT/ETLDIY PythonKafka
Price$$$-$$$$$-$$$$$-$$$$
Latency<100ms to scheduled5min+Varies<100ms
EaseAnalysts can manageAnalysts can manageData EngineerSenior Data Engineer
Scale
Maintenance EffortLowMediumHighHigh

One platform for real-time and batch data pipelines

Detailed Comparison

Deliver real-time and batch data from DBs, SaaS, APIs, and more

Connection-1

Popular sources/destinations you can sync your data with

Choose from more than 100 supported databases and SaaS applications. Click any source/destination below to open the integration guide and learn how to sync your data in real time or batches.