@Colin , @Giang_Nguyen ,
Currently there are no data retention possibilities when using SPICE.
Using Custom sql.
An example : My query always gets data from the last month
SPICE schedules
Daily loading process to get updated data every 30 minutes, I will setup an incremental refresh .
Additionally I will add another schedule which is a full refresh . In my scenario I am running a full refresh every day , I could also schedule it to run once a month .
SPICE dataset entering a new month, my full refresh will only bring in last month data+current month data. The incremental refresh will update + bring new records. Incremental refresh window size is set to 1 day.
The datasource is Redshift , the queries look as follows
Full Refresh
Incremental Refresh
Dataset Filters
You could also use filters during dataset preparation. No rolling date functionality, so you would have to specify a date.
Redshift SQL for incremental refresh
Please create a new post and link to this post if there are additional questions.
Kind regards,
Koushik