Dremio, S3, can't read the CSVs


I’m looking at using Dremio for CSV handling, for which I am uploading the CSVs into S3 first.

However, /dremio cannot handle them, surprisingly.

When loaded into Notepad++, these are identified as 'Macintosh (CR);, UCS-2 Little Endian.

I cannot seem to find anything to tell me what the code page should be…

As i don’t have control of the exporting system, what are my options?



Are you able to generate a CSV file with sample data (few rows) and send it over?