WHAT IS VIRTUAL WAREHOUSE

What is Virtual warehouse?

1.Virtual warehouse is a cluster of compute resources such as CPU(Processor), Memory(RAM) and temporary storage (We can also group of Servers)

2.Virtual warehouse is needed for Query processing (SELECT, DML), data loading and unloading.

3.Warehouses can be started and stopped at any time as Snowflake storage & computing are loosely coupled. They can also be resized at any time, even while query running

4.A warehouse can be created using WEB UI/SnowSight OR using SQL script.

Single cluster warehouse:
⦁Single cluster warehouse contains only one Cluster,By default, a virtual warehouse is a single-cluster of compute resource.

⦁It has only one warehouse for executing the submitted queries.

⦁Because it has only one warehouse, it might become a problem when we have lot of queries being queued for execution during peak hours, if sufficient resources are not available to execute all the queries submitted to the warehouse

⦁ To solve concurrency problem, we can use multi-cluster warehouse
Multi-Cluster Warehouse
⦁To achieve Automated Concurrency, Snowflake introduced multi-cluster Data Warehouses.

⦁In a Multi-Cluster warehouse we can have more than one clusters and clusters will spin up based on the mode that we select during Virtual Warehouse creation
⦁ These are, as the name suggests, composed of multiple clusters. So when your workload increases, Snowflake can automatically employ more clusters of the warehouse. This way, a sudden increase in workload won’t lead to queued or failed queries, and consequently frustrated users. When the workload decreases, the additional compute resources are automatically shut down.

Видео WHAT IS VIRTUAL WAREHOUSE канала Tech Learning Hub