Cancel
You must select at least 2 products to compare!
Snowflake Computing Logo
39,602 views|28,518 comparisons
Micro Focus Logo
9,306 views|7,320 comparisons
Comparison Buyer's Guide
Executive Summary
Updated on Sep 6, 2022

We performed a comparison between Snowflake and Vertica based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.

  • Ease of Deployment: Snowflake users say the initial setup is straightforward and easy. While some Vertica reviewers report the initial setup to be straightforward, others feel that the setup can be complex and requires a higher level of technical expertise.

  • Features: Users of both products are happy with their speed, stability, and scalability.

    Snowflake users say it requires little maintenance, has powerful cloning tools, and is very user friendly. Several users mention that they would like more connectors.

    Vertica users say it is resilient and has excellent compression and data retrieval rates. Several users mention that the cloud version needs more third-party integration options.
  • Pricing: Most users of both solutions say that they are reasonably priced.

  • ROI: Users are satisfied with the ROI of both products.

  • Service and Support: Users of both solutions report being satisfied with the level of the support they receive.

Comparison Results: Vertica has an edge in this comparison due to its excellent performance. Snowflake does come out on top in the Ease of Deployment category, however.

To learn more, read our detailed Snowflake vs. Vertica Report (Updated: November 2022).
653,522 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"A user-friendly and reliable solution.""The speed of data loading and being able to quickly create the environment are most valuable.""Great scalability and near zero maintenance.""The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also.""The pricing is reasonable and matches the rest of the market.""Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost.""The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed.""Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."

More Snowflake Pros →

"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure.""Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful.""The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""I have found the solution to be scalable.""It's the fastest database I have ever tested. That's the most important feature of Vertica.""I enjoy the cybersecurity and backup features.""Allows us to take volumes and process them at a very high speed."

More Vertica Pros →

Cons
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions.""The data sharing capabilities across business units within the organization should be better.""There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services.""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.""I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users.""They should improve the reporting tools.""They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production.""There is room for improvement in Snowflake's integration with Python. We do a lot of SQL programming in Snowflake, but we go to a different tool to program when we have to in Python."

More Snowflake Cons →

"We faced some challenges when trying to use the temporary tables feature.""The biggest problem is the cost of cloud deployment.""I have found that coding support could be simplified.""I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them.""The integration of this solution with ODI could be improved.""Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.""They could improve the integration and some of the features in the cloud version.""In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."

More Vertica Cons →

