Capterra’s researchers use a mix of verified reviews, independent research and objective methodologies to bring you selection and ranking information you can trust. While we may earn a referral fee when you visit a provider through our links or speak to an advisor, this has no influence on our research or methodology. Learn more.
Capterra carefully verified over 2 million reviews to bring you authentic software and services experiences from real users. Our human moderators verify that reviewers are real people and that reviews are authentic. They use leading tech to analyze text quality and to detect plagiarism and generative AI. Learn more.
Capterra lists all providers across its website—not just those that pay us—so that users can make informed purchase decisions. Capterra is free for users. Software and service providers pay us for sponsored profiles to receive web traffic and sales opportunities. Sponsored profiles include a link-out icon that takes users to the provider’s website. Learn more.
BigQuery is a serverless, multi-cloud data warehouse that simplifies the process of working with all types of data so you can focus on getting valuable business insights quickly. At the core of Google’s data cloud, BigQuery allows you to simplify data integration, cost effectively and securely scale analytics, share rich data experiences with built-in BI, and train and deploy ML models with a simple SQL interface, helping to make your organization’s operations more data-driven.
Provider
Located In
United States
Open API
Yes
Deployment
Cloud, SaaS, Web-Based
Training
Documentation, Videos
Support
Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support, Chat
BigQuery helps organizations of all sizes break down data silos and get more value out of their data.
Content Source: Google Cloud BigQuery
Based on other buyer's searches, these are the products that could be a good fit for you.
Google Cloud BigQuery Reviews
Pros
Free Tier access, query execution on the free tier, connection of Big Query from other market tools and best of the best we can directly connect with Google Sheet.
It is pretty straightforward to set up and allows for lots of data inputs. It's data visualization and statistics are amazing and provide useful insight.
Importing information from Google Sheets seems like a super advantage to me, as does the ability to execute large queries without affecting performance.
The sandbox supports up to 4 ( I think) projects that you can work on for free. This is great for people who are just starting out and BigQuery is very affordable as a whole.
Cons
Once the table is created it is difficult to edit the columns, so you have to delete it.
We have also built a dashboard where we make a conciliation of our clients' data, in case something goes wrong, we immediately realize what is happening.
Currently loading up multiple datasets on the same project and / or opening multiple tabs for queries makes everything really confusing and hard to navigate.
Sometimes when you make complex SQL queries, the debugging tool does not help a lot finding the problem.
"Review of BigQuery Query Execution and Use Cases."
Overall: Free Tier access, query execution on the free tier, connection of Big Query from other market tools and best of the best we can directly connect with Google Sheet. It is very to use and implement into software using data stream to connect with databases as well.
Pros: It is very help full to store large unstructured data and further etl the data and used for analytics.
Cons: For Beginners it is costly. Overall very fast and reliable.
"Great serverless cloud data warehouse"
Overall: We used BigQuery to analyze firebase events data from our mobile apps. Considering the sheer volume of this dataset, querying has been mostly very fast and reliable, albeit at a high cost.
Pros: I like the serverless nature of BigQuery. It takes away most of the maintenance costs involved in maintaining and fine-tuning a data warehouse.
Cons: I didn't really like the on-demand pricing of BigQuery. Monthly costs tend to blow up excessively. I think they have a different pricing option now to resolve this though.
"Get started with BigQuery, A powerful tool for analysing Big data"
Pros: Our salesforce campaigns relies heavily on data warehouse, which is the backbone of everything we do. This data set contains both row data sets and BigQuery is used to aggregate this sets by running schedule queries on it.
Cons: This platform requires strong SQL skills. Huge dependency on tech team to fix queries sometime.
"Worth a try for datawarehousing loads"
Pros: Free 1TB compute User friendly web UI Amazing web SQL editor
Cons: I can't find anything wrong with biguery
"GBQ is an analysts best friend"
Overall: GBQ powers a lot of our analysis tooling and reps use it directly with Python to make their own custom flows.
Pros: Literally everything. GBQ takes tasks like partitioning, building feeds from/to other systems simple, fine-grain access controls, plugs into Looker like a dream, built in connectors for other Google products (Search console, GA)
Cons: The permission-ing for GBQ can sometimes be vague depending on what the user is needing/wanting to do. Some roles require items that you think would be included in higher access level roles (I'm looking at you BigQuery Job User role).