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.
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.
"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."
"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."
"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."
"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."
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:
Snowflake has many valuable key features. Some of the most useful ones include:
There are many benefits to implementing Snowflake. Some of the biggest advantages the solution offers include:
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 has many valuable key benefits. Some of its most useful benefits include:
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
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.
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.