We primarily use the solution for data analytics.
Sr. Manager - TAAS at a manufacturing company with 10,001+ employees
Issue-free, straightforward to set up and offers good expansion capabilities
Pros and Cons
- "It's straightforward to set up."
- "We'd like to have more integrations with other technologies."
What is our primary use case?
What is most valuable?
I enjoy the scalability of the solution. Its scalability is very impressive.
It's straightforward to set up.
The solution has been stable.
What needs improvement?
We'd like to have more integrations with other technologies. We'd like something like CrossCloud - something that can be on AWS and Azure and can be easily integrated.
It would be great if they added data anonymization to their list of features. We'd like to see data compliance and masking so we can enforce things region by region.
For how long have I used the solution?
I've been using the solution since around 2019.
Buyer's Guide
BigQuery
November 2024
Learn what your peers think about BigQuery. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
What do I think about the stability of the solution?
I haven't seen any tickets relating to trouble with scalability. It seems to be reliable. There are no bugs or glitches. It doesn't crash or freeze.
What do I think about the scalability of the solution?
The scalability is excellent. It can handle large datasets and scale up pretty easily as the data volume grows. It expands very easily.
We have 80 to 100 people using the solution right now. It's used on a daily basis.
How are customer service and support?
I haven't used technical support just yet. I haven't come across any problems which would require me to reach out.
Which solution did I use previously and why did I switch?
I've used Data Warehouse in the past and am familiar with Teradata and Snowflake.
If I have to compare BigQuery with Teradata in terms of performance, capabilities, ease of use, and integrations, BigQuery scales up better. However, in terms of licensing and paper use, Teradata is quite good.
If we compare it with other things like Snowflake, Snowflake has its own unique architectural advantages. However, I haven't seen Snowflake over on Google Cloud. I have seen Snowflake over on AWS and Azure. The architecture of Snowflake has its own unique advantages and is largely on other clouds.
How was the initial setup?
The initial setup is very simple and straightforward. I'd rate the ease of implementation a four out of five.
What's my experience with pricing, setup cost, and licensing?
We find the pricing reasonable enough for our use cases. However, it's too early to comment on if it will be good in the long run. We have to properly plan data around different tiers, including which to archive where so that we use it in a more optimized fashion. We will need to properly plan everything and we haven't really done that yet.
I'd rate it a four out of five in terms of its competitive pricing.
What other advice do I have?
I'm an end-user. I'm still new to the company. I'm not sure which version of the solution we're on.
All cloud systems have more or less the same functionality. It's just a matter of choosing one that makes sense for your business.
When it comes to how to leverage analytics, some of the AI and machine learning from Google come ahead of the competition. Other than that, the other analytics options are fairly competitive between Google, AWS, and Microsoft. It's just that, when it comes to extending the analytics to AI/ML, Google is ahead of the competition there.
I'd recommend the solution to others.
I would rate it eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Lead Machine Learning Engineer at Schlumberger
A serverless system that is easy to set up and offers fast analysis of data
Pros and Cons
- "It's similar to a Hadoop cluster, except it's managed by Google."
- "It would be helpful if they could provide some dashboards where you can easily view charts and information."
What is our primary use case?
We are primarily using the solution to crunch data. Then, we are doing some ETL work on top of the data.
What is most valuable?
We like that it is a serverless system.
We can analyze terabytes of data in a very small amount of time.
It's similar to a Hadoop cluster, except it's managed by Google.
The initial setup is simple.
We find the product to be very stable.
It scales quite well.
What needs improvement?
If they can provide any charting platform on top of this product, that would be ideal. BigQuery now only allows us to run queries. It doesn't provide us with any insights. For example, if a query took so many times, they could maybe provide any suggestions on how to optimize the queries or speed up the process. It would be helpful if they could provide some dashboards where you can easily view charts and information. That would be very useful.
For how long have I used the solution?
I've been using the solution for two or three years.
What do I think about the stability of the solution?
This is a highly stable product. There are no bugs or glitches. It doesn't crash or freeze.
What do I think about the scalability of the solution?
The solution is very scalable.
Almost my entire team uses it. We have a 50-member team, and pretty much everyone is on it. They are mostly data engineers and developers.
How are customer service and support?
We have yet to reach out to technical support. We haven't had any issues.
Which solution did I use previously and why did I switch?
We chose this solution specifically since all of our services are in GCP, Google Cloud. Google Cloud has a basic internal coupling with BigQuery. That's the reason we are using BigQuery.
How was the initial setup?
The initial setup is very easy. You just have to log in to the Google Cloud console, and then you can just create a few tables and start using it.
From start to finish it takes about half an hour. It is even less than that to get the tables up and running. The deployment is quite fast.
What's my experience with pricing, setup cost, and licensing?
I'm not sure about the exact cost, however, it is charged on the queries which you run, basically. For example, if you run a query, the amount of data scanned through BigQuery will dictate the costs.
What other advice do I have?
I am a customer and end-user.
I'm not sure which version of the solution we're using.
It's a serverless platform deployed on a public cloud.
I'd advise potential users to set up their tables accordingly. There are two sets of optimization that BigQuery provides as well. You set up whichever columns you want to do the partition and on which columns you want to do the clustering. If these columns are defined properly, then BigQuery's a breeze to use.
On a scale from one to ten, I would rate it at an eight. If they just added a few more features, it would be almost perfect.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
BigQuery
November 2024
Learn what your peers think about BigQuery. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
V.P. Digital Transformation at e-Zest Solutions
Cost-effective Cloud data platform based on Google Cloud that is fully managed service, very easy to set up and manage
Pros and Cons
- "It has a proprietary way of storing and accessing data in its own data store and is 100% managed without you needing to install anything. There is no need to arrange for any infrastructure to be able to use this solution."
- "There are many tools that you have to use with BigQuery that are different services also provided for by Google. They need to all be integrated into BigQuery to make the solution easier to use."
What is our primary use case?
This is a solution from Google that is 100% cloud-based, based on GCP. BigQuery is similar to Snowflake in the way it manages data analytics. It completely decouples storage from Compute. It has a proprietary way of storing and accessing data in its own data store and is 100% managed without you needing to install or deploy anything. There is no need to arrange for any infrastructure in order to use this solution. Go to BigQuery.com, create an account and you will get a console on your browser where you can start creating the end to end data platform - databases, data warehouses, roles, users, ETL / ELT pipelines and write transformations - all via the workspace.
What needs improvement?
Although BigQuery in completely managed on cloud, one has to use many services of BigQuery and GCP in order to create the end-to-end data setup. BigQuery acts as the core Data Warehouse mechanism, but it needs additional services like - Google Cloud Dataflow, Cloud pub/sub, Cloud BigTable, Cloud DataPrep, Cloud DataProc, Cloud SQL. Being different from the traditional way of setting up end-to-end data engineering platform, the learning curve for BigQuery is a bit steeper. Google BigQuery ecosystem can surely make the ecosystem a bit more leaner.
For how long have I used the solution?
I have been using this solution for 3 years.
What do I think about the stability of the solution?
A very stable solution. All native abilities of Google solutions are inbuilt in BigQuery. I would predict that Snowflake and BigQuery will occupy a much larger share of the cloud data analytics space in the coming years than Azure Synapse in the future.
What do I think about the scalability of the solution?
This is a very scalable solution. BigQuery's pricing is more suitable for large operations that plan to scale. For smaller businesses, this may be an expensive solution. Creating a BigQuery account is free, but as soon as you start using computations and data capabilities, charges start adding up.
How was the initial setup?
There is no installation involved while using BigQuery. It is as simple as opening a Gmail account and creating your own end-to-end setup. You can start creating a database schema, data bases, create pipelines with step-by-step activities ranging from ingestion to transformation to updating the data marts. Its completely managed and one does not need to worry about licenses of installations.
At e-Zest, in our projects for our enterprise customers, typically between 2 to 8 people were needed for end-to-end data platform development. This included one or two admins, 2-3 ETL developers and 2-3 data warehouse members with strong SQL and database skills.
What's my experience with pricing, setup cost, and licensing?
One terabyte of data costs $20 to $22 per month for storage on BigQuery and $25 on Snowflake. Snowflake is costlier for one terabyte but only marginally. Both charge differently for compute. BigQuery charges based on how much data is inserted into the tables. Reading values from tables has no cost.
BigQuery charges you based on the amount of data that you handle and not the time in which you handle it. This is why the pricing models of Snowflake and BigQuery are different and this becomes a key consideration in the decision of which platform to use.
Which other solutions did I evaluate?
We evaluated Snowflake, Azure Synapse and Amazon Redshift along with BigQuery. Snowflake and BigQuery are very similar in the way they operate. However, I would rate Snowflake slightly higher than BigQuery. I would rate Azure Synapse third and AWS Redshift fourth. The way Snowflake operates, and allows integration with other systems makes it a better alternative to BigQuery. Also Snowflake's and BigQuery's underlying architectures are quite different, although for the end user they may be appearing similar for use.
What other advice do I have?
BigQuery takes a different approach to design and this is important to consider. BigQuery on its own is not enough and you need other tools also offered by Google to transform data (some of which I have mentioned in an earlier section).
The BigQuery ecosystem is a little more complex than the Snowflake ecosystem. Those who have traditionally worked on on-premise data warehouses, find Snowflake much easier to set up. Those who are trying to establish warehouses for the first time, find Google easier.
I would rate this solution a 7 out of 10.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Engineer at a recreational facilities/services company with 10,001+ employees
Offers multi-region support, one-stop solution allows to build applications, organize data, structure and structure, and create reporting solutions
Pros and Cons
- "BigQuery can be used for any type of company. It has the capability of building applications and storing data. It can be used for OLTP or OLAP. It has many other products within the Google space."
- "The processing capability can be an area of improvement."
What is our primary use case?
What is most valuable?
BigQuery has got a lot of traditional functionalities. You can store the data. You can process the data.
What needs improvement?
In Teradata, it's very fast compared to BigQuery. The processing capability and inbuilt MPP architecture support processing millions or billions of records in a few seconds. BigQuery faces challenges in processing and retrieving the same data.
So, the processing capability can be an area of improvement.
Another area of improvement is in terms of the storage area, as BigQuery does support some limited types of data storage file format. In order to see the data, we need to store the data in a relational database. So, in the future, they should be capable of querying the data from the data lake.
Before storing it in the RDBMS. At the moment, they don't have this feature for how my raw data looks unless you store the data in tables. Never know what sort of data.
That's one thing, like, definitely they need to improve because before we model the data to explore what kind of data I'm getting in the raw stage then it's easy to, like model and process the data.
For how long have I used the solution?
What do I think about the scalability of the solution?
It supports petabytes of data like Teradata. One advantage of using BigQuery is that it's cloud-based. You don't need additional space or nodes to process growing data. It's auto-scalable, eliminating the need to plan and expand infrastructure as your organization's data grows.
How are customer service and support?
We never had any major issues. However, when comparing technical support between Teradata and BigQuery, Teradata has a larger global support team. BigQuery has comparatively less support from the company to the customer.
We haven't experienced major issues or outages, so it's always available. It's multi-region, and if one server goes down, another server in that region takes over.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
BigQuery can be used for any type of company. It has the capability of building applications and storing data. It can be used for OLTP or OLAP. It has many other products within the Google space.
Teradata, on the other hand, mainly focuses on building databases, storing and processing SysTrack data. BigQuery is an analytical platform where you can store and process data, and Google Cloud Platform has different products for other purposes.
You can build your application or organize data, structure, and structure. You can build reporting solutions on the Google Cloud Platform itself. It has everything - storing, processing, integrating, and building solutions, all in one product.
When comparing BigQuery with Azure scenarios, there are differences. It depends on the organization's requirements and use case.
What's my experience with pricing, setup cost, and licensing?
There are two types of pricing: the storage price and the processing price. Storage is very, very cheap compared to Teradata. But processing, it depends, like, how much of an amount of data you are processing. They charge the query you run on the big query.
What other advice do I have?
In terms of the data warehousing, and data analytical platform, BigQuery is one of the products in the Google Cloud platform. So, I would rate it a nine out of ten in terms of data warehousing.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Owner & Digital Marketing Manager at MPCosta
A very easy-to-use and easy-to-conceptualize tool that is reasonably priced but needs to improve its documentation
Pros and Cons
- "It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
- "There is a good amount of documentation out there, but they're consistently making changes to the platform, and, like, their literature hasn't been updated on some plans."
What is our primary use case?
I use it to deal a lot with marketing, specifically Google Ads, YouTube, and Google Analytics. But mostly, I utilize it for its capabilities to sync directly up with Google ads transfers.
How has it helped my organization?
Instead of having to go directly into the platform, pull various reports after and save those reports, port them over into Google Sheets, and then import ranges and queries. Then, having to transform the data to my needs, I can build a SQL script that is to my needs directly within the platform so that when the data comes out at the platform, it's already essentially punched into the format that I needed.
What is most valuable?
Its SQL editor is very easy to use and very easy to conceptualize. The way that it breaks data down into silos is easily discernible. So, I guess that's really it.
What needs improvement?
There is a good amount of documentation out there, but they're consistently making changes to the platform, and, like, their literature hasn't been updated on some plans.
For how long have I used the solution?
I have been using BigQuery for a little over a year.
What do I think about the stability of the solution?
It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly.
What do I think about the scalability of the solution?
I think that it's easy to scale. For instance, when I need the data for a new client, I just ask to have their account added to my MCC, and the MCC deploys through basically, rolls out all the accounts available really quickly.
I am the sole user of the solution in my company.
How are customer service and support?
I've tried getting in touch with the support, and that's actually the difficult part. So, unless you're using a higher-tiered version of the platform, getting support can be problematic.
Which solution did I use previously and why did I switch?
I got into Google Big Query since it met my needs.
How was the initial setup?
Regarding the deployment model, I work in its native GUI. I'm not sure what the SaaS version is, so I just utilize it with Google Cloud's native console.
Regarding the deployment process, I would have to create your own instance within Google Cloud. You create a project, that project. Then, you start nesting your data streams into that project. And then we do have to backfill some of the data because it'll only start grabbing data from the date that you tell it to in thirty days before. So if you need data that is previous to thirty days, then you've got it going to backfill it. After that, I found that it was a pretty easy and quick deployment.
Speaking about the time for deployment, I would say that having the knowledge I have now, it wouldn't take me even an afternoon. But at the time, because I didn't know what I was doing, it took about two-three days.
What about the implementation team?
I did the deployment myself.
What's my experience with pricing, setup cost, and licensing?
Price-wise, I think that is very reasonable. Like, I don't use a ton of computing when it comes to the platform, so I haven't ever really had to pay when it comes to the product. I really don't have to pay from month to month.
Which other solutions did I evaluate?
I did not go through other solutions.
What other advice do I have?
I would tell those planning to use the solution to just go out and utilize as much information as possible. There's a ton of great information on the platform and how it can be best utilized.
The solution doesn't necessarily require maintenance.
It's a great platform. It's pretty easy to use. You do have to have some skill and uptake when it comes to actually writing SQL and writing queries. But then it does need better support capabilities. But aside from that, it's a pretty good platform.
I rate the solution a seven out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Associate Consultant (Data Engineer) at MediaAgility
Provides flexibility and is competitively priced
Pros and Cons
- "The most valuable features of BigQuery is that it supports standard SQL and provides good performance."
What is our primary use case?
We use BigQuery to perform data warehouse migration for clients willing to move to GCP from their on-premise solution.
What is most valuable?
The solution's pricing is really competitive compared to other peers. The most valuable features of BigQuery is that it supports standard SQL and provides good performance.
For how long have I used the solution?
I have been using BigQuery for three years.
What do I think about the stability of the solution?
I rate BigQuery a nine out of ten for stability.
What do I think about the scalability of the solution?
Around 30 to 40 users use BigQuery in our organization.
I rate BigQuery ten out of ten for scalability.
Which solution did I use previously and why did I switch?
I previously worked with Microsoft SQL Server.
How was the initial setup?
The solution’s initial setup is very easy. You just have to spin up a data set and start using it.
I rate BigQuery ten out of ten for the ease of its initial setup.
What about the implementation team?
The solution can be deployed by one person in a few minutes.
What's my experience with pricing, setup cost, and licensing?
The solution's pricing is cheaper compared to other solutions. On a scale from one to ten, where one is cheap, and ten is expensive, I rate the solution's pricing a two or three out of ten.
What other advice do I have?
Potential users can trust BigQuery without any second thoughts. The solution's pricing is great compared to other solutions. The solution provides more flexibility and supports standard SQL, and anyone coming out from a different platform would not face any challenges adopting BigQuery.
Overall, I rate BigQuery a nine out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Consaltant
A powerful and user-friendly solution for efficient data analytics and processing with serverless architecture, seamless scalability, SQL-like queries and cost-effective pay-as-you-go model
Pros and Cons
- "One of the most significant advantages lies in the decoupling of storage and compute which allows to independently scale storage and compute resources, with the added benefit of extremely cost-effective storage akin to object storage solutions."
- "The main challenges are in the areas of performance and cost optimizations."
What is our primary use case?
It is a pivotal component in enterprise data architecture, and crucial in data lake operations, whether supporting data warehouses or functioning as part of a broader data lake ecosystem.
What is most valuable?
One of the most significant advantages lies in the decoupling of storage and compute which allows to independently scale storage and compute resources, with the added benefit of extremely cost-effective storage akin to object storage solutions. Its unique architecture not only provides robust enterprise data warehouse capabilities but also seamlessly integrates with data lake functionalities.
What needs improvement?
The main challenges are in the areas of performance and cost optimizations. Achieving optimal results demands a certain level of familiarity with the platform's internals. The key point for improvement lies in the performance optimization.
For how long have I used the solution?
I have been working with it for three months.
What do I think about the stability of the solution?
It exhibits a high level of stability and security, there are no notable issues in these aspects. I would rate it nine out of ten.
What do I think about the scalability of the solution?
It is designed to seamlessly scale with the growing demands of data processing, there are no issues with it. I would rate it nine out of ten.
How are customer service and support?
The technical support is commendable. However, there is room for improvement in the availability of resources and documentation from a technological standpoint. I would rate it seven out of ten.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
In the landscape of enterprise data warehouses, BigQuery stands out as a superior choice when compared to alternatives like Azure Synapse, AWS Redshift, and Snowflake. While Snowflake is known for its higher costs, and Redshift is perceived as both complex and expensive, Azure Synapse presents its own set of constraints with its MPP architecture and reliance on an RDBMS in-between. BigQuery, on the other hand, has a distinct edge with its seamless migration process, vast capabilities, and a harmonious balance of storage, computing, cost-effectiveness, and performance efficiency. This is particularly evident as organizations and professionals, including myself, have experienced ease in migrating from other vendors to BigQuery. Drawing from my extensive experience working across various cloud platforms such as AWS, Azure, and Snowflake, BigQuery consistently emerges as a robust and preferable solution.
How was the initial setup?
The initial setup is straightforward.
What's my experience with pricing, setup cost, and licensing?
Its cost structure operates on a pay-as-you-go model. I would rate it seven out of ten.
What other advice do I have?
Whether for small, medium, or large enterprises, it is a recommendable choice. Its pricing model makes it accessible and manageable based on your usage. Given that many individuals and businesses already have Gmail accounts and utilize Google Cloud workspaces, incorporating BigQuery into operations is seamless. Moreover, a complimentary reporting tool, Looker Studio, is available for free, enhancing the reporting capabilities on BigQuery or via Google Sheets. Overall, I would rate it eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Full-stack Developer at ViewersLogic
Fast, flexible, scalable, stable, and easy to learn
Pros and Cons
- "What I like most about BigQuery is that it's fast and flexible. Another advantage of BigQuery is that it's easy to learn."
- "An area for improvement in BigQuery is its UI because it's not working very well. Pricing for the solution is also very high."
What is our primary use case?
My company uses BigQuery as a data warehouse.
What is most valuable?
What I like most about BigQuery is that it's fast and flexible.
Another advantage of BigQuery is that it's easy to learn.
You can also use it from anywhere.
What needs improvement?
An area for improvement in BigQuery is its UI because it's not working very well.
Pricing for the solution is also very high.
In general, though, I like the solution very much.
For how long have I used the solution?
I've been using BigQuery for six months now.
What do I think about the stability of the solution?
I found BigQuery stable in my six months of using it, and I'd rate its stability as ten out of ten.
What do I think about the scalability of the solution?
BigQuery is a scalable solution, and it's a nine out of ten in terms of scalability.
How are customer service and support?
I've never interacted with BigQuery support.
Which solution did I use previously and why did I switch?
We used Redshift as a database for our operations, but now, we've moved to BigQuery because BigQuery is much more than a database. It has more features than Redshift, and we hope to pay less than what we paid when we were using Redshift because Redshift required us to pay ahead each month, and the total cost was too much.
How was the initial setup?
BigQuery was easy to set up, but you'll need to learn how to do it. In general, the initial setup is straightforward.
I'd rate the BigQuery setup as eight out of ten.
What about the implementation team?
Our in-house team implemented BigQuery for the company.
What's my experience with pricing, setup cost, and licensing?
BigQuery pricing can increase quickly. It's a high-priced solution.
It would help if you researched how to reduce the price. It would take some time to find out how to set up BigQuery in a way that reduces its pricing.
What other advice do I have?
My company is using a data warehouse solution called BigQuery.
My advice to anyone deciding on using BigQuery is to be aware of the pricing mechanism and have a better understanding of it to avoid surprises. You pay for what you use, so it could be very easy to lose control, which means the BigQuery costs could go up fast.
I'd rate BigQuery as nine out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free BigQuery Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Product Categories
Cloud Data WarehousePopular Comparisons
Azure Data Factory
Snowflake
Teradata
Microsoft Azure Synapse Analytics
Vertica
Dremio
AWS Lake Formation
Oracle Autonomous Data Warehouse
SAP Business Warehouse
Yellowbrick Cloud Data Warehouse
Buyer's Guide
Download our free BigQuery Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which ETL or Data Integration tool goes the best with Amazon Redshift?
- What are the main differences between Data Lake and Data Warehouse?
- What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
- What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?
- Are there any general guidelines to allocate table space quota to different layers in ETL?
- What cloud data warehouse solution do you recommend?
- Can you please help me understand cloud databases?
- bitmap index as preferred choice in data warehousing environment
- Why do you recommend using a cloud data warehouse?