HelloTeam, Why preview is not loading for this query , which will rertun around 500-600k rows

[Hireshkumar_Patel]

[Xclipse]

Hi @Hireshkumar_Patel

Welcome to the QuickSight community!

QuickSight enforces a 1-minute timeout for data preview queries. However, you can still save the dataset and load the data into SPICE memory. If you’re using Direct Query, you may need to rewrite or optimize your SQL to improve execution time.

Please refer the below QuickSight community post this might be helpful for you.

SQL Query - data not previewing

Hi there, my data is taking too long to preview and hence I am not able to use it in a dashboard. The error says: Preview timed out. You can save and visualize data, or try again. Even if i try to visualize the data, this would be empty. It seems like my data is too big but how can I solve this issue? Anyone has suggestions? [image]

[Brett]

Hi @Hireshkumar_Patel,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @Hireshkumar_Patel,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!