Snowflake, Rajiv Gupta, Data Superhero, Searchoptimizationservice, Clustering.
summary of performance. We are using X-SMALL single cluster warehouse for all our test comparison. We are suspending and restarting our warehouse to avoid any kind of cache. We will disable the result cache to overcome any performance improvement due to caching. ALTER SESSION SET USE_CACHED_RESULT