Dashboard specific Caching

[theo]

@Wasiq I see you've made your way here.

I should add that I've got a pretty good working solution to refresh and cache a dashboard programatically.

Following the lead of this post:

Which API endpoint to refresh questions' cache

Thanks a lot ! I did not see this ignore_cache option. However, it does not work, as the Refresh button does not work either when cache is active… There is already an issue about this https://github.com/metabase/metabase/issues/7282 I tried to deactivate caching, run the query, then activate caching again, but the old cache value is not cleared nor updated. I found this hacky workaround to update cache before the issue get solved : set query-caching-ttl-ratio to 1 (PUT /api/setting/query-ca…