Questions about Snowflake asked by my Students on Udemy (Q31-Q35)

Cristian Scutaru
4 min readOct 11, 2024

These are all real-life questions I’ve been asked by students of my Udemy courses about Snowflake. My previous last post from this ongoing series: Questions about Snowflake asked by my Students on Udemy (Q26-Q30). Here are are more recent questions, about the Snowflake virtual warehouses, the Snowflake costs, and the dynamic tables.

[Q31] Since the number of cluster*warehouse default node is total node we get with cluster, how do we decide when to use multi cluster warehouse vs large warehouse?

Like here 64*3nodes were being used and we were getting billed for all nodes each minute, then lets say I have multi cluster 3XL warehouse with 2 cluster and one 4XL warehouse, which should I use since both will be billed same to me, and initially I was thinking of multi-cluster warehouses as something like it will scale up and down if more nodes are need for compute but here since even when we are not using warehouse we are paying for…

--

--

Cristian Scutaru

World-class expert in Snowflake Data Cloud. Former Snowflake "Data Superhero". SnowPro SME (Subject Matter Expert). 5x SnowPro certification exams.