Virtual warehouse pools for executing tasks

A method comprising:

• determining a number of execution nodes to execute a task;
• determining that no virtual warehouse from a pool of virtual warehouses includes at least the number of execution nodes;
• generating a new virtual warehouse including at least the number of execution nodes, the new virtual warehouse being different than each virtual warehouse from the pool of virtual warehouses;
• and
• selecting the new virtual warehouse to execute the task, the selecting comprising:
• determining whether a previous execution of a prior task was completed in less than a threshold time period of a time interval, the time interval corresponding to a particular period of time for executing at least one task,
• incrementing a score corresponding to a size of a particular virtual warehouse, and
• selecting the new virtual warehouse from the pool of virtual warehouses based at least in part on the incremented score and the number of execution nodes included in the selected new virtual warehouse.

A non-transitory computer-storage medium comprising instructions that, when executed by a processor, configure the processor to perform operations comprising:

• determining a number of execution nodes to execute a task;
• determining that no virtual warehouse from a pool of virtual warehouses includes at least the number of execution nodes;
• generating a new virtual warehouse including at least the number of execution nodes, the new virtual warehouse being different than each virtual warehouse from the pool of virtual warehouses;
• and
• selecting the new virtual warehouse to execute the task, the selecting comprising:
• determining whether a previous execution of a prior task was completed in less than a threshold time period of a time interval, the time interval corresponding to a particular period of time for executing at least one task,
• incrementing a score corresponding to a size of a particular virtual warehouse, and
• selecting the new virtual warehouse from the pool of virtual warehouses based at least in part on the incremented score and the number of execution nodes included in the selected new virtual warehouse.