Understanding these caching differences can help optimize query performance and control expenses, especially in consumption-based warehouses like Snowflake