SFTP Import

Import data from an FTP server.

Properties

NameType
engineString=sftp:read
connectionObject
pathString
decoderString
schemaObject

engine

Must be sftp:read.

Required
Yes

connection

The SFTP connection parameters.

Required
Yes

Properties

NameType
hostString
userString
passwordString

connection.host

The network address of the SFTP server e.g. `ftp.example.com:22`.

Required
Yes

connection.user

The username to authenticate to SFTP.

Required
Yes

connection.password

The password to authenticate to SFTP.

Required
Yes

path

The path from which to get the file.

Required
Yes

decoder

The format of the data. See Parsing Data for details.

Required
Yes
Enum
csv json ndjson msgpack protobuf parquet html xml regex

schema

Define a schema for the data.

Required
Yes