Data Engineering, Data Analytics, Database, Snowflake, Software Engineering.
during the duration of the worker node. Snowflake applies the LRU policy (discard the least-recently-used items first) for the cache. This simple scheme works surprisingly well. Query optimizer assigns files to the worker node’s cache using consistent hashing on the table name. This helps queries