We performed a comparison between BigQuery and Snowflake Analytics based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The integrated data storage features are good."
"The initial setup is straightforward."
"It has a well-structured suite of complimentary tools for data integration and so forth."
"The interface is what I find particularly valuable."
"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."
"It's pretty stable. It's fast, and it is able to go through large quantities of data pretty quickly."
"The product’s most valuable feature is its ability to manage the database on the cloud."
"There are some performance features like partitioning, which you can do based on an integer, and it improves the performance a lot."
"The computational power of Snowflake is very good."
"I am impressed with the product's data-sharing feature."
"Deployment is straightforward as it's a SaaS product. No maintenance required."
"The most valuable feature of Snowflake Analytics is its performance."
"Considering everything I have accessed, the product's dashboard is good since it provides multiple good options, including customization options."
"It's a scalable solution because you can analyze a huge amount of data in the solution."
"Scaling is very high – there's no problem for scaling purposes. The learning curve is very small. And there are a lot of advanced features like handling duplicates, security, data governance, data sharing, and data cloning."
"The platform not only provides ease of use but also stands out for its speedy execution, conveying a sense of robustness and reliability that I find appealing."
"We'd like to have more integrations with other technologies."
"I would like to see version-based implementation and a fallback arrangement for data stored in BigQuery storage. These are some features I'm interested in."
"The solution hinges on Google patterns so continued improvement is important."
"We would like to be able to calibrate the solution to run on top of a raw file."
"I noticed recently it's more expensive now."
"The main challenges are in the areas of performance and cost optimizations."
"The process of migrating from Datastore to BigQuery should be improved."
"We'd like to see more local data residency."
"The distribution methodology isn't as strong as Bethesda or SAP HANA. It's not as strong as other competitors."
"The solution’s interface is good but it could be improved."
"There are issues while loading data from Snowflake Analytics to the Power BI reporting."
"Implementing everything on-premise is challenging because it require proper support from advisors, DBAs, and others."
"Snowflake's Snowpark is an area of concern where improvements are required."
"The platform could work easier for AI implementation compared to one of its competitors."
"The UI could be more user-friendly."
"Snowflake could improve in the areas of advanced machine learning AML and generative AI."
BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while Snowflake Analytics is ranked 7th in Cloud Data Warehouse with 30 reviews. BigQuery is rated 8.2, while Snowflake Analytics 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 Analytics writes "A scalable tool useful for data lake and data mining processes". BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse, Vertica and Apache Hadoop, whereas Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox. See our BigQuery vs. Snowflake Analytics 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.