Item: Google BigQuery
Rating: 9
Author: Verified User

Use Cases and Deployment Scope

Due to its lower cost, we use BigQuery as our primary database to store most of our data. We also use BigQuery to run periodic analytical tasks. We mainly use it for our WebSights product which collects and stores many user demographics and enriches IP traffic.

Pros and Cons

Ease of use
Scalability
Lots of integrated Google Cloud features

Query Latency
Indexing
Few errors when exporting data to buckets

Return on Investment

Easier to do analytics
Lower operational cost

Alternatives Considered

SingleStore

SingleStore has a much lower query latency compared to BigQuery. Thus, we segregate faster tasks to SingleStore, and use BigQuery has our main database to store all historical data.

Key Insights

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

Other Software Used

SingleStore, Google Cloud SQL

Likelihood to Recommend

Google BigQuery integrated really when with a product that generates enormous amount of data, since appending data to BigQuery is much faster even in high frequency. They also offer a generous free tier which helps in determining its suitability and costs scale according the usage. If you need a really low latency query execution, this might not be what you are looking for.

Google BigQuery - Experience

Overall Satisfaction with Google BigQuery