How does it make sense that alerts can run on a cache?

I came across something very bizarre. For some reason, alerts in Looker respect caching policies.

This does not make any sense to me. If an alert runs on a cache that is showing outdated information, it will alert to something that might no longer be true.

I don't want to change the caching policy for my Model because it is useful to cache dashboards for a certain time or until the user forces a refresh. Alerts, however, should never run on a cache.

How do you deal with this issue?

0 2 215
2 REPLIES 2

did you ever find a solution to this? we are coming across the same problem

No, unfortunately not. A workaround is to set the caching policy of the model to be lower than the schedule set on the alert. It requires you to monitor alerts being set up and adjust the cache of the model accordingly, so it’s anything less than ideal.