Select Page

Why Automating Snowflake is a Huge Deal for Agile Data Warehousing

| August 30, 2017

Sometimes a major technological advance is accelerated by another complementary innovation. It seems data automation and a Cloud-native database that separates storage from compute go together just like peas and carrots. Two huge steps forward in data management and democratization have just become one giant leap, and here’s why…

Ten years ago, could you imagine a giant 3D dragon jumping out of your bedroom wall? The rate of technological advance means you can buy a 3D projector the size of a handbag for $500 these days, whereas a few years ago this technology was only accessible in a cinema. First, you had big standard definition home projectors that made lots of noise and got very hot; then smaller, quieter HD; then 3D and now Ultra HD and so on. The gradual nature of this feels natural as everyone adjusts to the latest model, then suddenly you have a dragon leaping out of your wall and that feels normal.

Sometimes technology lurches forward in a giant step, skipping those granular stages. This shift precedes the understanding and acceptance of it, requiring people to retrospectively figure out how they can use its power. Breakthroughs like Big Data, which exploded with Hadoop’s ability to process huge streams of data in parallel, are solutions looking for problems: many people want Big Data strategies and invest in it without knowing exactly what data they want and why they really need it.

Scratching a 30-Year Itch

Snowflake is different, as it’s an answer to a problem IT has suffered for too long. In the ‘90s data warehouses and the resultant business insight were supposed to be the holy grail that would transform how we do business. However, the logistics of building and managing a data warehouse that worked were more complex than we had first hoped. So, the power of data resided with a few specialists, its extraction in any meaningful form was slow, and this created political struggles within organizations that disabled rather than enabled the majority.

In the beginning, on-premises data warehouses were hugely expensive and inhibited agility. Building a data warehouse took years and cost millions, meaning only the richest companies could afford one. We had to estimate how much storage and compute power we needed three years in advance. Buy too little and we ran out of space and lost the ability to do our job, buy too much and we wasted huge amounts of money on unused memory.

The Cloud changed this by allowing us to only pay for what we need. Now with increased security and trust, we are shifting more critical workloads on to the Cloud, but we can still often spend more money than is needed. While storage is cheap, compute power is expensive and often VMs sit unused, racking up huge bills, money that can now be spent on growing the business elsewhere. People often talk of the Cloud being expandable to grow with a company based on their needs, but its ability to contract so we only spend what we need to is equally, if not more, important.

The Snowflake Effect

Snowflake has separated storage and compute, and the bar has been raised again. As Snowflake’s VP of Product and Partner Marketing, Jon Bock, explains on this podcast, if we just want to drive to the shops and back, we don’t need to buy a Ferrari, but if we want to go for a long drive on the open road, it would be nice to rent one cheap. This means whole teams only have to pay for the specific amount of computing power each individual needs at the time they need it, while also allowing all team members to access and collaborate on a huge pool of shared storage data.

Snowflake is a Cloud native database. Whether you’re a Cloud native company or not, Snowflake enables you to take advantage of this latest technology and run like a digital native, only paying for the storage and compute you need at any time. When we heard about what they were doing, we knew it complemented our offering perfectly. WhereScape automation makes the design, development, deployment, and operation of data warehouses and other structures quicker and cheaper, so teams can deliver projects in hours and days, not months and years. Snowflake allows IT teams to spin up new data environments in the Cloud in seconds.

WhereScape® automation for Snowflake represents one of those shifts that disrupts the whole geology of IT, a seismic shift that answers the new holy grail of business requirements – doing more with less and delivering faster. It also makes the availability of cheap, efficient data warehouses possible to companies of all sizes, and takes them out of the hands of experts to democratize data in a way we haven’t yet experienced. It’s time to make dragons leap out of your wall.

This blog is based on an Inside Analysis podcast in which Snowflake VP of Product and Partner Marketing Jon Bock and WhereScape CEO Mark Budzinski discuss the potential of data warehouse automation for the Cloud. Click here to listen to the podcast.

New in 3D 9.0.6.1: The ‘Source Aware’ Release

When your sources shift beneath you, the fastest teams adapt at the metadata layer. WhereScape 3D 9.0.6.1 focuses on precisely that: making your modeling, conversion rules and catalog imports more aware of where data comes from and how it should be treated in-flight....

Data Vault on Snowflake: The What, Why & How?

Modern data teams need a warehouse design that embraces change. Data Vault, especially Data Vault 2.0, offers a way to integrate many sources rapidly while preserving history and auditability. Snowflake, with elastic compute and fully managed services, provides an...

Data Vault 2.0: What Changed and Why It Matters for Data Teams

Data Vault 2.0 emerged from years of production implementations, codifying the patterns that consistently delivered results. Dan Linstedt released the original Data Vault specification in 2000. The hub-link-satellite modeling approach solved a real problem: how do you...

Building an AI Data Warehouse: Using Automation to Scale

The AI data warehouse is emerging as the definitive foundation of modern data infrastructure. This is all driven by the rise of artificial intelligence. More and more organizations are rushing to make use of what AI can do. In a survey run by Hostinger, around 78% of...

Data Vault Modeling: Building Scalable, Auditable Data Warehouses

Data Vault modeling enables teams to manage large, rapidly changing data without compromising structure or performance. It combines normalized storage with dimensional access, often by building star or snowflake marts on top, supporting accurate lineage and audit...

Building a Data Warehouse: Steps, Architecture, and Automation

Building a data warehouse is one of the most meaningful steps teams can take to bring clarity and control to their data. It’s how raw, scattered information turns into something actionable — a single, trustworthy source of truth that drives reporting, analytics, and...

Shaping the Future of Higher Ed Data: WhereScape at EDUCAUSE 2025

October 27–30, 2025 | Nashville, TN | Booth #116 The EDUCAUSE Annual Conference is where higher education’s brightest minds come together to explore how technology can transform learning, streamline operations, and drive student success. This year, WhereScape is proud...

Data Foundation Guide: What It Is, Key Components and Benefits

A data foundation is a roadmap for how data from a variety of sources will be compiled, cleaned, governed, stored, and used. A strong data foundation ensures organizations get high-quality, consistent, usable, and accessible data to inform operational improvements and...

Related Content

New in 3D 9.0.6.1: The ‘Source Aware’ Release

New in 3D 9.0.6.1: The ‘Source Aware’ Release

When your sources shift beneath you, the fastest teams adapt at the metadata layer. WhereScape 3D 9.0.6.1 focuses on precisely that: making your modeling, conversion rules and catalog imports more aware of where data comes from and how it should be treated in-flight....

Data Vault on Snowflake: The What, Why & How?

Data Vault on Snowflake: The What, Why & How?

Modern data teams need a warehouse design that embraces change. Data Vault, especially Data Vault 2.0, offers a way to integrate many sources rapidly while preserving history and auditability. Snowflake, with elastic compute and fully managed services, provides an...