|Table of Contents|
Basic knowledge of Treasure Data.
Before using this connector, determine valid protocols for your environment.
If you intend to SFTP, you can use this Data Connector for SFTP.
If FTP/FTPS, try connect with FTP Data Connector.
If you are using a firewall, check your accepted IP range/port. Server administrators sometimes change the default port number from TCP/22 for security reasons.Requires that your private key has an OpenSSH 7.8 format.
Requires that the OpenSSH format private key was generated using the '-m PEM' option.
- “PuTTY” and other formats are not supported.
The default format of the private key after OpenSSH.
After installation and configuration, review the job log. Warning and errors provide information about the success of your import. For example, you can identify the source file names associated with import errors.
The Source dialog opens.
Edit the following parameters
User directory root
Prefix of target files (string, required)
Path match pattern
Type a regular expression to query file paths. If a file path doesn’t match with the specified pattern, the file is skipped. For example, if you specify the pattern .csv$ # , then a file is skipped if its path doesn’t match the pattern.
Enables incremental loading (boolean, optional. default: true. If incremental loading is enabled, the config diff for the next execution will include last_path parameter so that the next execution skips files before the path. Otherwise, last_path is not included.
Start after path
Only paths lexicographically greater than this will be imported.
The Data Settings page opens.
Optionally, edit the data settings or skip this page of the dialog.