Last Modified Date: 02 Nov 2017
- Tableau Server
- Tableau Desktop
- Google BigQuery
ResolutionBigQuery does not cache the results when the "query uses non-deterministic functions; for example, date and time functions such as
NOW()..."By adding the non-deterministic functions to the query, it can be guaranteed that BigQuery will not reply to these queries with cached results.
Alternatively, you can slow the rate in which incremental refreshes occur to ensure that new rows have been written to the table between each incremental refresh.
CauseBigQuery will always attempt to reuse cached results when a duplicate query is run (with some exceptions). Since incremental refreshes send a query looking for new rows in the defined column, an incremental refresh will resend the same query until new rows appear.
As such, if a single incremental refresh occurs and no rows are reported, subsequent queries for new rows will receive the cached responses from BigQuery, even if rows have been added between the two incremental refresh attempts.
For more information about cached query results, see Using Cached Query Results in the Google Cloud Platform guides.
Additional InformationFull refreshes and Live connections to BigQuery do not produce this behavior.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials