Is there a workaround to import a 200MB 2M row TSV?

Q&A
, ,
1

Hi folks! I’m super new in Quicksight and I love it! :star_struck: I have a 200MB TSV file with around 2M rows and 20 columns. Every time I import the file (TSV) to my Analysis, Quicksight truncates the file and only shows half of the rows :face_with_bags_under_eyes: . Why is this happening? Can I do something about it? Any suggestions? I’ve read the data import limits in Quicksight and It seems I’m way below thresholds.

2

Hi @Andres_Rubio

Welcome to the QuickSight community!

QuickSight supports SPICE datasets with limits, each dataset in the Standard Edition allows up to 25 million rows or 25 GB, and in the Enterprise Edition up to 2 billion rows or 1 TB, files can contain up to 2000 columns, with each column name capped at 127 Unicode characters and each field cell up to 2047 Unicode characters.

Please refer to the following documentations this might be helpful for you.

3

Hi @Andres_Rubio,

Hope everything is well! Just checking in since this thread hasn’t received a response in a while. Were you able to see Xclipse’s most recent message or find the answer yourself in the meantime? If we do not hear back within the next 3 business days, I’ll go ahead and close/archive this topic.

Thank you!

4

Hi @Andres_Rubio,

Since we have not heard back, I’ll go ahead and close out of this topic. However, if you have any additional questions, please feel free to post again in the Quick Suite Community and link this thread for any relevant information.

Thank you!