Is it possible to set a data retention period on a SQL dataset with incremental refresh enabled? Or even manually delete old data from it? I’m trying to prevent my dataset from growing too large and really only need it to retain the previous 2 weeks of data at most… It adds about 3.5M rows of data d…

Hi @Colin ! You’re able to define the time range when configuring the incremental refresh. I’ve attached the documentation and added an excerpt just below: For Window size, enter a number for size, and then choose an amount of time that you want to look back for changes.You can choose to refresh ch…

Setting data retention period on incremental refresh dataset?

Q&A

Giang_Nguyen November 30, 2023, 12:32pm 6

resurface this question, appreciate any clarification from Quick Sight team..

Optimizing processing time of Quick Sight SPICE refresh

Deleting old SPICE Data for cost optimisation

Topic		Replies	Views
Remove old data from SPICE dataset without full refresh Q&A data-source , feature-request , dataset , qls-spice , Business-Intelligence-Engineer	7	1175	February 23, 2024
Quick Sight Incremental Data Refreshes Q&A feature-request , data-preparation	4	1246	July 21, 2023
Incremental refresh & last X days Q&A dataset , Business-Intelligence-Engineer	3	51	August 5, 2024
Keeping a rolling 2 years worth of records in SPICE dataset. What is the best way? Q&A data-source , filters , feature-request , dataset , Business-Intelligence-Engineer	3	450	October 21, 2023
Incremental Refresh to create historical dataset Q&A spice	9	5372	October 11, 2022

Setting data retention period on incremental refresh dataset?

Related topics