18. Caching

Result Cache

Query results are cached for 24 hours (or until underlying data changes). Identical queries served from cache — no warehouse needed.

-- First run: executes (billed)
SELECT COUNT(*) FROM sales;

-- Second run: served from result cache (free, instant)
SELECT COUNT(*) FROM sales;

Warehouse Cache

Data files cached in SSD on warehouse nodes. Persists while warehouse is running. If warehouse is suspended, cache is lost.

Metadata Cache

Object metadata (row count, column stats, partitions) is always cached and served instantly for optimization.

Best Practices

• Keep warehouses running for repeated queries to benefit from cache
• Use RESULT_SCAN to access previous results

SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));