What Is snowflake Cloud Data Warehouse

Why you should consider Snowflake Cloud Data Warehouse and what does it bring to the table.

What Is snowflake Cloud Data Warehouse

Snowflake is a cloud-based data warehouse that was founded in 2012 by three data warehousing experts. Six years later, the company received a $450 million venture capital investment, valuing it at $3.5 billion. But what exactly is Snowflake, and why is this cloud-based data warehouse causing such a stir in the analytics world?

How does Snowflake Works

Snowflake has a lot of cool capabilities, but one of the most impressive is the ability to create an unlimited number of virtual warehouses (each effectively an independent MPP cluster). As seen in the picture below, users can execute an endless number of independent workloads against the same data without fear of contention.

Furthermore, each warehouse may be scaled from a single node extra-small cluster to a gigantic 128-node monster in milliseconds. Users will not have to put up with subpar performance because the machine size can be modified during the day to match the workload. I cut the time it took to process 1.3 terabytes of data from 5 hours to under 3 minutes in one benchmark test.

Finally, in addition to scaling up for bigger data volumes, it’s also able to scale out to handle a huge number of users automatically.

Snowflake Introduction And History

You can watch the complete hands on video tutorial

Complete Snowflake Guide - Tree Map

You can watch [complete playlist]video tutorial containing 25 chapters covering all the fundamental consept of Snowflake Cloud Data Warehouse.