How to upload large Excel file into Quicksight?

0

Customer is ingesting excel files into Quicksight. According to Creating DataSet from Excel the max file size is 1GB and there are limits on number of columns and column size.

I'm looking for a strategy to handle large files. take for example a 10GB excel file.

  1. Break into smaller files and upload each file independently into Quicksight
  2. Upload smaller files into S3 and then into Quicksight
  3. Upload large file into RDS and then into Quicksight
  4. other option?
AWS
MODÉRATEUR
demandé il y a 3 ans1067 vues
1 réponse
1
Réponse acceptée

Here is a great blog post around ingesting excel data into QuickSight. It most aligns with your 2nd option. Put excel file into S3, convert file type, map the file to a Glue Table, then use Athena to bring the data into QuickSight. https://aws.amazon.com/blogs/big-data/ingest-excel-data-automatically-into-amazon-quicksight/

AWS
répondu il y a 3 ans
profile picture
EXPERT
vérifié il y a 9 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions