How can I reduce the refresh time for SPICE dataset in AWS QuickSight?

Hi QuickSight community members
I am currently struggling to reduce the refresh time for my datasets which I had schedule for hourly refresh in spice memory, just wanted to know some basics, suppose I have connected my RDS to AWS QuickSight which would be faster way directly calling the table in data set and then excluding the fields which were not required, or using custom SQL query to exclude the fields which were not required in query level itself, also should I write a complex query to include all the fields in single data or should I add multiple data for different requirements and joining them in my datasets

Hello Abhi,

I would recommend to refer this blog for better understanding and see if this helps.

Hope this gives some idea.

Cheers,
Deep

2 Likes

Sure Deep will check this out, Thanks for your help !

1 Like