Google Cloud BigQuery Reviews & Product Details

For the most part, it’s easy to understand and use. It works great with Looker Studio and other dashboard tools. Since the introduction of Gemini, it’s become even easier to generate queries and quickly check specific data points. Review collected by and hosted on G2.com.

Sometimes it struggles to run queries, and it can be difficult to stop an execution that’s already running when I need to make changes. Review collected by and hosted on G2.com.

I like the speed of Google Cloud BigQuery. I can query very large datasets, including terabytes of data and five years of search data, and get results in seconds. It’s easy to query large datasets and run analyses, and it feels optimized and efficient. I also find it very easy to manage data from Google Search Console because of the seamless integration and built-in export. Setup was very fast and easy, and I think it’s cheap. Review collected by and hosted on G2.com.

- Review collected by and hosted on G2.com.

BigQuery helped us process and validate large-scale enterprise data much faster during data quality and reconciliation workloads. I regularly used it alongside Spark jobs and analytics pipelines, and its fast query execution reduced the time required for troubleshooting and validation significantly. One thing I liked was that we could scale workloads without worrying much about infrastructure management, which made operations simpler for large data environments. Review collected by and hosted on G2.com.

One limitation I’ve noticed is that BigQuery is excellent for analytics and large-scale querying, but pipeline orchestration and workflow creation aren’t as straightforward as they are in tools like Azure Data Factory. For certain enterprise data quality and reconciliation use cases, I found that additional tools were still needed to manage end-to-end workflows, integrations, and overall coordination more efficiently. Review collected by and hosted on G2.com.

I like that we can connect Google Cloud BigQuery to data sources easily - in particular Google sources like GA and Ads. I also appreciate how we can build queries and schedule them, which is super convenient. It’s also great that we can run queries that generate their own data. Review collected by and hosted on G2.com.

It's quite complicated to set up initially, and Google Cloud in general has a very confusing interface, especially when it comes to user permissions because there are hundreds of different permissions that are quite complex and tricky. Depending on the geolocation of your data, it's sometimes hard to run a query in one location that can't see your dataset in another location, which is quite confusing. Review collected by and hosted on G2.com.

I use Google Cloud BigQuery to handle data and records for internal departments, and it supports me with almost near real-time data analytics, which is crucial. I really like how it provides me with dashboards of real-time reports, making it so much easier to interpret data quickly. It's great that BigQuery eliminates the need for servers to scale the data inputs, as Google manages this automatically, which is a massive relief considering the scale of data in the airline industry. Additionally, Google makes the user interface very friendly, making the initial setup a smooth process. Review collected by and hosted on G2.com.

cost of using this is too high Review collected by and hosted on G2.com.

It allows us to keep millions or tens of millions of data without affecting the performances of our queries and its now improved with AI features that really make a data warehouse feel like an airtable! Review collected by and hosted on G2.com.

The interface and the UI is too complex for a starter. When I was starting I could not understand which does what. But its not a tool for beginners.

The other thing is performance for small scale projects. If your project is small scale, expect 1min + query times for a single select query with only 100 records. The queries are optimized for larger scale, so you might feel those kind of delays here and there.

Its pricing is okay but has a vendor lock in situation when you put more and more data in it. Fortunately we havent gone that far, but I feel like being a place to collect millions or billions of data, going for another provider can of course be a nightmare. If they keep pricing the same that wont be a big issue. Review collected by and hosted on G2.com.

I use Google Cloud BigQuery for learning big data concepts and implementing chatbots. I like that all the services and products are in one place, making it easy to use BigQuery for different use cases. I appreciate its ease of access and integration with different tools. Not just BigQuery, but Google Cloud as a whole environment is very beginner-friendly and provides a sandbox at a low cost for learning. Tools like Google CloudSQL, BigQuery, APIs, and Vertex AI are very valuable for learning chatbot implementation. The initial setup of Google Cloud BigQuery was very easy. Review collected by and hosted on G2.com.

The billing details can be clearer and more easily monitored. The option to pause and resume payments could be designed for easier UX. It would be really helpful to have the option to pause payments on weekends or provide a prompt to pause when not in use for more than 6 hours. Review collected by and hosted on G2.com.

I like that Google Cloud BigQuery is free if you're not operating on a big scale, which is great because we use it without paying for it. I'd also say the user experience is pretty decent. Additionally, I think the initial setup was pretty quick. Compared to other services, it was probably the fastest. Review collected by and hosted on G2.com.

The AI features aren't very good, so I end up using external AI services to write queries. There's also multiple ways of doing the same things and it's not super clear which one's best. Sometimes, I think the UX could be a bit more clear on what the best ways of operating would be. The fact that you have to do a certification or a course to learn how to use the product shows that the product is not as intuitive as it could be. Review collected by and hosted on G2.com.

BigQuery's serverless architecture and lightning-fast SQL query performance on massive datasets is exceptional. The seamless integration with Google Cloud Platform tools and automatic scaling makes data analytics effortless without managing infrastructure. Built-in machine learning capabilities and real-time analytics have transformed our data workflows significantly. Review collected by and hosted on G2.com.

The pricing model can become expensive for large-scale queries without proper optimization and cost monitoring. The learning curve for advanced features and query optimization techniques requires time investment. Limited support for certain data types and occasional complexity in debugging nested queries could be improved for better developer experience. Review collected by and hosted on G2.com.

What I like best about BigQuery is its ability to handle massive datasets with incredible speed, without worrying about infrastructure. Its serverless, fully managed architecture allows me to focus on analysis and deriving insights, and its integration with other Google Cloud tools makes building dashboards and pipelines seamless Review collected by and hosted on G2.com.

BigQuery is powerful, but query costs can grow if datasets are very large and queries aren’t optimized. I usually work around this by using partitioned tables and caching results. Also, while it’s great for analytics, very complex data transformations often need additional ETL tools—but that’s manageable with the right approach Review collected by and hosted on G2.com.