Compare Google Cloud BigQuery and OpenText Vertica 
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,224)4.5 out of 5
Market Segments
Enterprise (38.1% of reviews)
Pros & Cons
Entry-Level Pricing
Free
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.
- G2 reviewers report that Google Cloud BigQuery excels in user experience, with many praising its serverless architecture that allows users to focus on SQL without worrying about infrastructure. This makes data analysis feel smoother and more efficient, especially for those handling large datasets.
- Users say OpenText Vertica is particularly strong in handling big data analytics, with capabilities to process millions of rows in real-time. Reviewers highlight its flexibility in managing complex queries and integrating multiple data sources, making it a solid choice for organizations with heavy data processing needs.
- According to verified reviews, Google Cloud BigQuery's pay-as-you-go model simplifies operations, allowing users to experiment with larger datasets without the need for upfront provisioning. This feature is especially beneficial for teams looking to scale their data operations efficiently.
- Reviewers mention that while OpenText Vertica is effective for large data sets, some users have encountered challenges with configuration and setup. This can lead to a steeper learning curve compared to BigQuery, which is often noted for its intuitive onboarding process.
- G2 reviewers highlight that Google Cloud BigQuery consistently receives high marks for its speed and efficiency, with users noting its ability to handle billions of queries seamlessly. This performance advantage makes it a preferred choice for businesses that require rapid data insights.
- Users report that OpenText Vertica's strength lies in its data lake integration and the ability to add more clusters, which enhances its data analytics capabilities. However, it still trails behind BigQuery in overall user satisfaction, as reflected in the significant difference in G2 Scores.
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
626
8.6
147
Ease of Use
8.7
642
8.5
148
Ease of Setup
8.7
416
8.1
84
Ease of Admin
8.5
227
8.3
89
Quality of Support
8.3
573
8.1
146
Has the product been a good partner in doing business?
8.6
220
8.3
87
Product Direction (% positive)
9.3
614
8.0
143
Features by Category
Management
8.6
121
Not enough data
8.3
119
Not enough data
Functionality
9.0
119
Not enough data
9.1
123
Not enough data
9.0
123
Not enough data
8.9
122
Not enough data
9.3
122
Not enough data
Data Management
8.9
224
|
Verified
8.4
71
|
Verified
8.3
210
|
Verified
8.5
72
|
Verified
8.9
215
|
Verified
8.6
73
8.6
219
|
Verified
8.5
66
|
Verified
8.3
204
|
Verified
7.9
43
|
Verified
8.6
201
|
Verified
8.4
49
|
Verified
Integration
8.5
202
|
Verified
7.7
43
|
Verified
8.6
214
|
Verified
8.4
65
|
Verified
8.6
201
|
Verified
8.2
50
|
Verified
Deployment
7.7
186
|
Verified
8.3
66
|
Verified
9.1
223
|
Verified
7.9
51
|
Verified
Performance
9.1
233
|
Verified
8.3
71
|
Verified
Security
8.7
208
|
Verified
8.3
66
|
Verified
9.2
214
|
Verified
8.5
67
|
Verified
Generative AI
7.6
127
8.3
8
7.8
124
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
78
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
79
Not enough data
8.7
77
Not enough data
8.7
79
Not enough data
8.7
77
Not enough data
Generative AI
7.5
50
Not enough data
7.8
50
Not enough data
Marketing Operations
8.8
65
Not enough data
9.2
64
Not enough data
8.9
64
Not enough data
9.4
65
Not enough data
8.8
63
Not enough data
8.4
62
Not enough data
Campaign Activity
9.1
67
Not enough data
9.5
67
Not enough data
8.7
64
Not enough data
9.2
61
Not enough data
8.9
62
Not enough data
9.0
64
Not enough data
Agentic AI - Marketing Analytics
8.7
15
Not enough data
9.6
15
Not enough data
8.2
15
Not enough data
Database
8.8
175
8.6
48
8.9
173
8.7
47
8.7
167
8.6
47
Integrations
8.4
136
8.4
41
8.5
133
8.1
39
Platform
8.9
151
8.3
37
8.9
165
8.4
44
8.5
133
8.1
39
Processing
9.2
168
8.3
41
9.1
161
8.7
46
Data Transformation
8.8
283
Not enough data
9.3
293
Not enough data
Connectivity
8.1
251
Not enough data
8.2
249
Not enough data
8.7
278
Not enough data
8.7
269
Not enough data
Operations
8.5
279
Not enough data
8.7
277
Not enough data
8.3
255
Not enough data
8.4
262
Not enough data
8.5
254
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.1%
Computer Software
13.5%
Retail
7.0%
Financial Services
6.5%
Marketing and Advertising
5.2%
Other
51.7%
Computer Software
19.0%
Information Technology and Services
17.4%
Financial Services
6.7%
Hospital & Health Care
5.6%
Marketing and Advertising
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.
