My Experience with Google BigQuery.
March 15, 2024

My Experience with Google BigQuery.

Vishal Sharma | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Google BigQuery

We have used Google's big query to store and analyze vast amounts of data. In today's time, every organization requires real-time insights from the data. BigQuery can be Integrated with popular BI tools to visualize data and generate actionable insights, aiding in department decision-making processes. With BigQuery, we have a centralized repository for all organizational data, facilitating easy access for analysis and reporting.
  • Scale automatically to handle datasets of any size.
  • BigQuery can perform extremely fast SQL queries across vast datasets.
  • Pay-as-you-go model, BigQuery allows users to pay only for the data processed and stored.
  • It is challenging to predict costs due to BigQuery's pay-per-query pricing model. User-friendly cost estimation tools, along with improved budget alerting features, could help users better manage and predict expenses.
  • The BigQuery interface is less intuitive. A more user-friendly interface, enhanced documentation, and built-in tutorial systems could make BigQuery more accessible to a broader audience.
  • Cost Effective as its pricing model allows businesses to pay only for the data they process.
  • It requires a certain level of expertise to use effectively. Companies may need to invest in training or hire specialists.
BigQuery can automatically scale to accommodate the data and query load, providing potentially unlimited scalability. At the same time, Redshift requires manual scaling efforts to increase or decrease capacity, which might affect performance during scaling operations.

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

For organizations looking to avoid the overhead of managing infrastructure, BigQuery's server-less architecture allows teams to focus on analyzing data without worrying about server maintenance or capacity planning. Small projects or startups with limited data analysis needs and tight budgets might find other solutions more cost-effective. Also, it is not suitable for OLTP systems.

Google BigQuery Feature Ratings

Database scalability
9
Database security provisions
8
Monitoring and metrics
8