Google BigQuery -- for the really big jobs at the lowest cost
March 11, 2024

Google BigQuery -- for the really big jobs at the lowest cost

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

Overall Satisfaction with Google BigQuery

My organization is primarily concerned with training individuals to use store and analyze large amounts of data in a manner that is fast and accurate. Google BigQuery makes it possible to use the Cloud's infrastructure (hardware and software) to accomplish its data analysis goals. Being able to pay for the time and space that is utilized offers significant cost savings, especially for smaller (and mid-size) businesses and those that do not possess adequate resources for establishing a high-capacity infrastructure.
  • Allows for fast and efficient analysis of huge amounts of data
  • Allows for running interactive and batch queries
  • Allows for creation of dashboards and reports
  • Allows for real-time analytics on a server-less architecture
  • Streaming data can be expensive
  • Does not support advanced Machine Learning and Deep Learning techniques
  • Number of partitions in tables are limited to 4,000
  • Google BigQuery's sandbox allows users to test features for free.
  • Google BigQuery provides low cost storage (around $.02 per GB).
  • Google BigQuery stores data column by column.
Google BigQuery is less expensive to run and offers free storage of up to the first 10 GB of data. Google BigQuery is also easier (and faster) to get up and running. Unlike Snowflake, Google BigQuery does not require any manual scaling or performance tuning. Scaling is completely automatic.

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

I found Google BigQuery very easy to use from the very beginning. Users do need a very good knowledge of SQL in order to write queries that are processed efficiently. Using Select * queries can bog down resources and drive up costs.

Google BigQuery Feature Ratings

Database scalability
10
Database security provisions
10
Monitoring and metrics
10