I just recently had to do this at work. We load data into aws redshift from csv in s3. Well, one particular set of files had a BOM[1], which redshift chokes on.

I just recently had to do this at work. We load data into aws redshift from csv in s3. Well, one particular set of files had a BOM[1], which redshift chokes on. Cue having to rewrite the entire 4.5GB file because to remove the first three bytes. [1] https://en.wikipedia.org/wiki/Byte_order_mark https://en.wikipedia.org/wiki/Byte_order_mark