FlyData supports data formatted into comma or tab separated lists.
The specifications for CSV and TSV are a little different from RFC 4180.
- FlyData does not support the use of double quotes to enclose a field and escape characters like commas and tabs.
- FlyData requires backslash escapes for the following characters:
,commas, in CSV only.
\ttabs, in TSV only.
For example, if you wanted to upload a CSV file that includes the newline character, this is how you would handle the escape:
01,john,29,Hello I'm John.\\nHow are you doing?
Note: You must create the table on Amazon Redshift before you can upload in either CSV or TSV data format.