Question

A BI dashboard runs the same query hundreds of times per hour against an unchanged table. An engineer expects the query result cache to serve most executions instantly, but the Query Profile shows the query is repeatedly recomputed on the warehouse. The query is: SELECT region, SUM(amount), CURRENT_TIMESTAMP() FROM sales GROUP BY region. What is the most likely reason the result cache is NOT being reused?

Accepted Answer

The query contains the non-deterministic function CURRENT_TIMESTAMP(), which prevents result cache reuse.

Answer

Result cache entries are only retained for 60 seconds, so a high-frequency dashboard exceeds the cache lifetime.

Answer

Aggregate queries using SUM() and GROUP BY are never eligible for the result cache.

Answer

The result cache is only used when the same user runs the query with the same warehouse active.