Can we able to calculate SPICE dataset size

Question & Answer
, ,
1

I am going to deploy the CUDOS dashboard on the quick sight now I want to know the how can we calculate SPICE dataset size also is there any retention period set for the SPICE dataset?

2

Hello Akshay,

Fist of all Welcome to the QuickSight Community.

I would recommend first of all to understand what exactly is SPICE and how it works.Importing data into SPICE - Amazon QuickSight

Estimating SPICE -Importing data into SPICE - Amazon QuickSight

Managing SPICE capacity -Managing SPICE memory capacity - Amazon QuickSight

There is no retention period or Expiry of Data set. It remains unless you delete it it.

Hope this helps.

Cheers,
Deep

3

Hi Team,

I have some questions about QuickSight and SPICE. Could you help clarify them?

1.How does SPICE handle data retention when querying from Athena? If we need to maintain a rolling six-month dataset, do we have to manage data removal manually, or is there an automated way to handle this?
2.When a new month’s data is added, does SPICE overwrite the previous dataset, or does it append the data? How can we ensure that only relevant data is retained?
3.What is the impact of frequent data refreshes on performance and cost? Would a full refresh or incremental refresh be more efficient for our use case?
4.How does SPICE compression work, and what factors influence the actual storage size compared to raw data in Athena?
5.How can we estimate the SPICE storage required before importing data, especially when working with consolidated billing data?
6.Since SPICE storage is billed based on allocated capacity, what strategies can we use to optimize usage and avoid unnecessary costs?
7.Is there a way to monitor and analyze SPICE usage trends over time to ensure we don’t exceed allocated capacity?

4

Hello Akshay,

I would recommend to open a new thread for additional questions so that it get attention from all possible members and does not get buried under a single thread.

Thank you.

Cheers,
Deep