Try our new research platform with insights from 80,000+ expert users

BigQuery vs Oracle Big Data Appliance comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

BigQuery
Average Rating
8.2
Reviews Sentiment
7.3
Number of Reviews
40
Ranking in other categories
Cloud Data Warehouse (4th)
Oracle Big Data Appliance
Average Rating
8.0
Reviews Sentiment
7.5
Number of Reviews
5
Ranking in other categories
Data Warehouse (19th)
 

Featured Reviews

VikashKumar1 - PeerSpot reviewer
Easy to maintain and provides high availability
Since I used BigQuery over the GCP cloud environment, I'm not sure whether we can go through internal IDEAs like IntelliJ or DBeaver that we use to connect with databases. Instead of connecting directly to BigQuery, we connect to GCP, Cloud Run, and then to BigQuery, which is a long process. Sometimes, we face some issues, bugs, and defects. We must first connect with a VPN to check data issues while working from home. Then, it allows you to connect to the cloud. After logging into the cloud, it searches for the service we are looking for, and then we go to BigQuery. This is a long process. After that, we analyze the issues in a table. Instead, it would be very helpful if it could provide a tool that we can install on our MacBook or Windows system. Once we open this tool, we can connect directly to the BigQuery server and easily perform tasks.
Mohammed Hamad - PeerSpot reviewer
Provides clean, centralized data
From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera. Oracle could also improve Big Data Appliance by having one technology on their stack and working on it instead of continually changing the name or technologies or features. In addition, they could have a program to enable their partners to use this technology because right now, I have to have an expert to use the AI elements.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"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."
"BigQuery processes a substantial amount of data, whether in gigabytes or terabytes, swiftly producing desired data within one or two minutes."
"The product's most valuable features include its scalability and the ability to handle complex queries on large datasets."
"Even non-coders can review the data in BigQuery."
"It has a well-structured suite of complimentary tools for data integration and so forth."
"The most valuable aspect of BigQuery is its ability to handle high data workloads without causing friction with our online systems."
"Its integration with other tools like Atlan through a Google Chrome extension is highly beneficial."
"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"This is a comprehensive solution that is easy to deploy."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
 

Cons

"BigQuery should integrate with other tools, such as Cloud Logging and Local Studio, to enhance its capabilities further and enable powerful and innovative analyses."
"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."
"There is a good amount of documentation out there, but they're consistently making changes to the platform, and, like, their literature hasn't been updated on some plans."
"When it comes to queries or the code being executed in the data warehouse, the management of this code, like integration with the GitHub repository or the GitLab repository, is kind of complicated, and it's not so direct."
"It would be beneficial to integrate additional tools, particularly from a business intelligence perspective."
"I noticed recently it's more expensive now."
"The process of migrating from Datastore to BigQuery should be improved."
"They could enhance the platform's user accessibility."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"The product should be simplified for the average user."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
 

Pricing and Cost Advice

"BigQuery pricing can increase quickly. It's a high-priced solution."
"Its cost structure operates on a pay-as-you-go model."
"One terabyte of data costs $20 to $22 per month for storage on BigQuery and $25 on Snowflake. Snowflake is costlier for one terabyte, but BigQuery charges based on how much data is inserted into the tables. BigQuery charges you based on the amount of data that you handle and not the time in which you handle it. This is why the pricing models are different and it becomes a key consideration in the decision of which platform to use."
"The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity."
"BigQuery is inexpensive."
"The product’s pricing could be more flexible for end users."
"1 TB is free of cost monthly. If you use more than 1 TB a month, then you need to pay 5 dollars extra for each TB."
"The platform is inexpensive."
"Oracle's prices are too high compared to others in the market."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
850,028 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
17%
Financial Services Firm
15%
Manufacturing Company
11%
Retailer
8%
Financial Services Firm
32%
Computer Software Company
15%
Government
11%
University
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about BigQuery?
The initial setup process is easy.
What is your experience regarding pricing and costs for BigQuery?
The price is perceived as expensive, rated at eight out of ten in terms of costliness. Still, it offers significant cost savings.
What needs improvement with BigQuery?
When I open many of the Google Cloud products, I am in an environment that I do not feel familiar with; it is a little overwhelming. In general, if I know SQL and start playing around, it will star...
Ask a question
Earn 20 points
 

Overview

 

Sample Customers

Information Not Available
Caixa Bank
Find out what your peers are saying about BigQuery vs. Oracle Big Data Appliance and other solutions. Updated: April 2025.
850,028 professionals have used our research since 2012.