Connection
Configuration
NAME | TYPE | DESCRIPTION | REQUIRED | READONLY |
---|---|---|---|---|
ssh_user | string | false | false | |
ssh_host | string | false | false | |
ssh_port | integer | false | false | |
ssh_private_key | string | false | false | |
path | string | The path to the directory on the SFTP server containing the files. | false | false |
skip_lines | integer | Skip first N lines of each CSV file. | false | false |
is_single_table | boolean | Treat the files as a single table. | false | false |
single_table_name | string | false | false |
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 }