Google BigQuery

Google BigQuery

(31)
4.2 out of 5 stars

Analyze Big Data in the cloud with BigQuery. Run fast, SQL-like queries against multi-terabyte datasets in seconds. Scalable and easy to use, BigQuery gives you real-time insights about your data.

Work for Google BigQuery?

Learning about BigQuery?

We can help you find the solution that fits you best.

Google BigQuery Reviews

Ask BigQuery a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
  • For Category
Ratings
Company Size
User Role
Industry
For Category
Showing 31 BigQuery reviews
LinkedIn Connections
BigQuery review by <span>Lorenzo R.</span>
Lorenzo R.
Validated Reviewer
Verified Current User
Review Source

"A great tool for Data Analytics"

What do you like best?

The main plus of BigQuery is its managed and noOps nature. On one side, this allows us and our customers to handle spikes in computing or storage demands without reengineering anything; on the other side, this enables relevant savings with respect to a traditional "cluster-based" data warehousing solution.

Another interesting aspect is that BigQuery fits very well in different scenarios, ranging from small datasets (in the order of GBs) to enormous workloads handling TBs or PBs of data.

What do you dislike?

We still don't have much control over long-running jobs: it would be nice to have webhooks or Pub/Sub messages notifying the end of a process, in order to implement BigQuery within an automated solution.

What business problems are you solving with the product? What benefits have you realized?

BigQuery solves a range of problems, from classical DWH/BI solutions, speeding up - by orders of magnitude - the computation of insights from data, to advanced Data Science and ML tasks when used together with other tools like ML Engine, Datalab and Dataflow.

Sign in to G2 Crowd to see what your connections have to say about Google BigQuery
BigQuery review by <span>Rahul C.</span>
Rahul C.
Validated Reviewer
Verified Current User
Review Source

"Enhanced Data Analysis with Big Query"

What do you like best?

Big Query is a product of Google which is mostly used for data analysis over big data using Queries. Big Query charges you as much as data you process so it's like pay as you go. If you have small large traffic on your website then you must be generating a huge data that can be analyzed in seconds with BQ. When you buy Google Analytics premium Big Query comes with that and you also have 500 credits that are enough for analysis and querying. It has simple UI which is easy to use and understand. If you know simple SQL then you would quickly understand the syntax and functions of Big Query. Google has provided very good and clean documentation for Big Query that can be used to build better Queries. Even you can use Big Query for predictive analysis and different kind of analysis. Moreover, you would easily find API of big query from which you can fetch data from a table as well insert data in a table. Not only Google Analytics data but you can also upload your CRM data and merge with another analytics data to analyze further. Big Query is cloud based so you need not worry about installing it on your premises.

What do you dislike?

Big Query is a very useful tool but not for everyone. You should go for Big Query when you have a huge data set to analyze for small analysis you could go or don't want to go is your decision. If you want to use Big Query API then you must be good with coding skills. Big Query is an append-only database that's the only thing which you would dislike but if you upload your own dataset you can fire update queries but it restrict with Google Analytics datasets.

Recommendations to others considering the product

It's a great tool and not that much expensive you can use this as your relational database to build better products.

What business problems are you solving with the product? What benefits have you realized?

Big Query in our company is used very efficiently to build different products or storing data for future analysis.

What Database as a Service (DBaaS) solution do you use?

Thanks for letting us know!
BigQuery review by <span>Raymond H.</span>
Raymond H.
Validated Reviewer
Verified Current User
Review Source

"Excellent, affordable big data platform"

What do you like best?

The fact that I can store millions of records without it costing me a fortune. I like their web interface which allows me to look through my data and run queries on it from anywhere. I like that I can set everything up through the web interface.

It's also very easy to add more columns to data even after existing data is in place.

What do you dislike?

I'm not a big fan of Google Cloud Platform's support model. The cheapest option available is $150/month, which for a small business like ours almost doubles our monthly bill.

Other than that, I don't really have any complaints, but the only thing that comes to mind is that the client libraries are quite large.

Recommendations to others considering the product

BigQuery is easy to use and can handle a large amount of data before it starts costing you anything. Because of this, it's easy to evaluate how well it works for your needs before having to start paying.

They also have several large data sets that can be played with to learn your way around and get started including all of the source code on GitHub.

What business problems are you solving with the product? What benefits have you realized?

We needed to store large amounts of data for analytics purposes and BigQuery has allowed us to do that easily and without adding a lot of cost.

We've been able to start storing all of this analytics data and once we have enough to be useful I don't expect us to have a difficult time using it.

BigQuery review by <span>Jerome M.</span>
Jerome M.
Validated Reviewer
Review Source

"A great Analytics-Back-End-as-a-Service for a SaaS vendor"

What do you like best?

The PaaS approach: no need to provision capacity, we only stream data as it is generated by our clients on our SaaS product. Then, as our clients use our analytics dashboard, interactive BQ queries are running to get data.

The query language (SQL) allows to write very complex queries (pages long queries), which always execute in a few seconds, no matter the complexity and the amount of data.

What do you dislike?

For our specific use case, the concurrent query quota being on the project, not on the dataset, is a limiting factor, always forcing us to design in minimizing the number of interactive queries. If this quota was on a dataset level, that would allow us to increase our usage further (and our spend on BQ).

What business problems are you solving with the product? What benefits have you realized?

We get a fully managed back-end system for our SaaS product analytics.

BigQuery review by <span>Sara R.</span>
Sara R.
Validated Reviewer
Verified Current User
Review Source

"Amazing software"

What do you like best?

Google BigQuery is an amazing technology, but might not be the best solution depending on your needs. For example, if you query your data a lot, it can end up being very expensive, as BigQuery also charges per data processed on a query.

What do you dislike?

I dislike that you have to pay for every query that you make.

What business problems are you solving with the product? What benefits have you realized?

I am solving our need to use multiple softwares for different things by using one hail all software

BigQuery review by <span>Christophe N.</span>
Christophe N.
Validated Reviewer
Verified Current User
Review Source

"Perfect solution for analytics and logging "

What do you like best?

BigQuery is a great platform to perform analytics on big dataset. SQL is a great and powerful language and being able to query TBs of data in less than a minute is awesome. We use BigQuery to perform analysis on our logs and to identify trends in pricing for various items in different markets. Both the engineering team and the marketing team enjoy the tool.

What do you dislike?

We've often hit limitations in terms of query results size. Also, an interface to generate graphs out of query results directly in BigQuery would make the tool even more powerful.

Recommendations to others considering the product

Use table decorators for queries that are time boxed to avoid going over the whole table.

Integrate with Google Cloud Storage.

What business problems are you solving with the product? What benefits have you realized?

Analytics, stats aggregation which are then used on our product, logging.

* We monitor all Google BigQuery reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.