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

BigQuery vs Oracle Autonomous Data Warehouse comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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
Ranking in Cloud Data Warehouse
4th
Average Rating
8.2
Reviews Sentiment
7.3
Number of Reviews
40
Ranking in other categories
No ranking in other categories
Oracle Autonomous Data Ware...
Ranking in Cloud Data Warehouse
9th
Average Rating
8.6
Reviews Sentiment
7.3
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of January 2025, in the Cloud Data Warehouse category, the mindshare of BigQuery is 9.1%, up from 7.8% compared to the previous year. The mindshare of Oracle Autonomous Data Warehouse is 6.6%, up from 4.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Sathishkumar Jayaprakash - PeerSpot reviewer
Efficient large dataset handling with seamless service integration
BigQuery allows for very fast access, and it is efficient in handling large datasets compared to other SQL databases. It integrates well with other GCP products, and creating subscriptions in the UI is straightforward. The whole ecosystem of GCP products makes BigQuery beneficial for our data-handling tasks. Additionally, it is more cost-effective compared to alternatives like AWS.
Miodrag Milojevic - PeerSpot reviewer
A tool for data warehousing that offers scalability, stability, and ease of setup
The initial setup of Oracle Autonomous Data Warehouse is easy and basic, especially if one doesn't use the tricks to get Oracle Exadata for use. One doesn't need to know or be involved in technical stuff to do the setup since, at the least, knowledge might be required when working with some external connections, but it is easy because everything can be done within a couple of clicks. The solution is deployed on the cloud. For deployment, you don't need any technical guidance since you can sit, find it on the web, and prepare an Oracle Autonomous Data Warehouse platform by yourself for free for a limited time. The people needed for the deployment and maintenance depend on the implementation one wants. If you do a simple implementation, you don't need anybody for maintenance since everything is on the cloud. You only have to schedule your backup or see if Oracle can schedule a backup, and you don't take care of the backup. For some more sophisticated or technical implementations, you will need staff for some data warehouse except for some parts of the maintenance like backup, patches, or upgrades since these are a few things you take care of in the background, and you only seek help with the maintenance part, if needed.

Quotes from Members

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

Pros

"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"Its integration with other tools like Atlan through a Google Chrome extension is highly beneficial."
"The product’s most valuable feature is its ability to manage the database on the cloud."
"We like the machine learning features and the high-performance database engine."
"The integrated data storage features are good."
"The product is serverless. We only need to write SQL queries to analyze the data. We need to pay based on the number of queries. The retrieval time is very less. Even if you write large queries, the tool is able to bring back data in a few seconds."
"The most valuable aspect of BigQuery is its ability to handle high data workloads without causing friction with our online systems."
"BigQuery is a powerful tool for managing and analyzing large datasets. The versatility of BigQuery extends to its compatibility with external data visualization tools like Power BI and Tableau. This means you not only get query results but can also seamlessly integrate and visualize your data for better insights."
"The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup."
"The performance and scalability are awesome."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"A very good integration feature that restricts access to unauthorized people."
"Self-patching and runs machine-learning across its logs all the time"
"The product has self-repair features."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"It is a stable and scalable solution."
 

Cons

"The main challenges are in the areas of performance and cost optimizations."
"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."
"Instead of connecting directly to BigQuery, we connect to GCP, Cloud Run, and then to BigQuery, which is a long process."
"I would like to see version-based implementation and a fallback arrangement for data stored in BigQuery storage. These are some features I'm interested in."
"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."
"When I execute a query, the dashboard doesn't always present the output seamlessly. Troubleshooting requires opening each pipeline individually, which is time-consuming."
"The solution should reduce its pricing."
"We would like to be able to calibrate the solution to run on top of a raw file."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"The initial setup was pretty complex. It was not easy."
"The setup is complex."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"A lot of the tools that were previously there have now been taken away."
"They should make the solution more user-friendly."
 

Pricing and Cost Advice

"We are above the free threshold, so we are paying around 40 euros per month for BigQuery."
"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."
"BigQuery pricing can increase quickly. It's a high-priced solution."
"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 solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
"The price is a bit high but the technology is worth it."
"The pricing is adaptable, ensuring that organizations can tailor their usage and costs based on their specific requirements and configurations within the Google Cloud Platform."
"The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity."
"ROI is high."
"The solution is expensive."
"The price depends on the configuration we choose."
"The solution's cost is reasonable."
"You pay as you go, and you don't pay for services that you don't use."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"In terms of architecture and pricing structure, I feel it is a little bit costly compared to Azure. It's fine compared to RedShift, but compared to Azure, it's a bit pricey when you calculate for one TB storage plus around five hours of reporting with the frequency of 1TB data. The cost adds up, making Oracle a bit expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
831,881 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
14%
Manufacturing Company
12%
Retailer
7%
Educational Organization
52%
Financial Services Firm
7%
Computer Software Company
6%
Manufacturing Company
4%
 

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 execute a query, the dashboard doesn't always present the output seamlessly. Troubleshooting requires opening each pipeline individually, which is time-consuming. Moreover, pricing, the abse...
What do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
 

Overview

 

Sample Customers

Information Not Available
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Find out what your peers are saying about BigQuery vs. Oracle Autonomous Data Warehouse and other solutions. Updated: January 2025.
831,881 professionals have used our research since 2012.