Product Manager at a tech services company with 1,001-5,000 employees
Real User
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.

Buyer's Guide
BigQuery
April 2024
Learn what your peers think about BigQuery. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,924 professionals have used our research since 2012.

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.
Flag as inappropriate
PeerSpot user
PradeepKumar3 - PeerSpot reviewer
Director Technology Solutions at Redintegro Consulting Solution LLP
Real User
Top 5Leaderboard
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.
Flag as inappropriate
PeerSpot user
Buyer's Guide
BigQuery
April 2024
Learn what your peers think about BigQuery. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,924 professionals have used our research since 2012.
PeerSpot user
Data architect at a media company with 201-500 employees
Real User
Top 10
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.
PeerSpot user
Shan-Khan - PeerSpot reviewer
Senior Data Scientist at a tech services company with 51-200 employees
Real User
Excellent pricing, fantastic capabilities with online documentation for support
Pros and Cons
  • "When integrating their system into the cloud-based solutions, we were able to increase their efficiency and overall productivity twice compared with their on-premises option."
  • "The initial setup could be improved making it easier to deploy."

What is our primary use case?

Our primary use case is for data processing and searching the data. It is basically a data warehouse. We use BigQuery to process and store the data and gather the data from BigQuery to build machine learning models.

How has it helped my organization?

When integrating their system into the cloud-based solutions, we were able to increase their efficiency and overall productivity twice compared with their on-premises option.

What is most valuable?

The data warehouse has all the features that are contained in the data warehouse solution.

What needs improvement?

The initial setup could be improved making it easier to deploy.

For how long have I used the solution?

I have been using BigQuery for the past three years now.

What do I think about the stability of the solution?

The stability ranks around a seven or an eight on a scale of one to ten.

What do I think about the scalability of the solution?

On a scale of one to ten, the scalability is around an eight.

How are customer service and support?

When it comes to customer support I have found some really good documentation online.

Which solution did I use previously and why did I switch?

When comparing with Azure in the past the difference was the price was cheaper. Google and Azure were offering the same features.

How was the initial setup?

The initial setup is somewhere in the middle between straightforward and complex. You do need some experience or initial skills when setting it up.

What's my experience with pricing, setup cost, and licensing?

The pricing is good and there are no additional costs involved.

What other advice do I have?

I would rate BigQuery a nine out of ten on the overall scale.

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: Integrator
PeerSpot user
Cloud Architect at Techolution
MSP
Top 10
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.
PeerSpot user
Chief System Architect at a comms service provider with 11-50 employees
Real User
Top 5
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
PeerSpot user
Machine Learning Enginee at a retailer with 201-500 employees
Real User
Top 20
Able to expand with lots of functionality but needs better machine learning capabilities
Pros and Cons
  • "The setup is simple."
  • "I noticed recently it's more expensive now."

What is our primary use case?

We use BigQuery as a data source.

We mainly use it to do some transformations. Once we collect query data from it, we use other services to do model training or predictions. We don't really utilize all the features provided by BigQuery. We mainly use some basic data transformation options. It also provides some machine learning models.

What is most valuable?

In many functions, it's very similar to Spark Kubernetes. The cluster is good. It'll provide computation capabilities. 

The setup is simple.

It is stable. The performance is good. 

It is a scalable solution. 

We do not find the solution that expensive. 

What needs improvement?

Machine learning could be improved. There are some machine learning models in BigQuery; however, maybe more libraries can be provided. We'd like it extended into the Spark ML library. 

I noticed recently it's more expensive now. I didn't compare them to others, however, and in our team, we don't consider the price of it much.

For how long have I used the solution?

I've been using the solution for several months.

What do I think about the stability of the solution?

It is stable and reliable. There are no bugs or glitches. 

I'd rate the overall stability an eight out of ten. It offers a good level of performance. There are billions of accounts. 

What do I think about the scalability of the solution?

It's scalable. We don't need to worry about scalability issues in our case. For us, it's good enough.

We have millions of customers and thousands of products. 

How are customer service and support?

I've never dealt with technical support. I can't speak to how helpful or responsive they are. We have a bigger team and tend to learn from each other.

Which solution did I use previously and why did I switch?

I also use Spark, which has similar functions. I've also used Databricks. 

I've used BigQuery for a longer time, however, Databricks is easier when it comes to the setup of a complete solution. With BigQuery, we need to develop an intranet solution and set up services and then put them together.

How was the initial setup?

It is my understanding that the initial setup is very straightforward and simple. 

What's my experience with pricing, setup cost, and licensing?

The pricing is fine. 

What other advice do I have?

I'd rate the solution seven out of ten. It's a pretty good product overall. 

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
PeerSpot user
Buyer's Guide
Download our free BigQuery Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Cloud Data Warehouse
Buyer's Guide
Download our free BigQuery Report and get advice and tips from experienced pros sharing their opinions.