Exporting Data to CSV

1

Hi Community,

Is there any way that I can export the data as a CSV in Dremio through API or SQL Query and not from the UI ?

Thank you,
Maziha

2

@Maziha Try this

CREATE TABLE localhdfs.ctas.testcsv1 STORE AS (type => 'text', fieldDelimiter => ',', lineDelimiter => '
') WITH SINGLE WRITER AS SELECT * FROM table
3

This is working, thank you !