Overview
ProductRatingMost Used ByProduct SummaryStarting Price
1010data
Score 8.5 out of 10
N/A
N/AN/A
Google BigQuery
Score 8.6 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.
$6.25
per TiB (after the 1st 1 TiB per month, which is free)
Pricing
1010dataGoogle BigQuery
Editions & Modules
No answers on this topic
Standard edition
$0.04 / slot hour
Enterprise edition
$0.06 / slot hour
Enterprise Plus edition
$0.10 / slot hour
Offerings
Pricing Offerings
1010dataGoogle 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
Features
1010dataGoogle BigQuery
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
1010data
-
Ratings
Google BigQuery
8.4
54 Ratings
4% below category average
Automatic software patching00 Ratings8.117 Ratings
Database scalability00 Ratings8.954 Ratings
Automated backups00 Ratings8.524 Ratings
Database security provisions00 Ratings8.747 Ratings
Monitoring and metrics00 Ratings8.449 Ratings
Automatic host deployment00 Ratings8.113 Ratings
Best Alternatives
1010dataGoogle BigQuery
Small Businesses
Google BigQuery
Google BigQuery
Score 8.6 out of 10
SingleStore
SingleStore
Score 9.8 out of 10
Medium-sized Companies
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.8 out of 10
Enterprises
Oracle Exadata
Oracle Exadata
Score 8.2 out of 10
SingleStore
SingleStore
Score 9.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
1010dataGoogle BigQuery
Likelihood to Recommend
10.0
(2 ratings)
8.6
(54 ratings)
Likelihood to Renew
-
(0 ratings)
7.0
(1 ratings)
Usability
8.0
(1 ratings)
9.4
(3 ratings)
Support Rating
-
(0 ratings)
10.0
(9 ratings)
Contract Terms and Pricing Model
-
(0 ratings)
10.0
(1 ratings)
Professional Services
-
(0 ratings)
8.2
(2 ratings)
User Testimonials
1010dataGoogle BigQuery
Likelihood to Recommend
1010data
The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
Read full review
Google
Google BigQuery really shines in scenarios requiring real-time analytics on large data streams and predictive analytics with its machine learning integration. Teams have been using it extensively all over. However, it may not be the best fit for organizations dealing with small datasets because of the higher costs. And also, it might not be the best fit for highly complex data transformations, where simpler or more specialized solutions could be more appropriate.
Read full review
Pros
1010data
  • To "pool" their data for market analysis
  • Very large data analysis
  • Performance and scalability
Read full review
Google
  • 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
1010data
  • The ten.do interface could use more detailed documentation
Read full review
Google
  • 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
1010data
No answers on this topic
Google
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
1010data
That's votes by our team.
Read full review
Google
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
Support Rating
1010data
No answers on this topic
Google
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
1010data
While we have used SQL, 1010data is really the only industry standard product available for our use.
Read full review
Google
I have used Snowflake and DataGrip for data retrieval as well as Google BigQuery and can say that all these tools compete for head to head. It is very difficult to say which is better than the other but some features provided by Google BigQuery give it an edge over the others. For example, the reliability of Google is unmatchable by others. One thing that I really like is the ability to integrate Data Studio so easily with Google BigQuery.
Read full review
Contract Terms and Pricing Model
1010data
No answers on this topic
Google
None so far. Very satisfied with the transparency on contract terms and pricing model.
Read full review
Professional Services
1010data
No answers on this topic
Google
Google Support has kindly provide individual support and consultants to assist with the integration work. In the circumstance where the consultants are not present to support with the work, Google Support Helpline will always be available to answer to the queries without having to wait for more than 3 days.
Read full review
Return on Investment
1010data
  • Positive impact on help business make a data-drive decision
  • Positive impact on big data analysis
  • Negative impact on user friendly
Read full review
Google
  • Pricing has been very reasonable for us. The first 10 GB of storage is free each month and costs start at 2 cents per GB per month after that. For example, if you store 1 terabyte (TB) for a month, then the cost would be $20. Streaming data inserts start at 1 cent per 200 megabytes (MBs). The first 1 TB of queries is free, with additional analysis at $5 per TB thereafter. Meta data operations are free.
  • Big Query helps reduce the bar for data analytics, ML and AI. BQ takes care of mundane tasks and streamlines for easy data processing, consumption. The most impressive thing is the ML and AI integration as SQL functions, so the need for moving data around is minimized.
  • The visuals of ML models is very helpful to fine tune training, model building and prediction, etc.
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.