We compared Snowflake and BigQuery based on our user's reviews in several parameters.
Snowflake is praised for its high performance, scalability, and ease of use, as well as its excellent customer service and reasonable pricing. On the other hand, BigQuery stands out for its robust scalability, efficient performance, seamless integration, and positive ROI. BigQuery users have also highlighted exceptional customer service and transparent pricing, while suggesting areas for improvement in optimization, performance, and integrations.
Features: Snowflake's most valuable features lie in its high performance, scalability, and ease of use. Users appreciate its ability to handle large volumes of data efficiently, with seamless scalability and a user-friendly interface. On the other hand, BigQuery is known for its robust scalability and efficient performance. It also offers seamless integration with other Google Cloud services, flexibility in handling large datasets, and a user-friendly interface.
Pricing and ROI: Snowflake's setup cost is appreciated for its reasonable and competitive pricing, straightforward process, and flexible licensing terms. In comparison, BigQuery boasts a minimal setup cost, enabling a quick and hassle-free implementation process, with a fair and transparent pricing structure. Both products accommodate various user needs and requirements., The user reviews indicate that Snowflake's ROI has been positive. BigQuery's ROI, on the other hand, has led to significant cost savings, improved data analysis capabilities, faster query speed, enhanced efficiency, increased productivity, better decision-making processes, and positive business growth.
Room for Improvement: Snowflake could benefit from enhancements to enhance user experience and functionality. User feedback for BigQuery suggests the need for better optimization and performance when handling larger datasets. Improving query execution time, enhancing reliability and stability, expanding integrations and supporting more data sources, simplifying the user interface, and providing intuitive documentation have been recommended for BigQuery to enhance user experience.
Deployment and customer support: The reviews indicate that for Snowflake, it is necessary to evaluate deployment and setup durations separately, considering different amounts of time spent on each phase, while for BigQuery, both deployment and setup durations should be taken into account depending on the context mentioned by users. No specific user quotes were provided for BigQuery., Snowflake's customer service has received positive feedback for its promptness, effectiveness, and expertise in resolving issues. Customers appreciate their responsiveness and willingness to address concerns. In comparison, BigQuery's customer service is highly praised for its responsiveness, helpfulness, and expertise in explaining and solving queries. Overall, both companies offer exceptional customer service and support.
The summary above is based on 71 interviews we conducted recently with Snowflake and BigQuery users. To access the review's full transcripts, download our report.
"It stands out in efficiently handling internal actions without the need for manual intervention in tasks like building cubes and defining final dimensions."
"Even non-coders can review the data in BigQuery."
"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."
"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."
"What I like most about BigQuery is that it's fast and flexible. Another advantage of BigQuery is that it's easy to learn."
"The main thing I like about BigQuery is storage. We did an on-premise BigQuery migration with trillions of records. Usually, we have to deal with insufficient storage on-premises, but in BigQuery, we don't get that because it's like cloud storage, and we can have any number of records. That is one advantage. The next major advantage is the column length. We have some limits on column length on-premises, like 10,000, and we have to design it based on that. However, with BigQuery, we don't need to design the column length at all. It will expand or shrink based on the records it's getting. I can give you a real-life example based on our migration from on-premises to GCP. There was a dimension table with a general number of records, and when we queried that on-premises, like in Apache Spark or Teradata, it took around half an hour to get those records. In BigQuery, it was instant. As it's very fast, you can get it in two or three minutes. That was very helpful for our engineers. Usually, we have to run a query on-premises and go for a break while waiting for that query to give us the results. It's not the case with BigQuery because it instantly provides results when we run it. So, that makes the work fast, it helps a lot, and it helps save a lot of time. It also has a reasonable performance rate and smart tuning. Suppose we need to perform some joins, BigQuery has a smart tuning option, and it'll tune itself and tell us the best way a query can be done in the backend. To be frank, the performance, reliability, and everything else have improved, even the downtime. Usually, on-premise servers have some downtime, but as BigQuery is multiregional, we have storage in three different locations. So, downtime is also not getting impacted. For example, if the Atlantic ocean location has some downtime, or the server is down, we can use data that is stored in Africa or somewhere else. We have three or four storage locations, and that's the main advantage."
"BigQuery excels at structuring data, performing predictions, and conducting insightful analyses and it leverages machine learning and artificial intelligence capabilities, powered by Google's Duarte AI."
"The initial setup process is easy."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere."
"A user-friendly and reliable solution."
"The solution speeds up the process of onboarding."
"The most valuable feature of Snowflake is it's an all-in-one data warehousing solution."
"The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs."
"This solution has helped our organization by being easy to maintain and having good technical support."
"The most valuable feature has been the Snowflake data sharing and dynamic data masking."
"With other columnar databases like Snowflake, you can actually increase your VM size or increase your machine size, and you can buy more memory and it will start working faster, but that's not available in BigQuery. You have to actually open a ticket and then follow it up with Google support."
"An area for improvement in BigQuery is its UI because it's not working very well. Pricing for the solution is also very high."
"The primary hurdle in this migration lies in the initial phase of moving substantial volumes of data to cloud-based platforms."
"I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up."
"The processing capability can be an area of improvement."
"I rate BigQuery six out of 10 for affordability. It could be cheaper."
"As a product, BigQuery still requires a lot of maturity to accommodate other use cases and to be widely acceptable across other organizations."
"The solution should reduce its pricing."
"Its stability could be better."
"The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."
"I think that Snowflake could improve its user interface. The current one is not interactive."
"It's difficult to know how to size everything correctly."
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."
"There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source."
"Its transaction application needs improvement."
"They don't have any SLAs in place. It would be better if they did."
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 92 reviews. BigQuery is rated 8.2, while Snowflake is rated 8.4. The top reviewer of BigQuery writes "Expandable and easy to set up but needs more local data residency". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". BigQuery is most compared with Teradata, Oracle Autonomous Data Warehouse, Vertica, Apache Hadoop and AWS Lake Formation, whereas Snowflake is most compared with Azure Data Factory, Teradata, Vertica, AWS Lake Formation and Oracle Autonomous Data Warehouse. See our BigQuery vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.