Google BigQuery
Google BigQuery
Google BigQuery
Starting at $4 per 100 slots
View PricingOverview
What is Google BigQuery?
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.
Read moreRecent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
View all 6 features- Database scalability (30)9.494%
- Database security provisions (24)9.292%
- Automated backups (24)9.090%
- Monitoring and metrics (26)7.979%
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Google BigQuery, and make your voice heard!
Pricing
View all pricingQueries (Hourly Flex Slots)
$4
Cloud
per 100 slots
Queries (On-Demand)
$5
Cloud
per TB
Queries (Annual Flat Rate)
$1,700
Cloud
per 100 slots
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is Google BigQuery?
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.
Google BigQuery Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Frequently Asked Questions
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.
Reviewers rate Database scalability highest, with a score of 9.4.
The most common users of Google BigQuery are from Mid-sized Companies (51-1,000 employees).
Comparisons
View all alternativesCompare with
Reviews and Ratings
(202)
Attribute Ratings
Reviews
(1-23 of 23)- Popular Filters
Companies can't remove reviews or game the system. Here's why
December 21, 2022
One stop solution for data management and fast querying
Google BigQuery manages data like no one else. The light speed of running queries makes it a one stop solution. The editor and query builder also have a highly intuitive interface that makes it easy to build new queries fast. Google BigQuery can easily be integrated with other google products like gmail and drive allowing the team to get real time updates and actionables.
December 19, 2022
Google BigQuery is ok!
Treasure Data is more for the marketer rather than a developer audience, so depending on who your main users will be for the machine learning you can decide which tool is better. In our case we went with Treasure Data because it was more for a marketer and less for the developer side.
May 05, 2022
Best Serverless SQL Database
BigQuery has a simpler and more intuitive user experience (as is the case with most of its products) compared to AWS, which has a more technical and complex profile, so it was the first tool we used. It's still my go-to option for handling SQL queries, though it doesn't detract from Athenas if the rest of the infrastructure is on AWS.
We based our analysis primarily on [BigQuery vs. Redshift vs. Athena] and BigQuery proved to be the best solution for us.
Score 10 out of 10
Vetted Review
Verified User
At my previous organization we used server based SQL server. There were days when the server was down and we couldn't work or access the data. This caused multiple reports and processes which were fed from the server to fail. Google BigQuery doesn't have such problems.
June 25, 2021
DataWarehousing with Google BigQuery.
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.
April 26, 2021
BigQuery = Big Win
We selected BigQuery since we were already making use of many other offerings within the Google Cloud Platform and it made sense to stay within that eco-system. Of course, we made sure it met our needs and was cost-effective, and when it did we didn't seriously consider an alternative from another vendor.
March 11, 2020
Querying TBs of data in seconds without any issues!
February 28, 2020
Easily Managed Data Warehouse Delivered At Scale
Google Cloud BigQuery was our first and last choice for a data warehouse. It serves all of our needs!
December 23, 2019
Big Advantages to BigQuery
Both BigQuery and Redshift are two comparable fully managed petabyte-scale cloud data warehouses. They’re similar in many ways, but you should consider their unique features and how they can contribute to an organization’s data analytics infrastructure. When considering which one to use, it is best to take advantage their free trial periods to run your tests. This way you'll be able to use your own results as well as compare them to third party benchmarks that closely make your own business, in order to determine the best cloud data warehouse.
December 20, 2019
Google BigQuery for analyzing large ML datasets using SQL
Google BigQuery needs minimal setup to get it up and running while Amazon Redshift and Oracle Analytics Cloud need moderate expertise and time to load a data set and run a query. Hadoop (open source) and its commercial version Cloudera do not provide a full out of the box solution for data warehousing and need additional components and installs. Databricks is a smaller vendor and does not come into picture if you are already an Oracle or a Google shop (=using their cloud, DB, et al.)
October 16, 2019
Google BigQuery is BIG for our company.
BigQuery is the first product we've seen of it's kind. Nothing seems to compare to the speed we get and the amount of data that we can fit into BigQuery. Data views are possible and recommended with basic data visualisation tools, but you may also choose to use something with a data layer for visualisation to make the most of your data.
Google's Firebase isn't a competitor but we had to use Google's BigQuery because Google's Firebase's database is limited compared to Google's BigQuery. Linking your Firebase project to BigQuery lets you access your raw, unsampled event data along with all of your parameters and user properties. Highly recommend connecting the two if you have a mobile app.
May 05, 2019
Dive Deeper into your Firebase Data
Firebase is not a competitor, necessarily, of BigQuery, but its integration with it allows for a greater deep dive into our Firebase data. The only reason we needed to start using BigQuery was that Firebase didn't give us the locational data that we need. Because of the easy integration with Firebase, we didn't look at any other services.
February 26, 2019
Google BigQuery, Ideal for Large Companies with Multiple Teams
BigQuery is better at storing and handling large amounts of data than Knime. Knime is locally run and does not have the ability to handle massive databases like BigQuery and importing from multiple sources for multiple teams would be impossible, that is not really the function of Knime anyhow. Knime is far better at manipulating data and creating reports. I use Knime with BigQuery to create reports, and do many data tasks like Keyword Selection, analysis and other related things.
February 15, 2019
Google BigQuery: Slow Learning Curve
November 29, 2018
Analyze data at lightening speed @BigQuery
Google BigQuery integrates seamlessly with Web Analytics data compared to the Azure cloud.
Google BigQuery integrates natively with different digital media platforms compared to Azure and AWs.
Google BigQuery integrates natively with different digital media platforms compared to Azure and AWs.
June 26, 2017
BigQuery is a game changer for OLAP
We liked BQ because the cost of it is only dependent on the amount of data you store (and there are tiers of data access) and how much you search. For us, it is significantly less expensive to run BQ than an equivalent hosted RDBMS. Because most of our data pipelines are automated, and, we only need to do ad-hoc queries irregularly, BQ fit our criteria very well.
Other locally hosted solutions are capable of providing the required level of performance, but the administration requirements are significantly more involved than with BigQuery. Additionally, there are capacity and availability concerns with locally hosted platforms that are a concern when working with data used for digital marketing analysis and ad performance optimization.
October 26, 2016
Google BigQuery truly democratizes data
February 19, 2016
BigQuery can change your business!
- Snowflate, Amazon Redshift and Apache Spark
BigQuery by far the best solution in all angles compared to other ones: Especially scalability, ease of use, performance and there is no need to manage any cluster of servers. Also it's ABSOLUTELY pay as you go! No one in market currently provide such service that can compete with Google BigQuery. The closest was Snowflake and in some cases like supporting ANSI SQL it even better than BigQuery. But at end of the day, BigQuery wins on cost and performance.
November 20, 2015
Evaluation of BigQuery from a Hadoop viewpoint
Spinning up, provisioning, maintaining and debugging a Hadoop solution can be non-trivial, painful. I'm talking about both GCE based or HDInsight clusters. It requires expertise (+ employee hire, costs). With BigQuery if someone has a good SQL knowledge (and maybe a little programming), can already start to test and develop. All of the infrastructure and platform services are taken care of. Google BigQuery is a magnitudes simpler to use than Hadoop, but you have to evaluate the costs. BigQuery billing is dependent on your data size and how much data your query touches.
November 18, 2015
Great for Interactive Analytics And KPI Reports
Comparing to competitors, Google BigQuery has the lowest cost and most flexible pricing model. Definitely higher ROI.