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-caching-ttl-ratio)
- wait until queries’ cache expire (3 minutes is okay in my case)
- run all queries (POST /api/card/:card-id/query)
- set back query-caching-ttl-ratio