Cloudera Data Platform vs. Google BigQuery

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Cloudera Data Platform
Score 6.5 out of 10
N/A
Cloudera Data Platform (CDP), launched September 2019, is designed to combine the best of Hortonworks and Cloudera technologies to deliver an enterprise data cloud. CDP includes the Cloudera Data Warehouse and machine learning services as well as a Data Hub service for building custom business applications.
$0.04
per CCU (hourly rate)
Google BigQuery
Score 8.5 out of 10
N/A
Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
$0.04
Pricing
Cloudera Data PlatformGoogle BigQuery
Editions & Modules
CDP Public Cloud - Data Hub
$0.04
per CCU (hourly rate)
CDP Public Cloud - Data Warehouse
$0.054
per CCU (hourly rate)
CDP Public Cloud - Data Engineering
$0.07
per CCU (hourly rate)
CDP Public Cloud - Operational Database
$0.08
per CCU (hourly rate)
CDP Public Cloud - Flow Management
$0.15
per CCU (hourly rate)
CDP Public Cloud - Machine Learning
$0.17
per CCU (hourly rate)
CDP Private Cloud - Plus Edition
$400
CCU (annual subscription)
CDP Private Cloud - Base Edition
$10,000.00
node + variable (annual subscription)
Standard edition
$0.04 / slot hour
Enterprise edition
$0.06 / slot hour
Enterprise Plus edition
$0.10 / slot hour
Offerings
Pricing Offerings
Cloudera Data PlatformGoogle BigQuery
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Cloudera Data PlatformGoogle BigQuery
Features
Cloudera Data PlatformGoogle BigQuery
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Cloudera Data Platform
-
Ratings
Google BigQuery
8.4
Ratings
3% below category average
Automatic software patching00 Ratings8.00 Ratings
Database scalability00 Ratings9.20 Ratings
Automated backups00 Ratings8.50 Ratings
Database security provisions00 Ratings8.60 Ratings
Monitoring and metrics00 Ratings8.00 Ratings
Automatic host deployment00 Ratings8.00 Ratings
Best Alternatives
Cloudera Data PlatformGoogle BigQuery
Small Businesses
Google BigQuery
Google BigQuery
Score 8.5 out of 10
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Medium-sized Companies
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Enterprises
Oracle Exadata
Oracle Exadata
Score 10.0 out of 10
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Cloudera Data PlatformGoogle BigQuery
Likelihood to Recommend
7.0
(0 ratings)
8.6
(0 ratings)
Likelihood to Renew
-
(0 ratings)
8.1
(0 ratings)
Usability
-
(0 ratings)
7.7
(0 ratings)
Support Rating
8.0
(0 ratings)
7.3
(0 ratings)
User Testimonials
Cloudera Data PlatformGoogle BigQuery
Likelihood to Recommend
I have seen that Cloudera Data Platform is well suited for large batch processes. It works really well for our indication analyses that are performed by the actuaries. I feel that rapid streaming operations may be a situation where additional technology would be needed to provide for a robust solution.
Read full review
Google BigQuery is great for being the central datastore and entry point of data if you're on GCP. It seamlessly integrates with other Google products, meaning you can ingest data from other Google products with ease and little technical knowledge, and all of it is near real-time. Being serverless, BigQuery will scale with you, which means you don't have to worry about contention or spikes in demand/storage. This can, however, mean your costs can run away quickly or mount up at short notice.
Read full review
Pros
  • Scales
  • Highly available
Read full review
  • Its serverless architecture and underlying Dremel technology are incredibly fast even on complex datasets. I can get answers to my questions almost instantly, without waiting hours for traditional data warehouses to churn through the data.
  • Previously, our data was scattered across various databases and spreadsheets and getting a holistic view was pretty difficult. Google BigQuery acts as a central repository and consolidates everything in one place to join data sets and find hidden patterns.
  • Running reports on our old systems used to take forever. Google BigQuery's crazy fast query speed lets us get insights from massive datasets in seconds.
Read full review
Cons
  • Constantly changing costs
  • Log visibility
Read full review
  • It is challenging to predict costs due to BigQuery's pay-per-query pricing model. User-friendly cost estimation tools, along with improved budget alerting features, could help users better manage and predict expenses.
  • The BigQuery interface is less intuitive. A more user-friendly interface, enhanced documentation, and built-in tutorial systems could make BigQuery more accessible to a broader audience.
