'Query behavior when the warehouse fails
I use snowflake for turning out if it can use for DWH, and I am concern with the query behavior when the warehouse somehow fails.
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#multi-cluster-warehouses-improve-concurrency According to the above page, if the minimum cluster is set to higher than 1, it helps ensure availability and continuity. I have questions about it.
1.If we set it to 1 and the warehouse fails, the proceeded query come to fail? 2.If we set it to 2 or more and a cluster of the warehouse fails, the proceeded query come to fail and start automatically by another cluster?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|