SFTP (Destination)

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy

Uploads Parquet files to a remote SFTP server.

Configuration

warehouse:
  kind: sftp
  host: sftp.example.com
  username: user
  password: ${SFTP_PASSWORD}
  remote_path: "/data/output"

Field	Default	Description
host	(required)	SFTP server hostname
port	22	SSH port
username	(required)	SSH username
password		Password authentication
private_key_path		Path to SSH private key
remote_path	(required)	Remote directory for uploads

Authentication

Use either a password or an SSH private key. Prefer private-key auth for long-lived pipelines. For security best practices, we strongly advise against storing the password in skippr.yaml. Use environment variable interpolation instead: replace the password value with your own ${ENV_VAR} reference.

The relevant part of skippr.yaml looks like this:

warehouse:
  kind: sftp
  password: ${SFTP_PASSWORD}

Set the env var before running skippr:

macOS / Linux

export SFTP_PASSWORD="secret"

Windows PowerShell

$env:SFTP_PASSWORD = "secret"

Windows Command Prompt

set SFTP_PASSWORD=secret

Permissions or Network Requirements

The SSH user needs write access to the configured remote path, and the runner must be able to reach the SFTP host on the configured port.

Troubleshooting

Symptom	Fix
authentication failed	Verify the username, password or private key path, and any host-based access controls.
uploads fail	Check remote_path, available disk space, and whether the SSH user can create files in that directory.

Next steps

• Pair this destination with a source from Source Connectors.
• See Quick Start for the recommended warehouse evaluation paths.

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy