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  Image Modified
Create a New Integration 
(Optional) Specify information for Export to Amazon S3. 
| Field | Description |
|---|
| 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. | | Format | The format of the exported files: - csv (comma separated)
- tsv (tab separated)
| | Compression | The compression format of the exported files: | | Header line? | The header line with column name as the first line. | | Delimiter | The delimited character: | | Quote policy | The policy for a quote: - ALL
- MINIMAL: Add the quote character to only fields which contain delimiter, quote, or any of the characters in lineterminator.
- NONE
| | Null string | How null value of the result of the query displays: - Default
- empty string
- \N
- NULL
- null
| | End-of-line character | 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. |
|