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)?
Thanks