We performed a comparison between Snowflake Analytics and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It can run complex workloads with varied compute."
"The most valuable feature of Snowflake Analytics is the ability to control and manage the cost."
"Considering everything I have accessed, the product's dashboard is good since it provides multiple good options, including customization options."
"The advanced features like time travel, zero copy cloning and scalability have been most useful. Snowflake requires zero maintenance for Data Warehousing on the cloud system."
"It helps with business intelligence by providing analytics that can be reported."
"One of the key advancements in Snowflake Analytics is data sharing."
"Deployment is straightforward as it's a SaaS product. No maintenance required."
"Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"The extensibility and efficiency provided by their C++ SDK."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Machine learning in Snowflake isn't as advanced as in other products. I haven't heard of any successful industry-wide use cases of machine learning implemented in Snowflake. It might take a couple of years to reach the same level as Databricks."
"The UI could be more user-friendly."
"I cannot comment on the product's stability because we are still struggling with its performance."
"One area that could benefit from enhancement is the user interface for more visual ESM features."
"We haven't seen any areas that are lacking."
"The scheduling of jobs requires improvement, particularly in terms of the user interface which currently lacks certain features found in comparable platforms."
"The technical support is not very good."
"The distribution methodology isn't as strong as Bethesda or SAP HANA. It's not as strong as other competitors."
"I have found that coding support could be simplified."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"The integration of this solution with ODI could be improved."
"It would be great if this were a managed service in AWS."
"Suboptimal projection design causes queries to not scale linearly."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"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."
Snowflake Analytics is ranked 6th in Cloud Data Warehouse with 30 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. Snowflake Analytics is rated 8.4, while Vertica is rated 8.2. The top reviewer of Snowflake Analytics writes "A scalable tool useful for data lake and data mining processes". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our Snowflake Analytics vs. Vertica report.
See our list of best Cloud 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.