DataGrip - Import Data from File cannot read lines too long
At first I thought it was unable to see where each line ended, so I fiddled around with the line break formats.
Tried Unix, Mac, Windows and none of them worked, only the header was visible.
So then I tried creating a new CSV file manually and now DataGrip was able to see the content.
I found this weird so the next step was to use a long line (>100 chars). Lo and behold, this line did not show up in the preview.
I'll attach a screenshot and the DataGrip window with a text editor side-by-side.
Please sign in to leave a comment.
Hi,
Could you provide sample CSV file or some strings to reproduce the problem? Also, it'll be useful to get target table DDL.
Thank you.