I cannot find a way to clear the cache for all questions. This create very strange results for users seing old cached results.
As discussed in another topic, I managed to refresh some questions’ cache automatically.
But this only works for questions without filters. I am trying to find a robust way to clear the cache.
I connected to H2 (usingthis docker image), and run the query TRUNCATE TABLE QUERY_CACHE. This seems to clear the cache as expected. But I do not know if it will corrupt H2 database.
- Is this a correct way to clear the cache ?
- If yes, would it be possible to add it to Metabase interface ?