Record size of the CSV is too large to read from zip

Question

I can usually input a zip file into alteryx and it will read the files in the zip. Today I get this error:
"Record size of the CSV is too large to read from zip. Reduce to less than 256kb or select ‘First Row Contains Field Names’"

I don't know what happened, this has never happened before. I can't select "First row contains field names" because it doesn't.

The csv size inside of the zips I usually input are 96GB and it works fine. This one contains 36GB of csv and I got this error.

dreldrel · Answer

The error does not relate to the overall CSV size, but to the size of a single record within the CSV file inside the zip, which currently exceeds Alteryx's 256 KB limit when reading zipped files.

apathetichell · Answer

The delimiter is probably wrong. This is saying that a single row/column is 256kb. you probably normally use ,s and this file uses tabs or something. regenerate it and confirm the delimiter is the expected delimiter ---> or if you are daring try open it in something like notepad (or stream in a few rows using csv stream tools in python) ---> make sure to use no delimiter mode there to see the structure.