I have a Spice, that would connect to Snowflake and get the latest values in different time intervals.
Now, when I was working and developing the dashboard, the updated values were not populated in visuals which uses the data set before itself, how can we update the latest values for the visuals in the analysis?
in the dashboard(both on the quick-sight dashboard page(I can see old values only), and when we embed the dashboard into our application) also how can we make sure that the latest values have been updated in the visuals when the user sees?
Multiple options are available for refreshing the dataset imported into spice. You can choose to incrementally refresh the dataset in spice from snowflake and schedule the refreshes (at a granularity of every 15 minutes).
HI @awsvig, I am clear on refreshing the data set into Spice, my concern is how we can make sure the latest data shows in visual based on the latest updated data on spice.
As of now …when I create a new visual I can get the latest data in that visual…the old visuals in the analysis page and the dashboards shows only old values
@awsvig yes have updated it and one doubt is we use, a free dorm sheet and hide the visuals based on the rules, and I am using the same sheet…how does this work in this scenario?
Hi @sowndar - Does a page refresh load the latest data set? If the spice dataset is refreshed, any new call to the dataset to represent the visual will use the latest dataset. A refresh of the dashboard, moving to another sheet etc will make that query to the dataset and retrieve the latest refreshed information.