Learn Snowflake

What is Snowflake

What is Snowflake?

Snowflake is one of the only cloud-based data warehouse solutions that prioritize simplicity over functionality. It automatically scales up and down to achieve the optimal performance/cost ratio.

 

With Snowflake, you can centrally store all of your data and scale your computing independently. For instance, if you require heavy data loads for complicated transitions but only have a few significant queries in your reports, you may create a large Snowflake warehouse for the data load and then scale it back down once complete – all of this in real-time. This reduces costs without affecting your objectives.

 

The Snowflake database is a cloud data warehouse offering which is available on Azure, but also on AWS and the Google Cloud platform. In contrast with other data warehouse services, Snowflake has been built purely for the cloud. Azure SQL Data Warehouse has roots in SQL Server Parallel Data Warehouse which was an on-premises solution. Because it’s been built for the cloud only, Snowflake takes advantage of certain cloud paradigms, such as the way it handle storage using blob storage for example. Snowflake positions itself as a "no-management" data warehouse, meaning it’s easy to set-up, configure and administer. Little to no technical skills are required to work with Snowflake, aside from some SQL knowledge perhaps.

 

Snowflake is quite a young company, but it has been growing steadily over the past years and it has been gaining market share. It has been listed as a leader for three consecutive years in the Gartner Magic Quadrant for data management solutions for analytics.

 

With Snowflake, you can centrally store all of your data and scale your computing independently. For instance, if you require heavy data loads for complicated transitions but only have a few significant queries in your reports, you may create a large Snowflake warehouse for the data load and then scale it back down once complete – all of this in real-time. This reduces costs without affecting your objectives.