We performed a comparison between BigQuery 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."BigQuery can be used for any type of company. It has the capability of building applications and storing data. It can be used for OLTP or OLAP. It has many other products within the Google space."
"The query tool is scalable and allows for petabytes of data."
"It's similar to a Hadoop cluster, except it's managed by Google."
"It has a proprietary way of storing and accessing data in its own data store and is 100% managed without you needing to install anything. There is no need to arrange for any infrastructure to be able to use this solution."
"There are some performance features like partitioning, which you can do based on an integer, and it improves the performance a lot."
"We basically used it to store server data and generate reports for enterprise architects. It was a valuable tool for our enterprise design architect."
"When integrating their system into the cloud-based solutions, we were able to increase their efficiency and overall productivity twice compared with their on-premises option."
"One of the most significant advantages lies in the decoupling of storage and compute which allows to independently scale storage and compute resources, with the added benefit of extremely cost-effective storage akin to object storage solutions."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"The most valuable feature of Vertica is the unmatchable database performance."
"Speed and resiliency are probably the best parts of this product."
"I like the projection feature, which increases query performance."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"It has improved my organization's functionality and performance."
"The main challenges are in the areas of performance and cost optimizations."
"There are many tools that you have to use with BigQuery that are different services also provided for by Google. They need to all be integrated into BigQuery to make the solution easier to use."
"Some of the queries are complex and difficult to understand."
"I noticed recently it's more expensive now."
"The process of migrating from Datastore to BigQuery should be improved."
"The solution hinges on Google patterns so continued improvement is important."
"The price could be better. Compared to competing solutions, BigQuery is expensive. It's only suitable for enterprise customers, not small and medium-sized businesses, as they cannot afford this kind of solution. In the next release, it would be better if they improved their AI bot. Although machine learning and artificial intelligence are doing wonders, there is still a lot of room to enhance them."
"The solution should reduce its pricing."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"It needs integration with multiple clouds."
"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."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. BigQuery is rated 8.2, while Vertica is rated 8.2. The top reviewer of BigQuery writes "Expandable and easy to set up but needs more local data residency". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse, Apache Hadoop and AWS Lake Formation, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Database. See our BigQuery 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.
