What's the Data Freshness in Google Datastudio referring to?
In Google Datastudio, one can set the Data Freshness on each Datasource.
It can be set to 1 hour, 4 hours or 12 hours but not to an explicit point in time.
Does this mean the cache is invalidated at each of these times, or will it first check whether the cache is invalid with respect to source data and only when new data has arrived will it update the cache?
E.g. -> when I have source data that is updated only every 24 hours, and I set "1 hour data freshness" will it actually invalidate the cache 24 times a day, or just once a day?
I am asking because when the source data is refreshed, it should be reflected in the dashboards as soon as possible, on the other side I don't want to incur extra costs by setting it to "1 hour" if that would recompute the cache 23 times out of 24 unnecessarily..
The Data Freshness options represent the refresh frequency (checking and updating the report with new data from the Data Set), thus:
- 15 Minutes = Refreshing 96 times in a day (24 Hours)
- 1 Hour = Refreshing 24 times in a day (24 Hours)
- 4 Hours = Refreshing 6 times in a day (24 Hours)
- 12 Hours = Refreshing 2 times in a day (24 Hours)
Quoting from the Refresh the cache section of the Data Freshness article:
When the cache refreshes, all the old cached data is discarded. New queries generated by the report go directly to the underlying platform and the responses are added to the cache.
