I like that we can synch and run a large query. I also like that we can work with a large amount of data. You don't need to work separately, as it's a ready-made solution. It also comes with a built-in machine-learning feature. Once we start inputting the data, it will suggest some things related to the data, and we can come up with nice dashboards and statistics from a vast amount of data.
Program Manager at a tech services company with 201-500 employees
A fully-managed, serverless data warehouse with a useful machine learning feature
Pros and Cons
- "I like that we can synch and run a large query. I also like that we can work with a large amount of data. You don't need to work separately, as it's a ready-made solution. It also comes with a built-in machine-learning feature. Once we start inputting the data, it will suggest some things related to the data, and we can come up with nice dashboards and statistics from a vast amount of data."
- "The price could be better. Compared to competing solutions, BigQuery is expensive. It's only suitable for enterprise customers, not small and medium-sized businesses, as they cannot afford this kind of solution. In the next release, it would be better if they improved their AI bot. Although machine learning and artificial intelligence are doing wonders, there is still a lot of room to enhance them."
What is most valuable?
What needs improvement?
The price could be better. Compared to competing solutions, BigQuery is expensive. It's only suitable for enterprise customers, not small and medium-sized businesses, as they cannot afford this kind of solution.
In the next release, it would be better if they improved their AI bot. Although machine learning and artificial intelligence are doing wonders, there is still a lot of room to enhance them.
For how long have I used the solution?
I have been working with BigQuery for two and a half years.
What do I think about the stability of the solution?
BigQuery is a stable solution.
Buyer's Guide
BigQuery
December 2024
Learn what your peers think about BigQuery. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
What do I think about the scalability of the solution?
BigQuery is a scalable solution. At present, we have about five different users using this solution. But BigQuery is handling the data of 3,000,000 customers.
How are customer service and support?
We subscribed to technical support from Google. Whenever my team finds an issue, they contact support. I did not get a chance to contact the support team because we never had any difficulties or glitches while configuring it.
How was the initial setup?
The initial setup is relatively straightforward. It's not simple, and it's not very complex. We are doing maintenance of our regular cloud services and working with some assistants and microservice architecture. I don't think we have ever set up in less than one day.
What about the implementation team?
We implemented this solution.
What's my experience with pricing, setup cost, and licensing?
The price could be better. Usually, you need to buy the license for a year. Whenever you want more, you can subscribe to it, and you can use it. Otherwise, you can terminate the license. You can use it daily or monthly, and we use it based on a project's requirements.
What other advice do I have?
On a scale from one to ten, I would give BigQuery a nine.
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
Product Manager at a tech services company with 1,001-5,000 employees
A stable and easy-to-deploy solution that provides excellent features to refine and analyze data
Pros and Cons
- "Even non-coders can review the data in BigQuery."
- "The process of migrating from Datastore to BigQuery should be improved."
What is our primary use case?
We are into conversational commerce platforms. All the conversations and the chat history are captured when we chat with a chatbot. Our application is built on NoSQL. We put the data into BigQuery as a data warehouse, where we refine the data. We analyze the chat history and give analytic reports to our merchants using our SaaS platform. It is to understand the chat conversation, how many people had a conversation, and what key buttons they clicked.
We also provide analytics on how many orders were completed. We are building a commerce and conversational dashboard for our enterprise customers and offering them on Looker. Looker was earlier known as Google Data Studio. For applications, we segment customers and use the customer segments to broadcast messages across social channels. All these things are being queried over BigQuery to do segmentations.
On the front end, we give them the option of segmenting based on different data attributes. Then, it goes to BigQuery to filter out the data and find the number of customers who meet the defined conditions. Based on that, we send the messages to the segmented customers. We are doing multiple things related to conversation commerce using BigQuery.
What is most valuable?
It is a cloud platform. We just need to query and get the output. Anyone can use the product. Even non-coders can review the data in BigQuery.
What needs improvement?
There should be an easier way to migrate from NoSQL to SQL. The process of migrating from Datastore to BigQuery should be improved. We use Datastore and BigQuery. If both products can be synced well, it will improve employee productivity.
We had to write a lot of pipelines and logic for real-time streaming from Datastore, which is a NoSQL, to BigQuery, which is more of a structured database. However, because both products are internal to the Google Cloud Platform, they should have some provision to create and keep syncing it automatically. It will be an advantage for the customers. Currently, we build replicas. It would be easier if some simple connection replicates the changes in BigQuery.
For how long have I used the solution?
My company has been using the solution for five years. I have been using it for a year.
What do I think about the stability of the solution?
I rate the product’s stability a nine out of ten.
What do I think about the scalability of the solution?
The solution is more scalable because it is in the cloud. It is an advantage. I rate the scalability of the tool an eight out of ten. If we are integrating it with two different platforms, then it becomes a little difficult for us. If there is a data pipeline error, we cannot scale immediately. If we have to integrate NoSQL with BigQuery, it sometimes becomes a challenge for real-time streaming.
Five developers within my team are building all the logic on BigQuery. We have around 100 to 200 customers with five to six employees each using our platform. When they use our platform and query using different features, these queries hit BigQuery, and we render the data. We are the designers designing using BigQuery, and the end users use the UI.
How are customer service and support?
I would rate technical support a little less. We have always struggled to get quicker support.
How was the initial setup?
The initial setup is very simple. The solution is cloud-based.
What's my experience with pricing, setup cost, and licensing?
The tool has competitive pricing. I rate the pricing an eight out of ten.
What other advice do I have?
I have a technical team that works deeply into it and gives me the output. I don't extensively use BigQuery as a developer to develop things. Overall, I rate the solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
BigQuery
December 2024
Learn what your peers think about BigQuery. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Director Technology Solutions at Redintegro Consulting Solution LLP
Stable product with good features for database management
Pros and Cons
- "The product’s most valuable feature is its ability to manage the database on the cloud."
- "The product’s performance could be much faster."
What is our primary use case?
We use BigQuery for data warehousing purposes.
What is most valuable?
The product’s most valuable feature is its ability to manage the database on the cloud.
What needs improvement?
The product’s performance could be much faster.
For how long have I used the solution?
We have been using BigQuery for four years.
What do I think about the stability of the solution?
I rate BigQuery’s stability a ten out of ten.
What do I think about the scalability of the solution?
We have two to three BigQuery users in our company. I rate its scalability an eight out of ten.
Which solution did I use previously and why did I switch?
We have used many databases such as Oracle, MySQL, MongoDB, etc. We switched to BigQuery for better database management. Using it, we only need to focus on data ingestion and generating query output.
How was the initial setup?
The initial setup is easy.
What about the implementation team?
We implemented the product in-house.
What's my experience with pricing, setup cost, and licensing?
The product’s pricing could be more flexible for end users.
What other advice do I have?
I recommend BigQuery to others and rate it a nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data architect at a media company with 201-500 employees
Cost-effective, performs well, and is reliable
Pros and Cons
- "The most valuable features of this solution, in my opinion, are speed and performance, as well as cost-effectiveness."
- "I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up."
What is our primary use case?
I would say that for our use cases, sticking with BigQuery made sense because we were using Google Analytics Data, which has direct integration with BigQuery.
What is most valuable?
The most valuable features of this solution, in my opinion, are speed and performance, as well as cost-effectiveness.
What needs improvement?
I haven't done much research on other competitors. As previously stated, I am unfamiliar with the Azure and AWS counterparts. I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up.
I have heard that BigQuery is being expanded to become more of a Lakehouse to support unstructured data, and I am looking forward to that.
For how long have I used the solution?
I have been working with BigQuery for one year.
What do I think about the stability of the solution?
BigQuery is very stable.
How are customer service and support?
I have not had any contact with technical support.
Which solution did I use previously and why did I switch?
The major cloud providers' cloud solutions. We are using BigQuery for the Data Warehouse. And much of the stack we're working with is open source. If you've heard of the modern data stack, we've used a lot of them, such as DBT for data transformation and so on, which isn't really commercial, off-the-shelf software.
What's my experience with pricing, setup cost, and licensing?
BigQuery is inexpensive.
Which other solutions did I evaluate?
We had previously evaluated products such as Informatica MDM, Microsoft MDS, Informatica Cloud Test Data Manager, IBM InfoSphere MDM, and Tipco XBX; however, I was unable to secure management funding to implement these solutions. I left the company I was working for at the time, and yes, I stopped focusing on MDM. I just focused on my bread and butter, which is BI.
What other advice do I have?
The company is an enterprise customer of Google.
I would rate BigQuery an eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Cloud Architect at Techolution
A serverless solution that helps with data analysis
Pros and Cons
- "The product is serverless. We only need to write SQL queries to analyze the data. We need to pay based on the number of queries. The retrieval time is very less. Even if you write large queries, the tool is able to bring back data in a few seconds."
- "The solution should reduce its pricing."
What is our primary use case?
The solution is mostly used for data analysis. We can store data and use the tool for data analysis.
What is most valuable?
The product is serverless. We only need to write SQL queries to analyze the data. We need to pay based on the number of queries. The retrieval time is very less. Even if you write large queries, the tool is able to bring back data in a few seconds.
What needs improvement?
The solution should reduce its pricing.
For how long have I used the solution?
I have been working with the product for more than five years.
What do I think about the stability of the solution?
The product's stability is great because of Google's servers.
What do I think about the scalability of the solution?
The solution is scalable and we can scale up to petabytes of data. My company has more than 100 users for the product.
How are customer service and support?
We seek support whenever there are quota issues.
How was the initial setup?
The product's setup is straightforward. The solution's setup does not take more than 30 minutes to complete. We need to create datasets and within the datasets, we need to create tables.
What's my experience with pricing, setup cost, and licensing?
1 TB is free of cost monthly. If you use more than 1 TB a month, then you need to pay 5 dollars extra for each TB.
What other advice do I have?
I would rate the solution a nine out of ten. SQL knowledge is required to work on the query.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Chief System Architect at a comms service provider with 11-50 employees
It's a stable, fully managed solution, but it's a little pricey
Pros and Cons
- "We like the machine learning features and the high-performance database engine."
- "I rate BigQuery six out of 10 for affordability. It could be cheaper."
What is our primary use case?
We use BigQuery for data warehousing.
What is most valuable?
We like the machine learning features and the high-performance database engine.
For how long have I used the solution?
I have used BigQuery for about three years.
What do I think about the stability of the solution?
I rate BigQuery 10 out of 10 for stability.
What do I think about the scalability of the solution?
I rate BigQuery 10 out of 10 for scalability because it's a fully managed solution.
How was the initial setup?
Setting up BigQuery is easy because it's a managed database.
What's my experience with pricing, setup cost, and licensing?
I rate BigQuery six out of 10 for affordability. It could be cheaper.
Which other solutions did I evaluate?
We compared BigQuery to Oracle. In my opinion, BigQuery is better because it's fully managed and less expensive.
What other advice do I have?
I rate BigQuery seven out of 10.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Buyer's Guide
Download our free BigQuery Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 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?
- When evaluating Cloud Data Warehouse, what aspect do you think is the most important to look for?
- bitmap index as preferred choice in data warehousing environment
- Why do you recommend using a cloud data warehouse?