Snowflake

Snowflake

336 Reviews and Ratings

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Snowflake	Score 9.0 out of 10	N/A	The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.	N/A

Pricing

Snowflake

Editions & Modules

No answers on this topic

Offerings

Pricing Offerings
Snowflake
Free Trial
Yes
Free/Freemium Version
No
Premium Consulting/Integration Services
No

Entry-level Setup Fee

No setup fee

Additional Details

—

More Pricing Information

Community Pulse
	Snowflake
Considered Both Products	Snowflake Harvey Wyche Director of Technical Product Management Chose Snowflake In my opinion, the other tools have similar and some different features; however, when I ran proof of technologies between Synapse and Snowflake. Snowflake did things better or just had functionality that the other tools did not. One that stuck out at the time was scale up … Incentivized Helpful? Verified User Analyst Chose Snowflake Compared to Amazon Redshift, Snowflake is slightly easier and faster to achieve ROI but based on the user's perspective, the two tools have very little difference since both are leveraging SQL to pull data from AWS S3. Snowflake is also working with Microsoft Azure but it is … Incentivized Helpful? David Williams Head of Engineering Chose Snowflake We particularly liked Snowflake's security model as well as its unique storage (whereby everything is essentially a pointer to immutable micro-partitions, which is the key behind its zero-copy cloning, its secure sharing, its time travel, etc.). and also how it separates … Incentivized Helpful? Verified User Project Manager Chose Snowflake Cloud -Native architecture, Separation of Storage and Compute provides flexibility, Scalable Compute, Cost and Data Security Incentivized Helpful? Jeremy Pierce, MBA Data Warehouse Engineer Chose Snowflake We had a MS SQL server with over 2 TB of ram & 51 processors that we were using, that could no longer handle our workload. Snowflake can handle 3 times that workload with ease and efficiency. Incentivized Helpful? Verified User Analyst Chose Snowflake Snowflake is much faster and easier to write queries and pull data. But the visualization part of Snowflake is not as good as them. Also, Snowflake only supports SQL queries but not python or other languages. So basically Snowflake is the expert in its field but not suitable … Incentivized Helpful? Verified User Analyst Chose Snowflake Snowflake is a lot faster, feels more lightweight, and is overall easier for our BI team to manage and grant warehouse accesses. Incentivized Helpful? YK Yogesh Kulkarni Principal Consultant Chose Snowflake While Snowflake is more open to cloud eco system, SAP integrated well with SAP eco system products like SAP ECC or SAP S/4. So for people who have invested heavily in SAP eco system including SAP ECC or S/4, it makes sense to go with SAP DWC which is also evolving very rapidly. … Incentivized Helpful? Verified User Analyst Chose Snowflake Since we switch from Amazon Redshift to Snowflake, we found Snowflake is much better than redshift in many ways, including the data integrate and data pull. However, comparing directly pull data from Amazon S3, Snowflake is quite slow in terms of data pull speed and the more … Incentivized Helpful? DW dave withers Sr Director Chose Snowflake Each of the other solutions were cloud vendor specific, Snowflake can ride on either Amazon Web Services, Microsoft Azure, or Google Cloud. The fact that they are ANSI-sql compliant and have an effective means of offloading data makes them portable and easy to sell to teams … Incentivized Helpful? MS Michael Sprague Director Chose Snowflake Azure and Snowflake compared very similarly, but Snowflake provided more options to integrate and connect with tools/companies that were not partners. It seemed to be a more flexible environment. The barrier for entry on Oracle and Google we just too complicated. In particular, … Incentivized Helpful? RV Rounak Verma Data Analyst Chose Snowflake I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system … Incentivized Helpful? Darren Mihalic Business Development Manager Chose Snowflake Snowflake has won the match because it is giving an excellent performance with its efficient features and reliable results. This is a totally secure program for our precious and important data. Incentivized Helpful? Verified User Engineer Chose Snowflake Our initial data warehousing solution was Treasure Data. We had issues with the costly pricing model, which would be exhorbitant if we want to hold our data in memory and query using Presto. As a result, some heavy lifting was done in Hive (managed by Treasure Data); … Incentivized Helpful? Verified User Engineer Chose Snowflake Snowflake beats these other products in every category it was rated against Incentivized Helpful? Brian Bickell Data Practice Director Chose Snowflake In my experience running the data management practice at InterWorks, we believe that cloud data warehouse products will eventually serve the majority of data warehousing use cases and power data analytics at most companies. Of this cohort, we believe that Snowflake is the best … Incentivized Helpful? Verified User Team Lead Chose Snowflake Redshift compute and storage can be scaled up/down together (though they added some features recently, they don't quite add up). I haven't tried Avalanche or Firebolt but would love to in the near future, due to their pedigree or revolutionary billing methods. Incentivized Helpful? Verified User Engineer Chose Snowflake - Cost was the main aspect on the decision. - Performance was in par or better compared to other tools in the market. - Snowflake in my opinion stacks better than other tools I have used in the past. Incentivized Helpful? Sudarshan Kothari Lead Analyst Chose Snowflake Accommodates future data types such as JSON and XML. Scalability is another advantage. Pay per use is beneficial for organizations like yours. Direct connectors with AWS help us to go with it. No limit on user creation and clone data not eating up extra disk space are a few … Incentivized Helpful? Duncan Hernandez Product Owner, Business Intelligence Chose Snowflake Our issue with Redshift was that it was very expensive. On top of that, queries were still slow and if we used more of Redshift's memory, then it would have cost even more. Snowflake is not cheap, but less costly for us. Plus, the performance was much better. Also, we got to … Incentivized Helpful? Jake Schlingman Product Manager Chose Snowflake For us our previous solution in this space was Redshift which we found to be much less reliable and was hardware capped. There may very well be cloud options that our company just wasn't utilizing. For us, queries constantly ran out of memory and failed. Even when they didn't … Incentivized Helpful? Verified User Analyst Chose Snowflake Delivered as an easy-to-use data warehouse service, Snowflake enables you to process and analyze all your diverse data, build multiple databases, query with a common robust ANSI SQL environment, and execute ACID transnational capabilities. No need to create indexes and optimize … Incentivized Helpful? Andrew Goss Data Engineer Chose Snowflake The average percentage of time that a data warehouse is actually doing something is around 20%. Given this, the price by query estimate becomes an important pricing consideration. For this, Snowflake crucially decouples of storage and compute. With Snowflake you pay for 1) … Incentivized Helpful? Jacob Biguvu Database Engineer/DBA (Cloud and On-Premises) Chose Snowflake Redshift and Hive both have unique architecture. Both have their own cons. My guess is that Snowflake is made up by using the concepts of the two architecture concepts such as Amazon Redshift and Haddop, addressed the issues or gaps found in Redshift and Hadoop. Incentivized Helpful?
Top Pros	Pro Easy to use Pro Structured data Pro Scale up
Top Cons	Minus Use cases Minus Auto fill Minus Web based

Best Alternatives
	Snowflake
Small Businesses	Google BigQuery Score 8.6 out of 10
Medium-sized Companies	Db2 Score 8.7 out of 10
Enterprises	Db2 Score 8.7 out of 10
All Alternatives	View all alternatives

User Ratings
	Snowflake
Likelihood to Recommend	9.3 (37 ratings)
Likelihood to Renew	10.0 (2 ratings)
Usability	8.7 (13 ratings)
Support Rating	9.8 (8 ratings)
Contract Terms and Pricing Model	8.0 (1 ratings)

User Testimonials
	Snowflake
Likelihood to Recommend	Snowflake Computing I am over our HR data, and we use Workday for our HR management system. I have a script in place that runs reports on Workday and saves the results as CSVs. I can then use stages in Snowflake to insert these CSVs into Snowflake, then I can insert or truncate and replace these staged tables into a final schema. Then once these are in a schema I can reference them and build out my data models. In addition to ingesting CSVs, Snowflake has the ability to write a CSV file to our Amazon S3 bucket. Ingesting these CSVs, transforming the data, then delivering it to a destination would've involved so much more coding than my current process if we were on any other platform. Incentivized Jeremy Pierce, MBA Data Warehouse Engineer Read full review
Pros	Snowflake Computing Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources Snowflake manages concurrency better in our trials than other premium competitors Snowflake has little to no setup and ramp up time Snowflake offers online training for various employee types Incentivized Harvey Wyche Director of Technical Product Management Read full review
Cons	Snowflake Computing This tool is very much technical and proper knowledge is required, so mostly you have to hire an IT team. I wish if various videos could be available for basic quires like its initiation, then I think it would act as a guideline and would help the beginners a lot. Incentivized Darren Mihalic Business Development Manager Read full review
Likelihood to Renew	Snowflake Computing SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to Incentivized Verified User Anonymous Read full review
Usability	Snowflake Computing The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database. Incentivized Jake Schlingman Product Manager Read full review
Support Rating	Snowflake Computing We have had terrific experiences with Snowflake support. They have drilled into queries and given us tremendous detail and helpful answers. In one case they even figured out how a particular product was interacting with Snowflake, via its queries, and gave us detail to go back to that product's vendor because the Snowflake support team identified a fault in its operation. We got it solved without lots of back-and-forth or finger-pointing because the Snowflake team gave such detailed information. Incentivized David Williams Head of Engineering Read full review
Alternatives Considered	Snowflake Computing I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system to store a large amount of data. All these functionalities give the better edge to Snowflake. Incentivized RV Rounak Verma Data Analyst Read full review
Return on Investment	Snowflake Computing Positive impact: we use Snowflake to track our subscription and payment charges, which we use for internal and investor reporting Positive impact: 3 times faster query speed compared to Treasure Data means that answers to stakeholders can be delivered quicker by analysts Positive impact: recommender systems now source their data from Snowflake rather than Spark clusters, improving development speed, and no longer require maintainence of Spark clusters. Incentivized Verified User Anonymous Read full review
ScreenShots	Snowflake Screenshots