Only cache result used even source data changed

[pdscodes]

I found s strange issue that only cached result is returned when using python SQL. I am testing the same query in a time span of one hour and the same result returns from the cache. The source data is changed during this time.

Exact same query works fine and returns a new result in SQL data warehouse UI SQL editor (I actually copied the query sent from API from query history)

I end up run this one to clear cache manually: cursor.execute("SET use_cached_result = false")