When dealing with a large dataset in Amazon QuickSight, what is the best mode to use: SPICE mode or Direct Query?

Q&A
,
1

Hi All,

I need to implement a detailed report that includes data from the last three months, totaling around 200 million records.

What is the best approach for implementing this report: using SPICE mode or Direct Query?

1 Like
2

Hi @achourey - If the same data set is going to use for multiple analysis and users, go for SPICE .Please find the SPICE capacity below.

  • For Standard edition, 25 million (25,000,000) rows or 25 GB for each dataset
  • For Enterprise edition, 1 billion (1,000,000,000) rows or 1 TB for each dataset

Link - Data source quotas - Amazon QuickSight

Regards - Sanjeeb

3

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!