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?
did you ever find a solution to this? we are coming across the same problem