How to clear big query cache from JS code

I am trying to poll a big query table to update the table with the latest data. To find out that the table has updated data, I planned to check the table's last modified time against local current time. I created the big query resource to fetch the last modified time and a JS resource to invoke the last-modified big query resource in a loop. The last modified time big query always returns same old value on all invocations even though the big query table has updated data. I'm suspecting that the results of last modified query resource is cached. Is it possible to force a fetch (bypass cached result)?


Hi @kumaran! Could you share more about what "last modified" data represents? Could this be a column in a table?

This could be something related to caching. Do you currently have caching set up for your queries?