'Datagroup Maintenance Schedule' vs. 'datagroup- max_cache_age'

if I have defined max_cache_age in datagroup within a model say 'A' and we also have Datagroup Maintenance Schedule then which one should be executing for this model?

here is a code

datagroup: caching_dashboard {
max_cache_age: "720 hours"
label: "Market Cache Policy"
}

then, I also have this 

priyanath_0-1724090115658.png

Will Looker runs the caching policy per 'datagroup defined in the model ' or per 'Datagroup Maintenance Schedule' for this model A.  Thank you

 

0 1 111
1 REPLY 1

They'll both take effect. But for the purpose of your question, the Datagroup Maintenance Schedule will "win".

The max cache age just says how long a query CAN live before being cleared.

  • max_cache_age — Specifies a string that defines a time period. When the age of a query's cache exceeds the time period, Looker invalidates the cache. The next time the query is issued, Looker sends the query to the database for fresh results.

On the other hand, the Datagroup Maintenance Schedule actively clears cache and runs new queries. It won't leave a datagroup alone just because it has a higher max_cache_age.

Top Labels in this Space
Top Solution Authors