Hi Community, I need one help. I have a simple SQL query but when I upload it in Quicksight using SPICE memory it takes about 1hr 30min (incremental refresh : refresh period after one hour in one day). Could you please suggest how can I improve this?
Hi @ApoorvaV and welcome to the Quick Sight community!
How large is the dataset that you’re dealing with in this scenario? Additionally, when you mention that your SQL query is simple, what does it include?
the dataset is ~6000 rows. I am using the below condition for time >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH) . I believe this is causing slowness in the the refresh process in Quick Sight and takes ~1hr 30 min to refresh and the incremental refresh on this takes the same time which is ~1hr 30 min. Ideally the incremental refresh should less time.
hey! the code i use in SQL for ‘last 6 months’ is the following:
** >= CAST(GETDATE()-180 as date)
**date in table
Hope this helps, I feel is the lighter approach, other ways make things a little heavier.
Hi @ApoorvaV
Have you checked how long this query runs if you run this in the database? I suspect it may be taking time in the db as well. You may need to then look at the execution plan and see if there are opportunities to improve your query.
Regards,
Giri
Hi @ApoorvaV,
Hope this message finds you well! Were you able to find a solution to your question through the other posters’ suggestions or yourself in general? If not, please feel free to further elaborate on persistent issues regarding the slowness in refreshes. If we do not receive a response in the next 3 business days, I’ll close out of this topic.
Thanks!
Hi @ApoorvaV,
Since we have not heard back, I’ll close out of this topic. However, if you have any other questions, please feel free to post again in the community and link this discussion for relevant information if needed.
Thank you!