Connector SFTP

Secure File Transfer Protocol (SFTP) is a network protocol that enables secure and encrypted file transfer between a client and a server, providing a secure method for exchanging data over an untrusted network. SFTP ensures data integrity and confidentiality by encrypting both commands and data during transmission. In the context of exporting data from SFTP to a Customer Data Platform, SFTP serves as a reliable connector for securely transmitting diverse datasets.

Data In/ Data Out Out

Data In	N/A
Data Out	All the data is saved in CSV format in `/data/out/files/` folder.

Learn more: about folder structure in configurations, please go to this article.

Parameters

Host (required)	Name of the server that hosts the database.
Port (required)	Port number.
Username (required)	Account username.
Password (required)	Account password.
Search Key (required)	Search the key prefix for the files in the database, it can optionally be used with a * wildcard at the end. For example, if you want to connect only the files from a particular folder myfolder in the bucket, you should ~~input~~ input `myfolder/*`. All files downloaded with a wildcard are stored in `/data/out/files/wildcard`.
Include sub-folders (optional)	Download data from the bucket with all subfolders. Available only with the wildcard * in the Search Key.
New files only (optional)	Check if you want to only download new files.
Limit (optional)	The maximum number of files to download. If the key matches more files, the oldest files will be downloaded.