Snowflake, Sql, Performance, Data Science, Data Engineering.
session, because in both second runs the data was “warm” and available to be scanned from cache. But only the 2nd run on the XL warehouse was able to get 100% of data out of the local disk cache — the S warehouse still had to go fetch some of it on the warm run. This shows that the XL warehouse is