Pricing and Cost Advice
  • "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."
  • "Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license."
  • "Snowflake goes by credits. For a financial institution where you have 5,000 employees, monthly costs may run up to maybe $5,000 to $6,000. This is actually based on the usage. It is mostly the compute cost. Your computing cost is the variable that is actually based on your usage. It is pay-per-use. In a pay-per-use case, you won't be spending more than $6,000 to $7,000 a month. It is not more than that for a small or medium enterprise, and it may come down to $100K per year. Storage is very standard, which is $23 a terabyte. It is not much for any enterprise. If you have even 20 terabytes, you are not spending more than $400 per month, which may turn out to be $2,000 to $3,000 per annum."
  • "It is on a monthly basis. It is based on your usage. There are no additional costs from the point of the licensing fee. We do give some kind of evaluation to the customers about how much it is going to be. You can decide in Snowflake the virtual machine that you are using for customers. There are several kinds of virtual machines that you can use. It is similar to the clothing sizes: small to extra large. If you need more power in the coming month, you can decide in advance and take a more powerful machine. You can just select it from the platform. You can also decide which machine you want to take for extracting data."
  • "They give a different price for every single company. I don't know if I negotiated that well, but we got the enterprise tier for $3 a credit, and the other two were a dollar-ninety a credit. I suspect we don't have almost zero compute usage, but I know that our annual contract packages are below all of their minimums."
  • More Snowflake Pricing and Cost Advice →

  • "It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
  • "The price could be cheaper and it is best to negotiate the price."
  • "The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
  • "The pricing could improve, it is a little expensive."
  • "The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
  • "The pricing for this solution is very reasonable compared to other vendors."
  • "The price of Vertica is less expensive than some competitors, such as Teradata."
  • More Vertica Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    653,522 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The most valuable feature is the clone copy.
    Top Answer:They have different pricing structures based on data usage. I think they have three or four tiers you can scale through. Most of the clients see an advantage from this type of licensing. That's the… more »
    Top Answer:In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to… more »
    Top Answer:The most valuable feature of Vertica is the unmatchable database performance.
    Top Answer:The price of Vertica is less expensive than some competitors, such as Teradata.
    Top Answer:Vertica can improve automation and documentation.
    Ranking
    1st
    Views
    39,602
    Comparisons
    28,518
    Reviews
    46
    Average Words per Review
    556
    Rating
    8.4
    5th
    Views
    9,306
    Comparisons
    7,320
    Reviews
    9
    Average Words per Review
    407
    Rating
    8.8
    Comparisons
    Also Known As
    Snowflake Computing
    Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
    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."

    Vertica is a deploy-anywhere SQL database created for elasticity, speed, and advanced analytics. Vertica enables today’s busy teams to modernize their data warehouses, democratize data and analytics to enable increased access, and deploy analytics in a hybrid cloud environment. Additionally, Vertica merges how companies power their analytics by providing a scalable, open, and elastic database with numerous intuitive features. 

    In today’s marketplace, organizations are experiencing continued robust growth of data volumes, and citizen data scientists’ broader use of analytics is causing many companies to re-visit and re-examine their systems in order to match the demands of an aggressive marketplace. Analytics are continually swiftly evolving. New data from social media, blogs, IoT sources, data streams, gas and electrical grids, and mobile networks is being constantly gathered in extensive data sets. This presents organizations with a new opportunity to become more data driven, and they must be able to manage the new data growth and identify the trends and sequences that can lead to both improved business opportunities and continued repeat business from their clients. 

    Vertica Benefits:

    Vertica has many valuable key benefits. Some of its most useful benefits include:

    • Efficiency:  Vertica provides robust compression and intuitive impressions. This results in users requiring significantly less storage and hardware than other comparable data analytics solutions. The progressive Vertica architecture results in queries that are 10-50 times faster than other platforms while providing more storage data per server.
    • Integration: Each new iteration of Vertica is tested and certified with the latest ETL and visualization tools. It actively supports Java Database Connectivity (JDBC), Open Database Connectivity (ODBC), and popular SQL providers. All these solutions and most leading BI and visualization tools interact seamlessly, making Vertica overall a very cost-effective solution and solid business investment.
    • Cloud flexibility: With Vertica, users do not have to get locked into a single cloud vendor. Users are able to take complete advantage of the current infrastructure that is already in place. Vertica seamlessly integrates with popular public clouds, including Google Cloud Platform (GCP), Azure, AWS, Alibaba, VMware clouds, and more. It also provides for easy portability across on-premise and multi-cloud environments and data lakes. Vertica designs a robust flexible platform for running a company’s analytical and computing workloads, which allows applications to run simultaneously on numerous environments in a hybrid cloud infrastructure. Vertica is able to seamlessly use public clouds and private data centers, and it grants the flexibility to switch in an instant.
    • Security: Vertica offers dynamic end-to-end security with support for partner solutions and industry-standard protocols such as Apache Sentry, AWS IAM, Kerberos, LDAP, and more. Vertica utilizes an intuitive layered security model that provides multiple security authentication authorization mechanisms. Vertica will also maintain an audit trail, natively exported to other security domains for analysis and persistence. 

    Reviews from Real Users

    “I am using Vertica for aggregations and dashboards. The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good.” - Bijal S., Group Chief Technology Officer at Netcore Solutions

    “The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money.” - Munkhsaikhan B.,  Project Lead - Digital Transformation Unit at Bodi Electronics LLC

    Offer
    Learn more about Snowflake
    Learn more about Vertica
    Sample Customers
    Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
    Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
    Top Industries
    REVIEWERS
    Computer Software Company37%
    Financial Services Firm16%
    Manufacturing Company8%
    Comms Service Provider5%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Financial Services Firm13%
    Comms Service Provider9%
    Insurance Company6%
    REVIEWERS
    Computer Software Company21%
    Media Company18%
    Marketing Services Firm15%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Comms Service Provider13%
    Financial Services Firm13%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business23%
    Midsize Enterprise21%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    REVIEWERS
    Small Business32%
    Midsize Enterprise26%
    Large Enterprise42%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise13%
    Large Enterprise71%
    Buyer's Guide
    Snowflake vs. Vertica
    November 2022
    Find out what your peers are saying about Snowflake vs. Vertica and other solutions. Updated: November 2022.
    653,522 professionals have used our research since 2012.

    Snowflake is ranked 1st in Cloud Data Warehouse with 50 reviews while Vertica is ranked 5th in Cloud Data Warehouse with 14 reviews. Snowflake is rated 8.4, while Vertica is rated 8.6. 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 Vertica writes "Enhanced capabilities, good customer service, large data scalability and stable". Snowflake is most compared with Microsoft Azure Synapse Analytics, Teradata, Amazon Redshift, Azure Data Factory and AWS Lake Formation, whereas Vertica is most compared with Teradata, Amazon Redshift, SQL Server, Oracle Exadata and Microsoft Azure Synapse Analytics. See our Snowflake vs. Vertica report.

    See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.

    We monitor all Cloud 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.