IT Central Station is now PeerSpot: Here's why

Snowflake vs VMware Tanzu Greenplum comparison

Cancel
You must select at least 2 products to compare!
Snowflake Computing Logo
38,560 views|28,984 comparisons
VMware Logo
4,520 views|3,200 comparisons
Featured Review
Buyer's Guide
Snowflake vs. VMware Tanzu Greenplum
May 2022
Find out what your peers are saying about Snowflake vs. VMware Tanzu Greenplum and other solutions. Updated: May 2022.
608,713 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well.""It was relatively easy to use, and it was easy for people to convert to it.""It is a very easy-to-use solution. It is user-friendly, and its setup time is very less.""The technical support is pretty good, particularly if you are a more technical user.""The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently.""Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution.""Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.""It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."

More Snowflake Pros →

"A very good, open-source platform.""The parallel load features mean that Greenplum is capable of high-volume data loading in parallel to all of the cluster segments, which is really valuable.""It's super easy to deploy and it also supports different languages and analytics."

More VMware Tanzu Greenplum Pros →

Cons
"The solution could use a little bit more UI.""It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud.""We would like to have an on-premises deployment option that has the same features, including scalability.""Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. It would be a huge advantage if you can write your stored procedures using SQL. It seems that they are working on this feature, and they are yet to release it. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues.""If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great.""There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful.""The documentation could improve. They should provide architecture information.""For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."

More Snowflake Cons →

"They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often.""Extra filters would be helpful.""The initial setup is somewhat complex and the out-of-the-box configuration requires optimization."

More VMware Tanzu Greenplum Cons →

Pricing and Cost Advice
  • "The pricing for Snowflake is competitive."
  • "On average, with the number of queries that we run, we pay approximately $200 USD per month."
  • "Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
  • "The price of Snowflake is very reasonable."
  • "The price of Snowflake is quite reasonable."
  • "Its price should be improved. It should be cheaper than Microsoft."
  • "It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
  • "We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue."
  • More Snowflake Pricing and Cost Advice →

    Information Not Available
    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    608,713 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere.
    Top Answer:The pricing is fair for all the features that Snowflake is providing. The way Snowflake has emerged in the past few years is impressive. It was just a beginner in the space, and it has become a leader… more »
    Top Answer:Sometimes when I'm trying to refresh the data, my different application or tool has to connect to its backend database through the connection I create. Sometimes, I face some issues like not having… more »
    Top Answer:We're using the open-source version so there are no licensing fees.
    Top Answer:I'd like to see more support for structured data and features related to queries on NoSQL keys, extra filters would be helpful.
    Ranking
    1st
    out of 30 in Data Warehouse
    Views
    38,560
    Comparisons
    28,984
    Reviews
    49
    Average Words per Review
    566
    Rating
    8.4
    9th
    out of 30 in Data Warehouse
    Views
    4,520
    Comparisons
    3,200
    Reviews
    3
    Average Words per Review
    421
    Rating
    9.0
    Comparisons
    Also Known As
    Snowflake Computing
    Greenplum, Pivotal Greenplum
    Learn More
    Overview

    Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data.

    Its platform is made up of three components:

    1. Cloud services: As part of its cloud services, Snowflake uses ANSI SQL, which empowers users to optimize their data and manage their infrastructure, while Snowflake handles the security and encryption of stored data.
    1. Query processing: With Snowflake, workload concurrency is never a problem because its compute layer is made up of virtual cloud data warehouses that let you analyze data through requests. Each of the warehouses do not compete for computing resources nor do they affect the performance of each other.
    1. Database storage: Snowflake manages all parts of the data storage process automatically, including file size, compression, organization, structure, and metadata, as well as statistics.

    Snowflake Features

    Snowflake has many valuable key features. Some of the most useful ones include:

    • Scalability: Snowflake architecture provides nearly unlimited scalability and high speed because it uses a single elastic performance engine. The solution also supports an unlimited amount of concurrent users and workloads, from interactive to batch.
    • Automation: Snowflake makes automation easy and enables enterprises to automate data management, security, governance, availability, and data resiliency.
    • Seamless cross-cloud and cross-region connections: With seamless cross-cloud and cross-region connections, Snowflake eliminates ETL and data silos. Anyone who needs access to shared secure data can get a single copy via the data cloud. In addition, Snowflake makes remote collaboration and decision-making fast and easy via a single shared data source.
    • Third-party data integrations: Snowflake’s Data Marketplace offers third-party data which allows you to connect with Snowflake customers to extend workflows with data services and third-party applications.

    Snowflake Benefits

    There are many benefits to implementing Snowflake. Some of the biggest advantages the solution offers include:

    • Helps optimize costs
    • Reduces downtime
    • Improves operational efficiency
    • Built for high reliability and availability
    • Automates data replication for fast recovery

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Snowflake solution.

    Sreenivasan R., Director of Data Architecture and Engineering at Decision Minds, says, "Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."

    A director of business operations at a logistics company mentions, "It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."

    A Solution Architect at a wholesaler/distributor comments, "The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."

    Parallel Postgres for enterprise analytics at scale
    With improved transaction processing capability and support for streaming ingest, Greenplum can address workloads across a spectrum of analytic and operational contexts, from traditional business intelligence to deep learning.

    Offer
    Learn more about Snowflake
    Learn more about VMware Tanzu Greenplum
    Sample Customers
    Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
    General Electric, Conversant, China CITIC Bank, Aridhia, Purdue University
    Top Industries
    REVIEWERS
    Computer Software Company39%
    Financial Services Firm12%
    Manufacturing Company9%
    Comms Service Provider6%
    VISITORS READING REVIEWS
    Computer Software Company26%
    Comms Service Provider13%
    Financial Services Firm10%
    Insurance Company6%
    REVIEWERS
    Financial Services Firm50%
    Comms Service Provider15%
    Marketing Services Firm15%
    Retailer10%
    VISITORS READING REVIEWS
    Computer Software Company31%
    Comms Service Provider18%
    Financial Services Firm12%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business24%
    Midsize Enterprise23%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise70%
    REVIEWERS
    Small Business20%
    Midsize Enterprise17%
    Large Enterprise63%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise12%
    Large Enterprise73%
    Buyer's Guide
    Snowflake vs. VMware Tanzu Greenplum
    May 2022
    Find out what your peers are saying about Snowflake vs. VMware Tanzu Greenplum and other solutions. Updated: May 2022.
    608,713 professionals have used our research since 2012.

    Snowflake is ranked 1st in Data Warehouse with 49 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 3 reviews. Snowflake is rated 8.4, while VMware Tanzu Greenplum is rated 9.0. The top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". On the other hand, the top reviewer of VMware Tanzu Greenplum writes "Powerful external data integration and parallel load capabilities, with good technical support". Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Vertica, AWS Lake Formation and Firebolt, whereas VMware Tanzu Greenplum is most compared with Apache Hadoop, Oracle Exadata, Amazon Redshift, Oracle Database Appliance and Teradata. See our Snowflake vs. VMware Tanzu Greenplum report.

    See our list of best Data Warehouse vendors.

    We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.