Snowflake, Sql, Performance, Data Science, Data Engineering.
XL warehouse is faster as it offers more parallelism, and the second run of each is faster as it uses the Snowflake local disk cache. This means that your queries on Snowflake are faster on warm data — which is the typical scenario when you are running a series of queries. Let’s go deeper — get all