SFTP to Data Warehouse Pipeline with Skippr

Replace manual SFTP downloads with a scheduled pipeline. Skippr pulls files from your server, infers structure, and loads cleansed data into the warehouse your team already queries.

Capabilities

• File-based ingestion over SFTP with key or password authentication
• Deterministic schema discovery from CSV, JSON, and similar file drops
• Incremental and full-refresh sync modes
• Automatic data cleansing and dead letter handling
• Load into 9 supported data warehouses

CLI

skippr connect source sftp \
  --host sftp.example.com \
  --username myuser \
  --private-key-path ~/.ssh/id_rsa \
  --remote-path /data/exports/

Sample config

data_sources:
  source:
    Sftp:
      host: sftp.example.com
      username: myuser
      private_key_path: "~/.ssh/id_rsa"
      remote_path: "/data/exports/"

Full connector reference: sftp.