I have a spice dataset that is set to refresh every 1 hour. The volume is around 1M and it takes 15 minutes to refresh. Every refresh produces completely new data.
I want to compare refresh 1 vs refresh 2 of the same dataset.
For examples, sales dataset refreshed at 1 PM PST vs sales dataset refreshed at 2 PM PST.
I have set full refresh as there is no data field that I can use as key. It is full refresh every hour.
How can I access previously refreshed dataset of the same data in spice dataset?
Hi @sudheen,
I don’t think you have an option to access the data from a previous refresh.
If what you are trying to do is an experiment to understand the size of delta or something like that you may create the same dataset as two different datasets with slightly different schedules (dataset 1 - refresh every 1 hour starting 1 pm; dataset 2 - refresh every one hour starting 2 pm) and use two visuals to produce summary visualizations of data and compare.
1 Like
Hi @Giridhar.Prabhu - Thank you. this is a work around solution. You are correctly said, it is not possible to see old spice refreshed data.
Regards - Sanjeeb
1 Like
@Sanjeeb2022
Thank you. I thought so, i’m considering building the core logic in the sql and use quicksight as pass thru.
2 Likes
Thank you @sudheen . You can mark the right suggestion as solution.
Regards - Sanjeeb