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.
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?
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.
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?
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.
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.
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: 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?