Item: Google BigQuery
Rating: 10
Author: Reza Qorbani

Overall Satisfaction with Google BigQuery

Use Cases and Deployment Scope

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!

Pros and Cons

Pros

No need to maintain any infrastructure
Exteremly cheap while easy to understand pricing
IT IS FAST!!!

Cons

Authorization is so simplified and hard to maintain different level of security to access to data

Return on Investment

Absolutely positive ROI! Actually HUGE one in fact. We literally saved more than $1M by just using BigQuery

Alternatives Considered

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.

Other Software Used

Apache Spark, Google App Engine, Google Cloud Storage

Likelihood to Recommend

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

Comments

Please log in to join the conversation

BigQuery can change your business!