SFTP | Polytomic Docs

Supports:

✅ Bulk sync source

Connection

Configuration

NAME	TYPE	DESCRIPTION	REQUIRED	READONLY
ssh_user	string		false	false
ssh_host	string		false	false
ssh_port	integer		false	false
auth_mode	string	Accepted values: `private_key`, `password`	true	false
ssh_private_key	string	(required if `auth_mode` is “private_key”)	false	false
ssh_password	string	(required if `auth_mode` is “password”)	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     "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 }