![]() ![]() The true cost-savings come from the tighter infrastructure Snowflake can help you build. Of course, the price of data warehouses depends on a ton of factors, but overall ( according to our friends at Fivetran) Redshift and Snowflake will cost about the same. Snowflake Is Cheaper, but Not for the Reason You Might Think ![]() If you work in data, Snowflake just makes your life better. ![]() ”As you can guess, these quality-of-life improvements have made Snowflake their fair share of fan boys/girls, us included (can’t you tell?). One user on the r/bigdata subreddit described it like this when they first switched to Snowflake, “I was skeptical but actually does seem to make performance management easier and allows me more time to actually work with the data. We could go on and on here about specific features, but at its core, Snowflake takes care of the crap for you so you can actually do your job. It’s flat-out riskier and more stressful. And with Redshift, you need to work with production data (□) if you want to copy databases within your data structure. Redshift (and other traditional data warehouses) require that you go through the messy, insecure, and stressful process of managing multiple duplicate ETL (extract, transform, load) data pipelines. The alternative is the more traditional way of sharing data that Redshift represents. When you’re done, you just click “deprovisionize” and you’re good. Copying a database in a safe, secure way with Snowflake takes only one click, and it’s all self-contained. On a technical level, this simplicity is made possible by Snowflake’s unique ability to copy databases within your own data structure and then grant instant read access to those databases ( dive deeper into the documentation here if you want). It’s about as simple to share data with Snowflake as it is to share a Google Doc. One big way Snowflake makes your life easer as a data person is that it make sharing data super simple. Even if all other aspects, such as pricing or concurrency, were equal (and they aren’t), this alone should tip the scale for most. Snowflake has invested in quality-of-life features - like how easy it is to share data and the user experience - from the ground-up, while Redshift is still trying to catch up. Put simply, right now, Snowflake is better on almost all fronts and for most businesses than Amazon Redshift. Amazon Redshift is a huge legacy data warehousing product that, while powerful, doesn’t address these needs. Snowflake is a modern data-warehousing solution that’s built with the needs of today’s data teams in mind. In that line of thinking, you can think of Snowflake as Redshiftshift. Rumor has it that Redshift was named for its desire to shift people away from data warehousing offered by Oracle (whose brand used to be “red” ). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |