Is it possible to invalidate query cache using a rule/api


I have the following use case:
I update my date every Monda. I use BigQuery.
I want to cache the results for a week to save money. This will reduce my costs by a huge %

How can this be solved in Retool?

Thank you.

Hi David! It doesn't look as though it's possible to externally invalidate a cache at the moment (e.g. within a Workflow).

However, there is the option to invalidate the cache after a certain amount of time (e.g. 1 week).

Would something like this work for you?