Last updated on
Ratings
Google Cloud BigQuery description
Google BigQuery is a fully managed data warehouse service that helps businesses analyze massive datasets to gain insights. It's serverless, so you don't need to manage any infrastructure, and it can handle data from various sources. BigQuery is designed for fast query processing, allowing you to quickly explore and analyze your data. It's a powerful tool for data-driven decision-making in any industry, regardless of company size.
Who is using Google Cloud BigQuery?
Who is Google Cloud BigQuery best for
Google BigQuery is a fully managed, serverless data warehouse solution ideal for businesses of all sizes needing to analyze massive datasets quickly. Users praise its speed and scalability but caution about unpredictable costs. It's a powerful tool for data-driven decisions, especially for those comfortable with SQL.
-
Ideal for small, medium, and large businesses.
-
A good fit for various data-heavy industries, including Software/IT, Marketing, Education, and more.
Google Cloud BigQuery features
| Supported Google Cloud BigQuery fully supports SQL for querying data. |
| Supported Google Cloud BigQuery stores data in a columnar format, making it well-suited for analytical queries. This method enhances efficiency by allowing the system to process only the necessary columns for a given query. |
| Supported Google Cloud BigQuery supports data integration from various sources, including third-party platforms via multiple methods like Data Transfer Service, Cloud Data Fusion plugins, and Datastream. It also integrates with other Google Cloud services and external tools, confirming its robust data integration capabilities. |
| Supported BigQuery supports managing and organizing large datasets through features like data governance and scalability. |
| Supported BigQuery supports data partitioning for efficient querying. |
We evaluate the sentiment that users express about non-functional aspects of the software
Value and Pricing Transparency
Customer Service
Ease of Use
Reliability and Performance
Ease of Implementation
Scalability
Google Cloud BigQuery reviews
We've summarised 999 Google Cloud BigQuery reviews (Google Cloud BigQuery Capterra reviews and Google Cloud BigQuery G2 reviews) and summarised the main points below.
- Exceptional query processing speed, handling massive datasets efficiently
- Fully managed and serverless, eliminating infrastructure management
- User-friendly interface for querying and data exploration
- Extensive SQL support and compatibility with familiar syntax
- Occasional freezing issues in BigQuery Studio, especially after refreshing the page
- High and unpredictable costs, with limited cost control features
- Limited integration options with non-Google products and services
- Steep learning curve for beginners, especially for cost optimization and advanced features
Google Cloud BigQuery pricing
The commentary is based on 321 reviews from Google Cloud BigQuery Capterra reviews and Google Cloud BigQuery G2 reviews.
BigQuery's serverless architecture and speed are praised, but its pricing model is a common concern. Users suggest careful cost monitoring and optimization strategies are necessary, especially for large datasets and complex queries. Some find the pay-as-you-go model unpredictable and potentially expensive.
Users sentiment
See the Google Cloud BigQuery pricing page.
Google Cloud BigQuery alternatives
SnowflakeHas broader industry applicability and is growing faster. A popular BigQuery competitor and alternative.Read more
ClickHouseOpen-source, offering free and paid options. Better for real-time data warehousing and column-oriented data. Growing faster than Google Cloud BigQuery. A good Google Cloud BigQuery competitor.Read more
SAS ViyaBetter for users seeking advanced analytics, machine learning, and AI capabilities. A more comprehensive platform for collaboration between data professionals and business users. More established, with potentially more resources and support.Read more
Google BigQuery Data Transfer ServiceSpecifically designed for automated data transfers into BigQuery, simplifying data ingestion. Better for users focused on automated data movement, not direct querying and analysis.Read more
LookerBetter for non-technical users seeking a user-friendly business intelligence platform. Stronger focus on data visualization and dashboarding. Tighter integration with the Google ecosystem. More positive pricing sentiment.Read more
Google Cloud BigTableBetter for operational workloads requiring high throughput and low latency. More suitable for finance, e-commerce, and retail. Less versatile for general data warehousing and analytics. Steeper learning curve and more complex to manage. Pricing is less transparent.Read more
Google Cloud BigQuery FAQ
What is Google Cloud BigQuery and what does Google Cloud BigQuery do?
Google Cloud BigQuery is a fully managed, serverless data warehouse that enables businesses to analyze massive datasets quickly. It offers SQL support, columnar storage, and seamless data integration, empowering data-driven decisions. BigQuery is ideal for companies of all sizes seeking fast, scalable data analysis.
How does Google Cloud BigQuery integrate with other tools?
BigQuery integrates seamlessly with other Google Cloud services and offers various data integration tools like Data Transfer Service and Cloud Data Fusion plugins. It also supports connections with external tools, enabling comprehensive data analysis.
What the main competitors of Google Cloud BigQuery?
Top alternatives to Google Cloud BigQuery include Snowflake, Amazon Redshift, Databricks, and Azure Synapse Analytics. These data warehousing solutions offer similar capabilities for large-scale data analysis and business intelligence.
Is Google Cloud BigQuery legit?
Yes, Google Cloud BigQuery is a legitimate and safe data warehousing solution from Google. It's known for its speed and scalability in handling massive datasets, making it a reliable choice for businesses seeking robust data analysis capabilities.
How much does Google Cloud BigQuery cost?
Google Cloud BigQuery's pricing depends on storage and analysis. Storage costs vary but are generally low. Analysis is priced on a per-query basis, making it cost-effective for occasional needs but potentially expensive for heavy usage. Contact sales for detailed pricing.
Is Google Cloud BigQuery customer service good?
Customer reviews on Google Cloud BigQuery's customer support are mixed. While some users mention helpful and responsive support, others note difficulty reaching support or a lack of readily available resources for complex issues. Some users also point out the documentation could be improved.
Reviewed by
Michal has worked at startups for many years and writes about topics relating to software selection and IT management. As a former consultant for Bain, a business advisory company, he also knows how to understand needs of any business and find solutions to its problems.
Tymon is a seasoned CTO who loves finding the perfect tools for any task. He recently headed up the tech department at Batmaid, a well-known Swiss company, where he managed about 60 software purchases, including CX, HR, Payroll, Marketing automation and various developer tools.