{"id":516167,"date":"2022-06-20T12:17:15","date_gmt":"2022-06-20T10:17:15","guid":{"rendered":"https:\/\/www.devoteam.com\/expert-view\/snowflake-difference-data-technologies\/"},"modified":"2025-04-07T09:59:24","modified_gmt":"2025-04-07T07:59:24","slug":"snowflake-difference-data-technologies","status":"publish","type":"expert-view","link":"https:\/\/devoteam.info\/en-pt\/expert-view\/snowflake-difference-data-technologies\/","title":{"rendered":"What Makes Snowflake Different from Other Data Technologies?"},"content":{"rendered":"\n

Snowflake<\/a> is a now 10-year-old cloud technology that helps companies get their data under control. But with so many data technologies on the market, what makes Snowflake different?\u00a0<\/p>\n\n

From day one, Snowflake has distinguished itself from the vast majority of other databases by its full-SaaS, zero-management approach, and a few key technologies such as Data Sharing, micro-partitions, zero-clone copy, and decoupling of processing and I\/O management. We will detail some of these features here.<\/p>\n\n

What is Snowflake?<\/strong><\/h2>\n\n

Snowflake<\/a> was founded in California in 2012 and publishes and distributes the eponymous Data Cloud platform, which was officially launched in October 2014.<\/p>\n\n

Designed for and available only on the Cloud, the Snowflake platform allows us to manage very large volumes of data while reducing to the extreme the technological skills required.<\/p>\n\n

On September 16, 2020, just 8 years after its creation, the company enters the Nasdaq and becomes one of the largest IPO in the software world. The Snowflake platform is now used by more than 6,300 customers worldwide and has a SaaS NRR (Net Retention Rate) of nearly 174% in recent years.<\/p>\n\n

Where did Snowflake come from?<\/strong><\/h2>\n\n

The two founders of Snowflake were French engineers working at Oracle as architects on traditional analytical systems. With new big data systems coming to the market, they quickly shared the same frustration and an obvious limitation of the so-called classical database architectures than existing facing new workloads.<\/p>\n\n

They decided to create a brand new data platform from scratch and sensing the impact of cloud computing on the industry in 2012, they decided that their database would only work in the cloud. They abstain from both the numerous constraints and hardware variants so that they will be able to focus on the so-called “high” layers of their software.<\/p>\n\n

After two years of R&D, Snowflake became available in 2014 on Microsoft’s Azure platform, as Cloud Computing starts to make headlines.<\/p>\n\n

What are the Top 4 Features of Snowflake?<\/strong><\/h2>\n\n

As mentioned above, there are several key features that help distinguish Snowflake from other data technologies on the market. Serverless technology, micro-partitions, separation of I\/O and processing, and multi-cloud functionality all give Snowflake its competitive advantage. Let\u2019s take a look at those features in more detail:<\/p>\n\n

1. A Serverless technology<\/strong><\/h3>\n\n

Snowflake is a so-called “Serverless” technology, as all the necessary computing resources (computing, storage, network) are managed and provided by Snowflake on demand.<\/p>\n\n

2. Micro-partitions<\/strong><\/h3>\n\n

One of the major features of Snowflake that allows it to reach high-performance levels while dealing with one of the major issues of Cloud platforms is its micro-partitioning<\/a> system. This system stores vertically (aka per column or group of columns) in the form of a reduced partition of the data as well as a set of metadata (value range, number of distinct values, and other information allowing to accelerate queries and processing).<\/p>\n\n

All tables are automatically stored with this micro-partition system and partitioned as they are fed.<\/p>\n\n

3. Separation of I\/O & Processing<\/strong><\/h3>\n\n

The second feature to know about Snowflake is its architecture which allows it to separate data access from data processing.<\/p>\n\n

Thus, it is possible through different types of processors (Virtual Warehouse) to answer a virtually infinite number of requests in parallel, whatever the nature of the processing. Virtual warehouses do not require any administration, only the choice of a power which is named like the size of a t-shirt: from XS to 12XL.<\/p>\n\n

It is on this last characteristic that Snowflake differs fundamentally from the traditional architectures which must treat within the same server network\/processing\/memory management.<\/p>\n\n

For these reasons, Snowflake falls into the category of so-called “Cloud Native” solutions.<\/p>\n\n

\u00a04. Multi-cloud<\/strong><\/h3>\n\n

Snowflake is available on the three major cloud platforms:\u00a0<\/p>\n\n

    \n
  1. Microsoft Azure<\/a>\u00a0<\/li>\n\n\n\n
  2. Google Cloud Computing<\/a><\/li>\n\n\n\n
  3. Amazon Web Services<\/a><\/li>\n<\/ol>\n\n

    Snowflake works in the same way whatever the cloud platform and allows since 2021 to synchronize in real-time and transparent environments deployed on two different cloud<\/a> providers.<\/p>\n\n

    What are the best-known use cases for Snowflake?<\/strong><\/h2>\n\n

    Snowflake’s use cases are very numerous and continue to evolve at a significant rate: Analytical Applications, Data lake, Data warehouse, Data Science, Data Applications, in batch, micro-batch or real-time mode.<\/p>\n\n

    1. Analytical Applications<\/strong><\/h3>\n\n

    The initial architecture of Snowflake is based on data storage and processing via SQL. It is therefore natural to find analytical applications as the most widespread use case.<\/p>\n\n

    Loading a very large volume of data, transforming the data and providing a set of tables and views for an advanced reporting or analytics tool.<\/p>\n\n

    The technology outlined in the previous chapter allows users to store, process and analyze virtually unlimited amounts of data. Indeed, the hardware limits inherent in other databases are largely pushed back, and it is not uncommon to divide response times by multiples of 10.<\/p>\n\n

    2. <\/strong>Data Lake<\/strong><\/a> \/ Data Warehouse<\/strong><\/h3>\n\n

    The very low cost of data storage, the absence of data tiering, within Snowflake and its capacity to process large volumes of data allow it to implement these two use cases on the same platform which are often handled within different platforms, using different technologies.<\/p>\n\n

    3. Data Science<\/strong><\/h3>\n\n

    The implementation of Data Science use cases can be done through different approaches:\u00a0<\/p>\n\n