What will happen same role persons are trying to change the warehouse size at same time in snowflake?

50 views Asked by At

Two persons with same roles (sysadmin) trying to change warehouse size ata same time? Which user instructions will execute first?

1

There are 1 answers

0
Simeon Pilgrim On

like every one else, there is no same time...

But also the warehouse resize is handled by the service layer, so there is an order there. I would assume the resize command for the second would be ignored, as it is "already in the process of a resize to the same size" if the sizes are different I would assume/hope the "last wins" but also could see the second getting an error with a resize is underway.

This is all based on the fact, that a resize leave the existing servers running while they complete, and starts queued/new queries on the new servers. Which firstly has to be spun up. So this is really a slow (in computer time) operation. And thus it's not a wild +1 type thing, as you explicitly set the size to something.