Here are three reasons why Snowflake is changing the Cloud computing world.
- Every single SQL statement I have ever seen from every other database vendor works on Snowflake. I have never seen anything like that in the 30-years of teaching SQL. Why is this nearly impossible feat important? Companies can instantly migrate data to Snowflake and still use their current applications from each system.
- Snowflake allows you to purchase computing nodes on the cloud, and you are only charged for the computing nodes when queries are running. You can increase the number of nodes to hundreds of nodes (i.e., to load billions of rows in minutes), and then you can decrease the number of nodes to one if you desire. They call this a consumption model, but I call this real-time scalability.
- Compute nodes and storage are separate, so a company has options for creating multiple data warehouses that access the same data. You can have different organizations within your enterprise purchase their own compute nodes, and each separate entity in the organization can access the same data, or load and query the data they need.
The Snowflake architecture is a combination of Teradata’s parallel processing and scalability with Netezza’s load-and-go strategy with Amazon’s consumption model. Snowflake uses no indexing or partitioning of data, but instead min-max column metadata on each data block to tune Snowflake automatically.
Snowflake is a Software as a Service (Saas) provider and they only work on the cloud. They are both a partner and competitor with Amazon, Google, and the Microsoft Azure cloud. Amazon works on AWS, Microsoft works on Azure, and Google works on the Google cloud, but Snowflake works on them all.
Some big-time players from Microsoft and Oracle started Snowflake in 2012, and they have a current valuation of 3.9 Billion dollars. They currently have over 2,000 current customers largely because they were able to triple their customer base this year (2019).
Currently, the combination of our Nexus Query Chameleon and NexusCore Server products can move data at top speed with the press of a button between Teradata, Oracle, SQL Server, DB2, Postgres, MySQL, Amazon Redshift, Azure SQL Data Warehouse, SAP HANA, Greenplum, and Snowflake. We split the source data into different streams to parallel process the loads to Snowflake. Then customers can execute the movement from the NexusCore Server, where it makes the most sense (on-premises or on any cloud).
Watch the video and see how our customers are moving entire databases from Teradata to Snowflake using the Nexus and Nexus Server.
Call or write to set up a demo so you can do your own Proof of Concept (POC).
CEO, Coffing Data Warehousing
Direct: 513 300-0341
Youtube channel: CoffingDW
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 25 years. Tom has written over 75 books on all aspects of Teradata, Netezza, Yellowbrick, Snowflake, Redshift, Aurora, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus Product Line.