Hi there !
Which API endpoint should be used to refresh questions’ cache ?
Use case :
I am creating dashboards on data that is rarely updated (at most every day). Dashboard queries take 1-2 minutes on the whole dataset, which is way to long for users. But I cannot pre-compute results in the database, as I need filters on the data (and questions only take ~100ms with filters).
I set cache with a minimum query duration of 1s and TTL multiplier of 100000. This way cache will be used for almost every question.
Now I need to refresh this cache when data is updated (or before it expires).
So the question is : which metabase API endpoint should be use to trigger questions’ cache refresh ?
Thanks for your help !