Introducing G2.ai, the future of software buying.Try now
Compare Google Cloud BigQuery and OpenText Vertica 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Alteryx
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Adcredo
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
At a Glance
Market Segments
Enterprise (38.1% of reviews)
Enterprise (44.6% of reviews)
Entry-Level Pricing
Free
Free
Google Cloud BigQuery
Star Rating
(1,201)4.5 out of 5
Market Segments
Enterprise (38.1% of reviews)
Pros & Cons
Entry-Level Pricing
Free
Free Trial is available
Browse all 5 pricing plansOpenText Vertica
Star Rating
(216)4.3 out of 5
Market Segments
Enterprise (44.6% of reviews)
Pros & Cons
Not enough data
Entry-Level Pricing
Free
Browse all 4 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that OpenText Vertica excels in data compression with a score of 8.5, allowing for efficient storage and retrieval of large datasets, while Google Cloud BigQuery, with a score of 8.3, is noted for its ease of use in managing data but may not compress data as effectively.
- Reviewers mention that Google Cloud BigQuery shines in data integration, scoring 9.0, which facilitates seamless connections with various data sources, whereas OpenText Vertica, with a score of 8.4, is seen as slightly less versatile in this area.
- G2 users highlight that OpenText Vertica's in-database machine learning feature, scoring 7.9, is beneficial for users looking to perform advanced analytics directly within the database, while Google Cloud BigQuery's score of 8.3 indicates a more robust offering in this category, making it a better choice for machine learning applications.
- Users on G2 report that Google Cloud BigQuery's cloud deployment model, scoring 9.1, provides superior scalability and flexibility compared to OpenText Vertica's on-premise deployment score of 7.9, which may limit scalability for some users.
- Reviewers mention that OpenText Vertica's performance in real-time analytics, scoring 8.8, is a strong point, allowing for timely insights, while Google Cloud BigQuery matches this score but is often praised for its faster query performance in large datasets.
- Users say that Google Cloud BigQuery's data security features, with a score of 9.1, are highly regarded, particularly its encryption capabilities, while OpenText Vertica's score of 8.5 indicates solid security but may not offer the same level of advanced features as BigQuery.
Pricing
Entry-Level Pricing
Google Cloud BigQuery
Free
Free
New customers get $300 in free Google Cloud credits to spend on BigQuery with free trial sign-up.
- 10 GB storage
- Up to 1 TB queries per month
OpenText Vertica
Vertica Community Edition
Free
Free to use for up to 1TB and three nodes
- https://www.vertica.com/register/
Free Trial
Google Cloud BigQuery
Free Trial is available
OpenText Vertica
Free Trial is available
Ratings
Meets Requirements
8.8
612
8.6
147
Ease of Use
8.7
626
8.5
148
Ease of Setup
8.8
401
8.1
84
Ease of Admin
8.5
224
8.3
89
Quality of Support
8.4
564
8.1
146
Has the product been a good partner in doing business?
8.7
217
8.3
87
Product Direction (% positive)
9.2
600
8.0
143
Features by Category
Management
8.6
123
Not enough data
8.3
121
Not enough data
Functionality
9.0
121
Not enough data
9.1
124
Not enough data
9.0
124
Not enough data
8.9
123
Not enough data
9.4
124
Not enough data
Data Management
8.9
223
|
Verified
8.4
71
|
Verified
8.3
214
|
Verified
8.5
72
|
Verified
8.9
219
|
Verified
8.6
73
8.6
215
|
Verified
8.5
66
|
Verified
8.3
204
|
Verified
7.9
43
|
Verified
8.7
205
|
Verified
8.4
49
|
Verified
Integration
8.6
204
|
Verified
7.7
43
|
Verified
8.6
216
|
Verified
8.4
65
|
Verified
8.6
204
|
Verified
8.2
50
|
Verified
Deployment
7.8
190
|
Verified
8.3
66
|
Verified
9.1
215
|
Verified
7.9
51
|
Verified
Performance
9.1
220
|
Verified
8.3
71
|
Verified
Security
8.7
211
|
Verified
8.3
66
|
Verified
9.2
217
|
Verified
8.5
67
|
Verified
Generative AI
7.7
132
8.3
8
7.9
129
7.9
8
Storage
9.1
70
8.4
22
8.8
70
8.0
22
Availability
8.4
62
8.4
20
8.5
66
8.2
22
8.6
68
8.6
22
Performance
8.5
65
8.5
21
Security
8.7
70
8.4
22
8.8
69
8.6
22
8.4
69
8.2
19
8.7
65
8.2
21
Support
8.7
66
8.4
15
8.9
66
8.3
17
Centralized computation
9.1
27
Not enough data
Localized computation
8.5
28
Not enough data
Statistical Tool
8.7
78
Not enough data
9.0
79
Not enough data
8.8
79
Not enough data
Data Analysis
9.3
78
Not enough data
9.1
79
Not enough data
Decision Making
8.8
80
Not enough data
8.7
78
Not enough data
8.7
80
Not enough data
8.7
78
Not enough data
Generative AI
7.5
51
Not enough data
7.8
51
Not enough data
Marketing Operations
8.8
66
Not enough data
9.2
64
Not enough data
8.9
65
Not enough data
9.4
66
Not enough data
8.8
63
Not enough data
8.5
63
Not enough data
Campaign Activity
9.1
68
Not enough data
9.5
67
Not enough data
8.7
64
Not enough data
9.2
62
Not enough data
8.9
63
Not enough data
9.1
65
Not enough data
Agentic AI - Marketing Analytics
8.8
16
Not enough data
9.6
16
Not enough data
8.3
16
Not enough data
Database
8.8
178
8.6
48
8.9
176
8.7
47
8.8
170
8.6
47
Integrations
8.4
139
8.4
41
8.6
136
8.1
39
Platform
8.9
153
8.3
37
8.9
168
8.4
44
8.6
136
8.1
39
Processing
9.3
170
8.3
41
9.1
164
8.7
46
Data Transformation
8.8
288
Not enough data
9.3
295
Not enough data
Connectivity
8.1
256
Not enough data
8.2
254
Not enough data
8.7
283
Not enough data
8.8
274
Not enough data
Operations
8.5
283
Not enough data
8.7
282
Not enough data
8.3
260
Not enough data
8.4
267
Not enough data
8.5
259
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Google Cloud BigQuery and OpenText Vertica are categorized as Columnar Databases, Big Data Processing and Distribution, and Data Warehouse
Unique Categories
Google Cloud BigQuery is categorized as Big Data Integration Platforms, ETL Tools, Big Data Analytics, Marketing Analytics, Predictive Analytics, and Data Clean Room
OpenText Vertica has no unique categories
Reviews
Reviewers' Company Size
Google Cloud BigQuery
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
OpenText Vertica
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
16.2%
Computer Software
13.5%
Retail
7.1%
Financial Services
6.5%
Marketing and Advertising
5.1%
Other
51.7%
Computer Software
19.0%
Information Technology and Services
17.4%
Financial Services
6.7%
Telecommunications
5.6%
Retail
5.6%
Other
45.6%
Alternatives
Discussions
Is Big Query free?
3 Comments
BG
noRead more
Is BigQuery part of Google Cloud Platform?
2 Comments
AY
Yes, Bigquery is a GCP product and a serveless data wharehouse.Read more
How BQ legacy SQl is different form the standard SQL?
1 Comment
OD
Legacy SQL is a non-standard SQL only used by BigQuery. Standard SQL is compliant with the SQL 2011.
Google recommends using Standard SQL and looking at the...Read more
Who uses Vertica and for what?
2 Comments
PR
A LOT of companies, from tiny startups to the biggest data companies.
7 of top 10 telecoms in world, including AT&T, plus companies like Anritsu that sell...Read more
Is it hard to learn to be a Vertica user? Admin?
2 Comments
PR
Also, check out the Vertica Academy: https://academy.vertica.com/ Free classes to learn how to admin Vertica, including certification. Read more
What’s the best use case for Vertica?
1 Comment
MG
For Finance: Fraud detection, Anti-money laundering, Risk management
For Government: Law enforcement, Counter terrorism, Traffic flow optimization
For...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
