SFTP

Supports:

✅ Bulk sync source

Connection

Configuration

Name	Type	Description	Required
`auth_mode`	`string`	Authentication method Accepted values: `private_key` ↓, `password` ↓	`true`
`is_single_table`	`boolean`	Files are time-based snapshots Treat the files as a single table. ↓	`false`
`path`	`string`	Path The path to the directory on the SFTP server containing the files.	`false`
`skip_lines`	`integer`	Skip first lines Skip first N lines of each CSV file.	`false`
`ssh_host`	`string`	Host	`false`
`ssh_port`	`integer`	Port	`false`
`ssh_user`	`string`	User	`false`

`is_single_table`

When `is_single_table` is `true`

Name	Type	Description	Required
`single_table_name`	`string`	Collection name	`false`

`auth_mode`

When `auth_mode` is `password`

Name	Type	Description	Required
`ssh_password`	`string`	Password	`true`

When `auth_mode` is `private_key`

Name	Type	Description	Required
`ssh_private_key`	`string`	Private key	`true`

Example

{
  "name": "SFTP connection",
  "type": "sftp",
  "configuration": {
    "auth_mode": "private_key",
    "is_single_table": false,
    "path": "/path/to/files",
    "skip_lines": 0,
    "ssh_host": "sftp.example.net",
    "ssh_port": 22,
    "ssh_private_key": "",
    "ssh_user": "user"
  }
}

Bulk Sync

Source

SFTP connections may be used as a bulk sync source. No additional configuration options are required.

Connection

Configuration

is_single_table

When is_single_table is true

auth_mode

When auth_mode is password

When auth_mode is private_key

Example

Bulk Sync

Source

`is_single_table`

When `is_single_table` is `true`

`auth_mode`

When `auth_mode` is `password`

When `auth_mode` is `private_key`