Quick Sight Direct Query vs SPICE

We have a report based on custom SQL but every execution it is fetching data from SPICE instead direct query. I tried multiple options but still we are facing the same issue. Please suggest.

Hi @Subbareddy1 - Welcome to AWS QuickSight community and thanks for posting the question. Can you please try to change to Query mode in data set page, see the below pic.

Also ensure that in your data set you are not join data sets, if possible please send a screenshot for understanding the set up and guide you the right solution.

Regards - Sanjeeb

1 Like