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.
"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."
"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 interface is what I find particularly valuable."
"The setup is simple."
"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."
"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."
"It's similar to a Hadoop cluster, except it's managed by Google."
"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."
"The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do."
"The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"This solution has helped our organization by being easy to maintain and having good technical support."
"The pricing is reasonable and matches the rest of the market."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"The most valuable feature has been the Snowflake data sharing and dynamic data masking."
"I noticed recently it's more expensive now."
"An area for improvement in BigQuery is its UI because it's not working very well. Pricing for the solution is also very high."
"I understand that Snowflake has made some improvements on its end to further reduce costs, so I believe BigQuery can catch up."
"We would like to be able to calibrate the solution to run on top of a raw file."
"The product’s performance could be much faster."
"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."
"Some of the queries are complex and difficult to understand."
"The main challenges are in the areas of performance and cost optimizations."
"Its stability could be better."
"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."
"They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
"The solution could use a little bit more UI."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
"Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."
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 Amazon EMR. 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.