Select Export Results.
You can select an existing authentication or create a new authentication for the external service to be used for output. Choose one of the following:
Use Existing Integration
Create a New Integration
(Optional) Specify information for Export to Amazon S3.
|Is user directory Root?|
If selected, the user directory is treated as the root directory.
(ex. ‘/home/treasure-data’ as ‘/’)
|Path prefix:||The file path where the file will be stored.|
|Rename file after upload finish||If selected, SFTP result output renames the file on the remote SFTP server from “.xxx.tmp” to “.xxx” after all the data is transferred. |
Some MA tools try to import data when a file with a specific name exists on the SFTP server. The temp name option is useful for such cases.
The format of the exported files:
- csv (comma separated)
- tsv (tab separated)
The compression format of the exported files:
|Header line?||The header line with column name as the first line.|
The delimited character:
The policy for a quote:
- MINIMAL: Add the quote character to only fields which contain delimiter, quote, or any of the characters in lineterminator.
How null value of the result of the query displays:
- empty string
The EOL (end-of-line) character:
|Temp filesize threshold|
The maximum file size (in bytes) of a local temp file. When the temp file reaches the threshold, the file flushes to a remote file.
If you encounter the error `channel is broken`, reduce the value of this option to resolve the error.