SFTP

Supports:

  • ✅ Bulk sync source

Connection

Configuration

NameTypeDescriptionRequired
ssh_userstringUserfalse
ssh_hoststringHostfalse
ssh_portintegerPortfalse
auth_modestringAuthentication Method

Accepted values: private_key, password
true
ssh_private_keystringPrivate key

(required if auth_mode is “private_key”)
false
ssh_passwordstringPassword

(required if auth_mode is “password”)
false
pathstringPath

The path to the directory on the SFTP server containing the files.
false
skip_linesintegerSkip first lines

Skip first N lines of each CSV file.
false
is_single_tablebooleanFiles are time-based snapshots

Treat the files as a single table.
false
single_table_namestringCollection namefalse

Example

1{
2 "name": "SFTP connection",
3 "type": "sftp",
4 "configuration": {
5 "auth_mode": "private_key",
6 "is_single_table": false,
7 "path": "/path/to/files",
8 "single_table_name": "",
9 "skip_lines": 0,
10 "ssh_host": "sftp.example.net",
11 "ssh_password": "",
12 "ssh_port": 22,
13 "ssh_private_key": "",
14 "ssh_user": "user"
15 }
16}