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 integration for SFTP.
If FTP/FTPS, try connect with FTP Data ConnectorImport Integration.
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
.The default format of the private key after OpenSSH
“PuTTY” and other formats are not supported
- 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.
- Support only the STORED and DEFLATE compression methods.
- Multi-part gzip file may not work
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.