Configuring Output Files
- 07 Dec 2022
- Print
- DarkLight
- PDF
Configuring Output Files
- Updated on 07 Dec 2022
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.
summary
This is the help page of "Output file format" that can be specified at the transfer destination in the transfer settings.
What is the output file format?
If the destination is file storage such as S3 or SFTP, you need to specify the format of the file to be transferred. Currently, you can choose from two types: CSV and JSON Lines. You can also make detailed settings for each format when importing files.
About advanced settings
.CSV
Here is the site I used as a reference.
Item name | default value | description |
---|---|---|
Delimiter | , | You can set the data delimiter for CSV. |
Newline character | CRLF | You can choose the rule for line breaks: CR, CRLF, or LF. |
Newline character in fields | LF | You can choose between CR, CRLF, and LF rules for line breaks in the field. |
Character code | UFT-8 | You can set the character encoding. |
How to assign quotes | MINIMAL | Rules of quotes ・ALL (quote all fields) ・MINIMAL (quotes only when necessary, only when there is a delimiter etc. in the field) ・NONE (do not do quotes) You can choose from: |
Escape characters | \ | You can set escape characters. |
Characters to convert to NULL | - | You can set the character to be treated as NULL. |
Default time zone | UTC | You can set the time zone for time output. You can also override this setting with column settings. |
Column settings | format:%Y-%m-%d %H:%M:%S.%6N %z | For timestamp columns, you can specify the name of the column and set the time zone and format for that column. |
JSON Lines
I'm using embulk-formatter-jsonl.
Item name | default value | description |
---|---|---|
Character code | UTF-8 | Character code ・UTF-8 ・UTF-16LE ・UTF-32BE ・UTF-32LE ・UTF-32BE You can choose from: |
Newline character | LF | You can choose between CRLF, LF, CR, NUL, and NO for newline character rules. Learn more about each rule here. |
Date format | - | You can specify how the date is formatted. Please see here for details. |
Time zone | - | You can set the time zone. To use this option, you must also set the date format. |
Was this article helpful?