Read full review
Likelihood to Renew
No answers on this topic
We have to use this product as its a 3rd party supplier choice to utilise this product for their data side backend so will not be likely we will move away from this product in the future unless the 3rd party supplier decides to change data vendors.
Read full review
Usability
No answers on this topic
web UI is easy and convenient. Many RDBMS clients such as aqua data studio, Dbeaver data grid, and others connect. Range of well-documented APIs available. The range of features keeps expanding, increasing similar features to traditional RDBMS such as Oracle and DB2
Read full review
Reliability and Availability
No answers on this topic
I have never had any significant issues with Google Big Query. It always seems to be up and running properly when I need it. I cannot recall any times where I received any kind of application errors or unplanned outages. If there were any they were resolved quickly by my IT team so I didn't notice them.
Read full review
Performance
No answers on this topic
I think Google Big Query's performance is in the acceptable range. Sometimes larger datasets are somewhat sluggish to load but for most of our applications it performs at a reasonable speed. We do have some reports that include a lot of complex calculations and others that run on granular store level data that so sometimes take a bit longer to load which can be frustrating.
Read full review
Support Rating
We have utilized Cloudera support quite frequently and are very satisfied with the capability and responsiveness of that team. Often, the new features delivered with the platform give us an opportunity to mature the way we're doing things, and the support team have been valuable in developing those new patterns.
Read full review
BigQuery can be difficult to support because it is so solid as a product. Many of the issues you will see are related to your own data sets, however you may see issues importing data and managing jobs. If this occurs, it can be a challenge to get to speak to the correct person who can help you.
Read full review
Alternatives Considered
IBM's offering of the Cloud Pak for Data has been a moving target and difficult to compare to Cloudera Data Platform. We have implemented our solution on Amazon Web Services, which appears to be supported by IBM at this point, but the migration would be very expensive for us to endeavor.
Read full review
Google BigQuery of course collects a much much larger array of raw data and can handle (practically) an unlimited amount of data. For a large enterprise like ours that relies on large-scale analytics, this is absolutely imperative. Google BigQuery can also combine GA4 data with external sources (like CRM tools), so our analytics can be unified. Due to our heavy reliance on GA4, Google BigQuery is the natural choice since it is a Google product and has better integration.
Read full review
Scalability
No answers on this topic
We have continued to expand out use of Google Big Query over the years. I'd say its flexibility and scalability is actually quite good. It also integrates well with other tools like Tableau and Power BI. It has served the needs of multiple data sources across multiple departments within my company.
Read full review
Return on Investment
  • Reduced operational costs
  • Speed to market
Read full review
  • In some places, Google BigQuery has helped us save some money by avoiding the need for expensive infrastructure and reducing some of the operational costs.
  • Scalability is up-to-date and really helpful in multiple places.
  • Knowledge transfer is easy as it is very user-friendly, so the learning curve has been reduced.
  • Also, it gives us more insights from our data, helping us make smarter decisions for our business.
Read full review
ScreenShots

Google BigQuery Screenshots

Screenshot of Migrating data warehouses to BigQuery - Features a streamlined migration path from Netezza, Oracle, Redshift, Teradata, or Snowflake to BigQuery using the fully managed BigQuery Migration Service.Screenshot of bringing any data into BigQuery - Data files can be uploaded from local sources, Google Drive, or Cloud Storage buckets, using BigQuery Data Transfer Service (DTS), Cloud Data Fusion plugins, by replicating data from relational databases with Datastream for BigQuery, or by leveraging Google's data integration partnerships.Screenshot of generative AI use cases with BigQuery and Gemini models - Data pipelines that blend structured data, unstructured data and generative AI models together can be built to create a new class of analytical applications. BigQuery integrates with Gemini 1.0 Pro using Vertex AI. The Gemini 1.0 Pro model is designed for higher input/output scale and better result quality across a wide range of tasks like text summarization and sentiment analysis. It can be accessed using simple SQL statements or BigQuery’s embedded DataFrame API from right inside the BigQuery console.Screenshot of insights derived from images, documents, and audio files, combined with structured data - Unstructured data represents a large portion of untapped enterprise data. However, it can be challenging to interpret, making it difficult to extract meaningful insights from it. Leveraging the power of BigLake, users can derive insights from images, documents, and audio files using a broad range of AI models including Vertex AI’s vision, document processing, and speech-to-text APIs, open-source TensorFlow Hub models, or custom models.Screenshot of event-driven analysis - Built-in streaming capabilities automatically ingest streaming data and make it immediately available to query. This allows users to make business decisions based on the freshest data. Or Dataflow can be used to enable simplified streaming data pipelines.Screenshot of predicting business outcomes AI/ML - Predictive analytics can be used to streamline operations, boost revenue, and mitigate risk. BigQuery ML democratizes the use of ML by empowering data analysts to build and run models using existing business intelligence tools and spreadsheets.