A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual warehouses?
A.
Setting a '0' or NULL value means the warehouses will never suspend.
B.
Setting a '0' or NULL value means the warehouses will suspend immediately.
C.
Setting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.
D.
Setting a '0' value means the warehouses will suspend immediately, and NULL means the warehouses will never suspend.
The AUTO_SUSPEND parameter controls the amount of time, in seconds, of inactivity after which a warehouse is automatically suspended. If the parameter is set to NULL, the warehouse never suspends. If the parameter is set to ‘0’, the warehouse suspends immediately after executing a query. Therefore, the execution behavior of the two virtual warehouses will be different depending on the AUTO_SUSPEND value. The warehouse with NULL value will keep running until it is manually suspended or the resource monitor limits are reached. The warehouse with ‘0’ value will suspend as soon as it finishes a query and release the compute resources. References:
ALTER WAREHOUSE
Parameters
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit