BigQuery can change your business!
February 19, 2016

BigQuery can change your business!

Reza Qorbani | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Google BigQuery

We are Big Data company who dealing with petabytes of data and we generate hierarchal data that can be used for Advertising companies. Our customer wanted to query this data via API and extract results where they can have access. Since we are dealing with Terabytes of data to query at any time, we either had option to build 247 infrastructure to support our API requests which would cost us hundreds of thousands of dollar to build, or use BigQuery!

In Our use-case BigQuery not only saved us lots of money but also improve our delivery by almost 100x which was more than what our customers needed. Now our customers can query and extract their data via our API to BigQuery in matter of minutes while previously was in multiple hours!
  • No need to maintain any infrastructure
  • Exteremly cheap while easy to understand pricing
  • IT IS FAST!!!
  • Authorization is so simplified and hard to maintain different level of security to access to data
  • Absolutely positive ROI! Actually HUGE one in fact. We literally saved more than $1M by just using BigQuery
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.
BigQuery can be used for trillions of records as well as hundreds of thousands but not sure if it's useful for small set of data. Also in cases that query response needs to be on milliseconds that might be not right solution. Custom UDFs are also supported but very limited and have ittheirs own challenges since it's not SQL and need to write in JavaScript.

Google BigQuery Feature Ratings

Automatic software patching
Database scalability
Automated backups
Database security provisions
Monitoring and metrics
Automatic host deployment