Google BigQuery Review
August 30, 2024

Google BigQuery Review

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Google BigQuery

We use BigQuery to store and analyze data for identifying long term trends. Data is ingested through pipelines on Airflow. Since our other logging solutions were only storing information for less than 2 months it was very difficult to identify the overall trend and seasonality. Using BigQuery, we are not only able to visualize the trends and make better decisions, using BigQuery eliminates the overhead of maintaining the underlying infrastructure or add more resources for servers/databases. The ability of using petabyte size data is pretty useful and is cost effective with pay per use features.

Pros

  • Serverless architecture is very useful as users do not have to maintain the underlying architecture
  • Fault tolerance and availability in multiple geographic regions means we can run the queries faster without data loss due to unforeseen circumstances
  • The real time cost estimator gives the data which can be processed and hence we are able to refine the queries and identify in advance what are we going to be charged
  • Ability to see job run history, project job run and see how much data is consumed by our queries including the efficiency and places for improvement in the project level

Cons

  • Any new feature introduced should have an information icon to see how much cost will be associated. Ex: Table Explorer feature recently caused some extra expenses in the project where even the preview feature led to additional costs
  • Ability to set billing quotas on individual accounts should be possible
  • With the advent of AI, BigQuery should also allow for asking questions in natural language and give output in the form of queries without high additional costs for this feature.
  • The time to bring this to productions is very fast without any additional setup required
  • Security features is top tier
  • Scalability is a major positive for BigQuery as it can process very high amount of data very quickly
I came to use BigQuery from a traditional system like MS SQL server, the features which are available in BigQuery as a cloud service far outweigh the features from SQL server. I have not used other similar tools like Amazon Redshift but Google BigQuery serves multiple use cases which are required by small to mid and large organizations from a data warehousing system

Do you think Google BigQuery delivers good value for the price?

Yes

Are you happy with Google BigQuery's feature set?

Yes

Did Google BigQuery live up to sales and marketing promises?

Yes

Did implementation of Google BigQuery go as expected?

Yes

Would you buy Google BigQuery again?

Yes

We store GCP BigQuery to store long term data where personal information is redacted and another Splunk for checking day to day log or for troubleshooting by operations team. Since cost is associated with each query we have not found BigQuery to be useful in both of these use cases. In addition costs can quickly escalate when large datasets are involved. Similar use case is observable in transaction base data or data which needs to be frequently queried and the output is small in size, Minimum bytes charged is 10 MB.

Google BigQuery Feature Ratings

Database-as-a-Service
8.7
Database scalability
9
Database security provisions
9
Monitoring and metrics
8

Comments

More Reviews of Google BigQuery

  1. Home
  2. Database-as-a-Service (DBaaS)
  3. Google BigQuery Reviews
  4. User Review of Google BigQuery