Connection

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
ssh_userstringfalsefalse
ssh_hoststringfalsefalse
ssh_portintegerfalsefalse
ssh_private_keystringfalsefalse
pathstringThe path to the directory on the SFTP server containing the files.falsefalse
skip_linesintegerSkip first N lines of each CSV file.falsefalse
is_single_tablebooleanTreat the files as a single table.falsefalse
single_table_namestringfalsefalse

Example

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