Blog | Data & Analytics

How WhereScape RED makes for a better Snowflake

With Snowflake Computing’s data warehouse in the cloud taking the world by storm, there’s some good news for businesses interested in the company’s technology: where data warehousing goes, WhereScape RED goes too.

That’s right, WhereScape RED is fully Snowflake-certified and delivers all the same benefits you’ve come to appreciate, including automated coding, documentation generation, and acceleration of the creation of the structures that underpin data analysis.

A closer look at Snowflake

First, let’s take a closer look at 
Snowflake. Essentially, it’s a purpose-designed data warehouse as a service which sits in the cloud. It’s a product with huge visibility, it is very innovative in that it is built in the cloud, for the cloud, and while it is hosted on Amazon Web Services or Microsoft Azure, users don’t need an AWS or Azure subscription to access it (in fact, where or on what it is hosted is of little consequence: like any other service, it merely has to reside somewhere.)

As an aside, Snowflake is headed by Bob Muglia…that’s right, of Microsoft Server and Tools fame. It’s also a legit unicorn, with an estimated US$3.5 billion valuation.

Worth examining is why Snowflake is such a big deal, even if only briefly. Where the magic lies is in the ‘cloud’ approach the company’s taken to the data warehouse (and at WhereScape, I might add, we’re fully sold on the value and benefits of cloud data warehousing). Sign up for a Snowflake account and you get your data warehouse, along with all the storage and compute and flexibility required. Snowflake manages everything. The sort of value proposition, in other words, which we’ve come to know and love from PaaS, but in this case for the data warehouse.

Speaking the same language

Now here’s the really interesting bit: the language of data is SQL and the language of Snowflake is SQL. The whole platform is built on that premise; in a world where the cool kids are talking Hadoop, noSQL and Java, Snowflake has gone with SQL and there’s a good 1.5 billion indicators proving the decision right. Note, though, that this doesn’t mean Hadoop is not relevant. It most certainly is (and indeed Snowflake relies on the Hadoop ecosystem, if not Hadoop itself). What it does confirm is that there are plenty of organisations which don’t need that level of complexity – and Snowflake can bring in semi-structured data like JPEGs, XML and so on, which for a lot of companies is all they need.

Where does WhereScape RED come in? Glad you asked.

The value proposition is essentially the same as it is for the creation of any data warehouse (or related structures) in that WhereScape RED accelerates the build and management of a Snowflake cloud data warehouse. In fact, we’re in a unique position right now as one of the few tools, and the only automation tool, that supports Snowflake.

Using WhereScape RED, you get the full set of ELT capabilities to ingest data into the Snowflake repository and then establish the structures necessary to prepare the data for analysis. As is usual with WhereScape RED, that means just about all the coding and documentation is automated, so your people get to work on ideas and analysis rather than wrestling with getting data into and organised on Snowflake.

We’ve also built some integration around Snowpipe, Snowflake’s data loading service, bringing best practice to data loading; in fact, with WhereScape RED, you get best practice for the entire Snowflake platform, with ease of creating and managing your data warehouse in the cloud.

What’s pretty remarkable is that since creating WhereScape automation for Snowflake, it’s become one of the fastest selling products we’ve ever done (there’s another confirmation of the enticing Snowflake value proposition: customers are flocking to it).

As such, if cloud data warehousing interests you, take the time to check out Snowflake – confident in the knowledge that the familiar environment of WhereScape RED is right there to accelerate value, too.

New call-to-action

Subscribe to the blog