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.
"We basically used it to store server data and generate reports for enterprise architects. It was a valuable tool for our enterprise design architect."
"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 initial setup process is easy."
"The solution's reporting, dashboard, and out-of-the-box capabilities match exactly our requirements."
"There are some performance features like partitioning, which you can do based on an integer, and it improves the performance a lot."
"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."
"The feature called calibrating the capacity is valuable."
"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications."
"All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services."
"The querying speed is fast."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"It is very fast and the performance is great."
"For greater flexibility and ease of use, it would be beneficial if BigQuery offered more third-party add-ons and connectors, particularly for databases that don't have built-in integration options."
"The process of migrating from Datastore to BigQuery should be improved."
"The processing capability can be an area of improvement."
"We'd like to see more local data residency."
"So our challenge in Yemen is convincing many people to go to cloud services."
"I rate BigQuery six out of 10 for affordability. It could be cheaper."
"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."
"When it comes to queries or the code being executed in the data warehouse, the management of this code, like integration with the GitHub repository or the GitLab repository, is kind of complicated, and it's not so direct."
"There is room for improvement in Snowflake's integration with Python. We do a lot of SQL programming in Snowflake, but we go to a different tool to program when we have to in Python."
"In future releases, it can also support full unstructured data."
"To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"There are three things that came to my notice. I am not very sure whether they have already done it. The first one is very specific to the virtual data warehouse. Snowflake might want to offer industry-specific models for the data warehouse. Snowflake is a very strong product with credit. For a typical retail industry, such as the pharma industry, if it can get into the functional space as well, it will be a big shot in their arm. The second thing is related to the migration from other data warehouses to Snowflake. They can make the migration a little bit more seamless and easy. It should be compatible, well-structured, and well-governed. Many enterprises have huge impetus and urgency to move to Snowflake from their existing data warehouse, so, naturally, this is an area that is critical. The third thing is related to the capability of dealing with relational and dimensional structures. It is not that friendly with relational structures. Snowflake is more friendly with the dimensional structure or the data masks, which is characteristic of a Kimball model. It is very difficult to be savvy and friendly with both structures because these structures are different and address different kinds of needs. One is manipulation-heavy, and the other one is read-heavy or analysis-heavy. One is for heavy or frequent changes and amendments, and the other one is for frequent reads. One is flat, and the other one is distributed. There are fundamental differences between these two structures. If I were to consider Snowflake as a silver bullet, it should be equally savvy on both ends, which I don't think is the case. Maybe the product has grown and scaled up from where it was."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 94 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.