Why isn't spice option showing up?

I am trying to change the query mode to spice but its not showing up. Why is that and how can I fix this if possible?

Hello @divadaz

Welcome to Quicksight comminity and thank you for posting your question.

It could be because of 2 reasons - Size and the way you are joining the datasets.

  1. Whats the size of your dataset? Does it have more than 2 billion rows or 1 TB of data, whichever comes first (Enterprise edition) (standard edition has 25 million rows) If your dataset exceeds this limit, you won’t be able to use SPICE for it. May I know your dataset size please ?
  1. Are you using any joins and joining any datasets ?

  2. What is your data source?

Hi @divadaz

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

Hi @divadaz

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!