Snowflake Adaptive Warehouses are now in public preview. We tested out them out and think they are fantastic! (but dont offset all the engineering challenges) read more in the blog post