The trouble is that modern businesses accumulate data at an ever-accelerating pace. The number of data sources is exploding as well, and now includes innumerable internet-of-things (IoT) sensors and other devices, as well as streaming sources.
Managing, storing, protecting, and analyzing all that data has become more than traditional IT and business intelligence (BI) teams can handle. And the traditional on-premise data center has become a bottleneck that prevents analysts from uncovering valuable insights from enterprise data.
Enterprises have looked to the cloud for solutions, and the cloud has provided.
Several cloud-based database and data warehousing solutions have emerged, and enterprises are finding the value propositions of these solutions quite compelling.
One of the newer cloud-based data warehousing solutions on the market is called Snowflake, developed and supported by a company of the same name. Snowflake has attracted keen interest because of its major advantages:
For all of its advantages, how does Snowflake measure up to its alternatives? Let’s have a look:
Numerous data warehousing systems are available for on-premise or private cloud deployment. Many of them have been around for a long time and are quite mature, such as Microsoft SQL Server, Teradata, and Oracle Exadata.
Because these alternatives do their jobs on your own network, data transfer speeds are naturally much higher than with Snowflake or any other cloud solution. However, the Snowflake makes up for this disadvantage in several ways:
One area in which on-premise solutions have a clear advantage over Snowflake is transactional data. On-premise solutions can manage or integrate with transactional data.
Snowflake is a cloud-only solution.
It’s not designed to handle or manage transactional data, and even if it were, the network connection to the cloud could become a bottleneck if it had to the handle thousands of transactions per second seen by larger enterprises. Snowflake is optimized as a data warehouse solution to store summarized data and perform queries.
Snowflake’s main competitors in cloud-based data warehousing include Amazon Redshift, Google BigQuery, and Microsoft Azure SQL Data Warehouse. They run only in their respective cloud services, but Snowflake can run on any or all of them—it’s “cloud agnostic” and can operate on data within or across different cloud services.
Snowflake is more flexible and is ideal for enterprises that have a multi-cloud data landscape.
Reviewers of Snowflake are in general agreement on its advantages and disadvantages:
As you can see, the disadvantages tend to be more technical in nature; these are shortcomings that will likely be addressed as the product matures.
Snowflake is a robust data warehousing tool that enables customers to take advantage of all that cloud computing has to offer without the headache of setting up and optimizing a cloud environment.
For companies that are outgrowing their ability to build and operate their data warehouses using local resources, Snowflake offers a combination of flexibility, reliability, and performance that deserves an in-depth look.