I know this question has been beaten over. Am using an athena view to extract data which takes 2 min 51.109 sec in Athena but times out when used in Quick Sights. Its less than 10 rows of non-complicated data. Is there a different suggestion apart from downloading to a file and using which works but we want to trigger dynamically?
Hi @vinayjan
Can you please explain what you would like to trigger dynamically?
It seems like you are using Direct Query. Please confirm. Did you try importing the data into SPICE?
Regards
Vetri
Its dynamic data that needs be queried everytime. I can import static data and it works but am querying cloudtrail data via athena and the view in athena queries a table.
So static import into spice everytime is not a viable option for me.
Rgds,
Vinay
Hi @vinayjan
Can you please try dataset parameters and see if it reduces the number of rows being scanned?
Sure, am also trying to partition the table being queried, I’ll get back tomorrow.
The query in Athena takes quite a bit of time too which is the main cause of the issue. Quicksights is fine with it’s functionality. Athena → S3 and back is the bottleneck.
Thanks for your suggestions.
Regards,
Vinay