Hello, this may not be an exact answer, but just hints of what I would try to troubleshoot it, assuming limits and others have been ruled out.
- You can convert to csv (there are free online tools available) and attempt to upload using csv. If you cannot convert, then there may be some problem on the json syntax, etc.
- Avoid special characters on the field, e.g. underscores and spaces. Although this should be ruled out because you've created a smaller subset and found working. I encountered same challenge as yours, i.e. columns are not detected, in Glue and the culrprit was the field names.
Hope these help! Please let me know the results!
How to ensure that ALL json object fields are imported into QuickSight?asked 2 months ago
QuickSight calculated field: How to get sum of last values of timestream measuresasked 7 months ago
Automating data updates on Quicksightasked 7 months ago
Is there documentation regarding how Quicksight charges are reflected in the CUR? I'm trying to match what I'm being charged vs the quick sight Pricing page:Accepted Answerasked 16 days ago
JSON logs not seen as JSON by Subscription filter?asked 2 years ago
Problems with animations made in blender that are imported into LumberyardAccepted Answerasked 4 years ago
QuickSight Cant parse my csv fileasked 3 months ago
Quicksight not able to ingest dataset bigger than 1GB at a timeasked 8 months ago
Import TimeStream's dimensions in QuickSightasked 5 months ago
Textract returning fields irrelevant to the block typeasked 14 days ago