Snowflake Expands Result Cache for Some Non-deterministic Functions
Snowflake has now enabled result caching for queries involving functions that generate non-deterministic results. We’ve identified certain functions whose results, even if they might be non-deterministic, are valid and suitable for caching. As such, the presence of these functions will no longer disable result caching.
- ANY_VALUE
- MODE
- MIN_BY
- MAX_BY
- FIRST_VALUE
- LAST_VALUE
- NTH_VALUE
- MATCH_RECOGNIZE
Please note that caching may be disabled for other reasons.
