Connection

Description

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 }

Getting started

Configuring your connections

Code examples

SFTP

Connection

Description

Configuration

Example

Model Sync

Source

Target

Bulk Sync

Source

Destination

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	}