Export csv options


#1

Is there a possibility to define the structure of the exported csv’s?
When values already contain commas then the export cannot be used without post-processing.

e.g.
label, id
1,1,2-Trichloorethaan,CID6574
Should be
"1,1,2-Trichloorethaan",CID6574


#2

Hi Paul,

The behavior on commas in a .csv file is bug in our code – the fix for which will be available in the next version.

Unfortunately, today there is no possibility for exporting csv files with other delimiters (such as tabs, spaces, etc). This is an enhancement request that we are already tracking – originally requested in this post


#3

My temporary fix it to run the Dremio SQL using a JDBC connection with a 3rd party SQL client and then export the results using whatever the 3rd party SQL client provides (Excel, Tab Delimited, SQL Insert Statements, etc…)


#4

are there any updates on customizing the csv export delimiters? is it possible to set it from the configuration file (dremio.conf)?


#5

The quoting issue was fixed a while back. Unfortunately, there has been no progress on the customization. Also unfortunately, there are no options in the configuration file that can be used to set the delimiters used in export.