Optimizing SPICE Memory and Refresh Strategies in AWS Quicksight with Timestream Data

Hi @zarrinmehr

  1. You can estimate the size of of SPICE memory space your dataset will occupy based on the formula provided here.
  2. You can also use cloudwatch to monitor the increase is SPICE consumption after your refresh to understand the trend.
  3. Finally, there is an option to auto purchase SPICE capacity as well, based on usage.

Going through #1 and #2 will help you understand your current consumption and trend of SPICE capacity . #3 is FYI. You can choose to use it once you have understood your usage pattern and want to eliminate manual increase of SPICE capacity.