# Snowflake Reviews **Vendor:** Snowflake, Inc. **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.6/5.0 **Total Reviews:** 754 ## About Snowflake Snowflake makes enterprise AI easy, efficient and trusted. Thousands of companies around the globe, including hundreds of the world’s largest, use Snowflake’s AI Data Cloud to share data, build applications, and power their business with AI. The era of enterprise AI is here. Learn more at snowflake.com (NYSE: SNOW). ## Snowflake Pros & Cons **What users like:** - Users praise the **ease of use** of Snowflake, appreciating its fast and flexible data management capabilities. (183 reviews) - Users appreciate the **reliable features and seamless integrations** of Snowflake, enhancing data analytics and business intelligence. (118 reviews) - Users value the **rich data management capabilities** of Snowflake, facilitating efficient querying and seamless integration across platforms. (108 reviews) - Users value the **scalability** of Snowflake, effortlessly adapting to varying workloads and ensuring high performance. (99 reviews) - Users value the **fast and flexible performance** of Snowflake, enabling quick data analysis without infrastructure concerns. (90 reviews) - Efficiency Improvement (89 reviews) - Users appreciate the **hassle-free data integration** with Snowflake, allowing focus on querying rather than infrastructure management. (88 reviews) - Speed (86 reviews) - Database Management (78 reviews) - Easy Integrations (78 reviews) **What users dislike:** - Users find Snowflake to be **expensive** , especially burdensome for smaller businesses with limited budgets or heavy workloads. (91 reviews) - Users experience **feature limitations** in Snowflake, particularly with query performance and restricted code execution options. (54 reviews) - Users find the **learning curve steep** for Snowflake, requiring training for inexperienced team members to navigate effectively. (45 reviews) - Users highlight the need for discipline in managing **costs** , as poor optimization can lead to unexpected charges. (44 reviews) - Users find the **cost management** challenging, with unpredictable pricing and initial setup costs exceeding expectations. (44 reviews) - Limited Features (42 reviews) - Query Issues (41 reviews) - Users find the **UI/UX challenging** and suggest better learning programs to improve the experience with Snowflake. (37 reviews) - Missing Features (34 reviews) - Users find the **poor UI design** of Snowflake complicates navigation and slows down workflows, impacting the overall experience. (34 reviews) ## Snowflake Reviews ### 1. Using actively Snowflake as base cloud warehouse solution. **Rating:** 4.5/5.0 stars **Reviewed by:** valentin c. | Business Intelligence Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** April 22, 2021 **What do you like best about Snowflake?** I really like it's performance and speed. Also the UI is very intuitive. Another strong point is that you don't have to spend time and money on its administration. The storage is not a problem anymore and with snowflake you can load data instantly once it landed in your bucket. **What do you dislike about Snowflake?** I don't like that it do not support multiple cluster keys on hte same table (can not support multiple indexes on the same table). **What problems is Snowflake solving and how is that benefiting you?** We're using Snowflake to fix the storage issues; to improve our performance when processing big amount of data; to load data almost instantly from our stage. ### 2. I have a large data set having very slow performance on lot of databases it solved on snowflake. **Rating:** 5.0/5.0 stars **Reviewed by:** Rahul G. | Senior Associate, Small-Business (50 or fewer emp.) **Reviewed Date:** October 13, 2021 **What do you like best about Snowflake?** 1. Speed of the query execution and updating the query 2. Data migration 3. Data security 4. Data uploading **What do you dislike about Snowflake?** Nothing as such I think this is perfect mindpiece. **Recommendations to others considering Snowflake:** If you are looking to change it is a must option you should try. **What problems is Snowflake solving and how is that benefiting you?** Speed of query execution and ease of data loading ### 3. Snowflake review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** October 28, 2021 **What do you like best about Snowflake?** The ability to scale warehouses according to business needs. The ease with which views and connectors can be built. Great community support. **What do you dislike about Snowflake?** Snowflake doesn't have a native offering with cloud providers like Google, aws or azure. Bulk loading is a bit difficult. The next generation of data is going to be unstructured and semi structured. Snowflake must look into this domain as it currently does not offer much in this niche **What problems is Snowflake solving and how is that benefiting you?** Getting husiness insights regarding our product offerings. ### 4. Futuristic modern data warehousing tool **Rating:** 5.0/5.0 stars **Reviewed by:** Sandeep S. | Senior Data Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** August 31, 2021 **What do you like best about Snowflake?** Snowflake is part of the modern BI stack, there are lot of inbuilt functionalities that makes complex data warehousing problems simple **What do you dislike about Snowflake?** The UI can be little more better compared with other warehousing tools such as Redshift , bigquery **Recommendations to others considering Snowflake:** Worth a try , go for it **What problems is Snowflake solving and how is that benefiting you?** Store data in a organised format for analytics user to easily consume and make best use of the data ### 5. It would be great if snowflake as external query engine have better performance **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Small-Business (50 or fewer emp.) **Reviewed Date:** October 20, 2021 **What do you like best about Snowflake?** Easy interface, hassle free data ingestion from cloud storage, better warehouse performance **What do you dislike about Snowflake?** Query on external data on cloud is slow. **What problems is Snowflake solving and how is that benefiting you?** Easy data ingestion near real time, heavy aggregation query on cross tables, and for reporting data. ### 6. Snowflake Business User Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** October 19, 2021 **What do you like best about Snowflake?** Speed of processing data and executing queries **What do you dislike about Snowflake?** Learning curve is high and can be difficult to learn the structure of how data is stored and accessed **What problems is Snowflake solving and how is that benefiting you?** Business insurance claim analysis of trends in frequency and severity ### 7. Would never go back to another warehouse. **Rating:** 5.0/5.0 stars **Reviewed by:** Scott V. | Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2020 **What do you like best about Snowflake?** Separation of storage and compute make it so simple to manage capacity and ensure fast response times for all warehouse workloads. We can have analysts on one warehouse, another warehouse servicing our API, and yet another one to serve up customer dashboards, all working on the same data without affecting the response times of each other. **What do you dislike about Snowflake?** Enterprise account required for clustering, which not only increases the number of credits you will use but also drives up the cost per credit. The community forums are not that active and are a hassle to post to because of needing to have a support account that is different than your regular account. No ability to share data with consumers that have an account in a different region. **Recommendations to others considering Snowflake:** Sign up with a credit card to try it out, you are only billed for the minutes that you use so it is easy to sample without committing to a big spend. Once you see the utility and power of how it works, you won't go back. **What problems is Snowflake solving and how is that benefiting you?** Flexible data warehouse to drive dashboards for our internal teams and customers. Secure data sharing is also a killer feature that is a million times easier than the old way of transferring csv files all around. ### 8. Long term Snowflake customer from financial services industry **Rating:** 5.0/5.0 stars **Reviewed by:** Mark P. | Technical Solution Architect (Data and Special Projects), Enterprise (> 1000 emp.) **Reviewed Date:** December 15, 2020 **What do you like best about Snowflake?** Tri-Secret Secure : customer held key ensures that service representatives can not "see" our data. Dynamic Compute Sizing : we can resize our compute resources (known as snowflake warehouses) to react to needs of the Business or to minimize cost. Replication : we can replicate entire databases from one region (or cloud) to another easily and very quickly which is important with financial services data. **What do you dislike about Snowflake?** Account Management : while we can see our consumption (compute and storage) online, we don't have access to see our current credit balance and forecasted usage. Compute Resource Rationalization : we don't have the insight into whether the sizing of our compute resources are appropriate (too large or too small). Sizing becomes more of an art than a science. **What problems is Snowflake solving and how is that benefiting you?** We've solved the issue of capacity management. Our previous solution required an upgrade to increase compute or storage sizing. Storage is only limited by the size of our budget and we now can resize compute ourselves. The net result is we have consumed much more data at the same price point as our previous solution which makes everyone (Business users, Finance team, and us) very happy. ### 9. I would like give it to 10 but it's only for fully cloud based enterprises. So I give it 8. **Rating:** 4.0/5.0 stars **Reviewed by:** Wai Yan H. | ICT Presales Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 27, 2021 **What do you like best about Snowflake?** I liked its unique architecture, and also about security. **What do you dislike about Snowflake?** I disliked not supporting hybrid. Because our customer only need hybrid. **What problems is Snowflake solving and how is that benefiting you?** In order to solve big data that RDBMS can't handle properly. ### 10. Not bad **Rating:** 2.5/5.0 stars **Reviewed by:** Fatehi R. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2021 **What do you like best about Snowflake?** I liked the accuracy of the processes and the ease of use **What do you dislike about Snowflake?** There are some features not powerful need to be enhanced **What problems is Snowflake solving and how is that benefiting you?** Reporting challenges and data warehousing technology ### 11. Simple and Powerful **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** October 12, 2021 **What do you like best about Snowflake?** The maintenance of the Data Warehouse is done by snowflake itself, yiu no longer need admins to apply patches and perform upgrades **What do you dislike about Snowflake?** No primary key and foreign key concept, that could be a real bummer. **Recommendations to others considering Snowflake:** Its highly recomemded **What problems is Snowflake solving and how is that benefiting you?** Its basically a managed data warehouse in the cloud, so its used as a data warehouse where dta is flown in from multiple systems, its fast always available and simple to use. ### 12. I have worked for a retail company and used a snowflake to get a required data using a SQL query. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** October 21, 2021 **What do you like best about Snowflake?** The way data are stored, and the output is displayed. **What do you dislike about Snowflake?** It is hard to recover and use the deleted data. **Recommendations to others considering Snowflake:** It is an excellent tool for managing data and used for creating a report. **What problems is Snowflake solving and how is that benefiting you?** The problem I solved using a snowflake is getting the required data from a warehouse and using it to create a report. ### 13. snowflake review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Real Estate | Enterprise (> 1000 emp.) **Reviewed Date:** August 24, 2021 **What do you like best about Snowflake?** well established api with other software and business tools fast query speed advanced analytical functions **What do you dislike about Snowflake?** worksheet syncing issue when you have two of the same sheets open organization of worksheet is not great python and r api has too much dependency **What problems is Snowflake solving and how is that benefiting you?** datawarefhouse etl analytical tables ### 14. Snowflake - A user-friendly DB. **Rating:** 4.0/5.0 stars **Reviewed by:** Priyank S. | Data Analyst III - Python Developer , Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** April 09, 2021 **What do you like best about Snowflake?** Snowflake documentation is straightforward. API is easily accessible with python. The GUI can handle a whole lot of data in multiple sessions.Snowflake can support unlimited concurrency with its unique multi-cluster, shared data architecture. This allows multiple compute clusters to operate simultaneously on the same data without degrading performance. Snowflake can even scale automatically to handle varying concurrency demands with its multi-cluster virtual warehouse feature, transparently adding compute resources during peak load periods and scaling down when loads subside. **What do you dislike about Snowflake?** There is nothing much to dislike about it. There some limitations with concurrent runs, but those are addressed. **What problems is Snowflake solving and how is that benefiting you?** Snowflake helped to solve big data processing issues and easy access with python. ### 15. Snowflake Engineer **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 14, 2021 **What do you like best about Snowflake?** Friendly GUI, Powerful cloud Cababilities **What do you dislike about Snowflake?** pricing sometimes is high for small cmopanies **What problems is Snowflake solving and how is that benefiting you?** Building a cloud data warehouse. Easy to access by all users types. ### 16. About to use snowflake **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Small-Business (50 or fewer emp.) **Reviewed Date:** October 27, 2021 **What do you like best about Snowflake?** The most exciting part for me is to use this new thing and get more experienced on it **What do you dislike about Snowflake?** For now after reading some articles, there is nothing that i dislike! But sure I'll share my thoughts with you after getting deeper. **What problems is Snowflake solving and how is that benefiting you?** Manage the huge amount of data ### 17. A Great and Dedicated Resource **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Chemicals | Enterprise (> 1000 emp.) **Reviewed Date:** March 26, 2021 **What do you like best about Snowflake?** This product is great and definitely is something that I would highly recommend to other companies. I feel that their support is great and it is something that has made our company able to manage our data more effectively at this time. I feel that in a pandemic situation we were able to share and analyze our data more efficiently with Snowflake and do this remotely at times which helped us not interrupt the flow of business at this time. **What do you dislike about Snowflake?** Nothing - This product was great and has worked well for us. We have not had any major problems and if we experience any issues support is ready to help us very quickly. **What problems is Snowflake solving and how is that benefiting you?** We had problems with our data management system and trying to manage large amounts of data with different tools in the past. We got Snowlfake and it has helped us manage our data in a more efficient manner and has helped us better with our workflow at this time. ### 18. Data warehouse solution in my tem. **Rating:** 4.5/5.0 stars **Reviewed by:** Raj R. | SDE 2, Enterprise (> 1000 emp.) **Reviewed Date:** January 07, 2021 **What do you like best about Snowflake?** It is a helpful tool, it's breathtaking for important tasks, despite having cloning and information sharing features, it functions optimally without a good deal of effort, despite an excellent query efficiency, it's quick despite having many combinations, along with a web user interface that is stable. **What do you dislike about Snowflake?** I've no reservations about Snowflake, but it is an outstanding product with many helpful features, many of which do well. I've an excellent result. **Recommendations to others considering Snowflake:** It's user-friendly, additionally, it provides an awesome price to all, Snowflake is deeply as well as efficient, I suggest it. It's cost effective. **What problems is Snowflake solving and how is that benefiting you?** It is a tool for keeping info in information browsers, which allows us to find out whether a client is identified; this is a network support usually quickly accessed as well as allows us to start searching links entre data sources and many units, I can build data warehouses for many uses, additionally, it allows us to create data stores with this particular system. ### 19. The backbone of data orgs **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Food & Beverages | Mid-Market (51-1000 emp.) **Reviewed Date:** December 17, 2020 **What do you like best about Snowflake?** Snowflake has allowed us to streamline the most important pieces of information from our production databases to organize and visualize them in a way that is accessible to our entire organization. As a manager working cross functionally Snowflake has helped me answer technical questions about our schema without assistance from a tech lead while helping me organize my marketing analytics and insights for both internal and external products. The SQL writer is so easy to use and the ability to connect to so many disparate data sources in one place is an incredible value add to our DaaS and reporting. **What do you dislike about Snowflake?** I've found that it's easier to update account settings using SQL than from the GUI. This has caused confusion for less technical stakeholders on my team (finance, etc.). In general these areas could use some TLC to be more accessible. It would also be helpful to have clearer financial breakdowns of usage. **What problems is Snowflake solving and how is that benefiting you?** Helping the org make data driven decisions, getting database views and access without setting someone up on postgres and without risk to our production db, creating models of synthesized data in our BI tool. Wouldn't be possible without Snowflake! ### 20. Managing data warehouse is so easy now with Snowflake **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** May 15, 2021 **What do you like best about Snowflake?** Snowflake made it so easy to connect with data providers in such a cost-effective way. Besides all other offerings, analytics data processing is the USP of a snowflake. With scalability, snowflake solves the problem of data storage **What do you dislike about Snowflake?** ODBC connectors need to improve. also, time to time, product updates need to be communicated in a channeled way to keep knowledge up to date **Recommendations to others considering Snowflake:** Snowflake can behave as single need data warehouse for all data needs **What problems is Snowflake solving and how is that benefiting you?** Working on a hybrid cloud model, my client wanted to solve the problem where multiple cloud vendors can talk to each other in a cloud provider agnostic way. Snowflake came as a boon in this scenario ### 21. SnowPro **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** October 13, 2021 **What do you like best about Snowflake?** The content and the flexibility and pricing for this products I like most. **What do you dislike about Snowflake?** I did not see any dislike about snowflake **What problems is Snowflake solving and how is that benefiting you?** Current project replaced hive and redshift and introducing Snowflake. ### 22. Good data store **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** October 05, 2021 **What do you like best about Snowflake?** Integrating snowflake as a data store in the ingestion step is very simple with multiple services **What do you dislike about Snowflake?** The cost is the only drawback I've noticed **What problems is Snowflake solving and how is that benefiting you?** Most of our data capture happens in Snowflake ### 23. Good training but more insights needed. It might be because of very short course duration **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Accounting | Small-Business (50 or fewer emp.) **Reviewed Date:** October 20, 2021 **What do you like best about Snowflake?** Architecture explanation was most helpful. **What do you dislike about Snowflake?** More insights and use cases missing. Customer cases demonstration will be really helpful. **What problems is Snowflake solving and how is that benefiting you?** Data migration ### 24. Snowflake **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Food Production | Enterprise (> 1000 emp.) **Reviewed Date:** September 23, 2021 **What do you like best about Snowflake?** clean interface, easy to navigate databases and find tables, tabbed systems **What do you dislike about Snowflake?** the process to switch roles/databases/schemas can be a bit cumbersome at times **What problems is Snowflake solving and how is that benefiting you?** creating data sources using SAP data to utilize in tableau ### 25. Enabling Data integrity at scale **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2020 **What do you like best about Snowflake?** We are able to store semi-structured (chat messages) data at scale and able to parse them out easily as well on query. At Drift. The data team also looks to store the raw data before we transform and the variant data type in Snowflake is key to ensuring we can parse the data without having to backfill or do major code changes. **What do you dislike about Snowflake?** The Clouds Services cost structure in Snowflake billing is a little less transparent and customers would like to know how we get charged or why charges vary for same workloads on different days. **What problems is Snowflake solving and how is that benefiting you?** We use Snowflake for a product feature where we serve out customers more intelligence on who visits their website and how many times they visit they visit. This help sales team identify and see who their target accounts are. ### 26. Query & Go **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** July 23, 2021 **What do you like best about Snowflake?** The ability to easily query data and go through schemas **What do you dislike about Snowflake?** I think Snowflake is amazingly fast and easy to use. **What problems is Snowflake solving and how is that benefiting you?** Querying Data ### 27. Best data platform on cloud **Rating:** 4.0/5.0 stars **Reviewed by:** Pranav D. | Digital Specialist Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 19, 2021 **What do you like best about Snowflake?** The SDKs are very easy to integrate and use. **What do you dislike about Snowflake?** The user interface is not that much user friendly. **What problems is Snowflake solving and how is that benefiting you?** We used this to provide analysis to many clients with lesser cost. ### 28. Best cloud data warehouse solution with great value for money ratio **Rating:** 5.0/5.0 stars **Reviewed by:** Dominik R. | Mid-Market (51-1000 emp.) **Reviewed Date:** December 16, 2020 **What do you like best about Snowflake?** Performance and scalability. Pay as you go price model doesn't require large upfront invests makes it a great fit even for smaller companies. Feature completeness and still constant innovation with further great features. **What do you dislike about Snowflake?** I thought long about it but couldn't find anything in this category. **Recommendations to others considering Snowflake:** Consider combining it with ETL tools like Fivetran and/or Matillion. **What problems is Snowflake solving and how is that benefiting you?** Create data warehouse to bring all data together in a single place for analysis. Now data from different systems can be easily combined for analysis. Manual processes are automated. ### 29. Snowflake Is and Excellent tool **Rating:** 5.0/5.0 stars **Reviewed by:** Aaron G. | Business Intelligence Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** June 04, 2019 **What do you like best about Snowflake?** The biggest benefit to using snowflake for us has been the ease of use when it comes to data management and tool interaction. When we migrated from Redshift we also saw a huge increase in performance due to the improvement in the way that concurrency impacted our looker instance. I highly recommend! The administration tooling/UI in snowflake is amazing. I don't need to have highly trained database admins handling everything. Its easy to understand and work with functionally makes it much more accessible to less technically skilled individuals. **What do you dislike about Snowflake?** The biggest issue we are facing now is implementing snowpipe. Some of the problems has been due to the lack of documentation on how errors are handled. **Recommendations to others considering Snowflake:** Leverage the admin tooling and UI, you can do some great things with it that other tools cannot match. If you are using Looker, leverage multiple connections(use multiple models) to separate out usage across different warehouses, get the most value from different sized warehouses to the types of BI work being done. **What problems is Snowflake solving and how is that benefiting you?** The biggest problem that we have successfully tackled has been increased number of users we can have using Looker, due to the concurrency increase. ### 30. A better data warehouse on Cloud **Rating:** 4.0/5.0 stars **Reviewed by:** Pavan Kumar Y. | Senior Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 15, 2021 **What do you like best about Snowflake?** Its features like separation of storage and compute, on the fly scalable compute, data sharing, data cloning, and supports may languages to connect with. **What do you dislike about Snowflake?** Only supports JavaScript for stored procedures **Recommendations to others considering Snowflake:** Modern computation of snowflakes makes it stand out. I recommend using Snowflake as a data warehouse. **What problems is Snowflake solving and how is that benefiting you?** Platform migration from on-premise to cloud. Its compute speed is the benefit. ### 31. Great Performance And Ease Of Use **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** October 09, 2020 **What do you like best about Snowflake?** Its ease of use. The solution feels natural for people that have worked with relational databases before because of its implementation of basic SQL. However, combining structured and semistructured data in a query is extremely simple, and the performance is impressive. You can pull millions of rows in an instant by just setting the correct warehouse size. **What do you dislike about Snowflake?** There is little to dislike about Snowflake. Its performance and ease of use are incredible. However, Snowflake can still be considered a newcomer to the market, so the breadth of solutions that integrate and communicate with Snowflake is somewhat reduced compared to other products (SQL Server, Oracle, Redshift, etc.) **What problems is Snowflake solving and how is that benefiting you?** We needed to improve the performance of our ETL processes. We had ETLs that ran for close to 15 - 20 hours to move data into the data warehouse. After multiple reviews, we identified that there was little we could do with our ETLs. But moving the DWH to Snowflake was the solution to all our problems. ### 32. I have worked extensively on Snowflake to create datalakes from scratch. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** June 08, 2021 **What do you like best about Snowflake?** Snowflake is highly scalable. The interface provided by snowflake is very comfortable to use. The query rofiles give very important insights. **What do you dislike about Snowflake?** There are still some internal errors which frequently come so the environment is not very stable as yet. PLSQL stored procedures are not yet provided. **What problems is Snowflake solving and how is that benefiting you?** We are replacing the existing enterprise database with snowflake to achieve scalability in analysis. ### 33. One of the best cloud database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Real Estate | Mid-Market (51-1000 emp.) **Reviewed Date:** June 03, 2021 **What do you like best about Snowflake?** Cloud storage, Performance, Pay as you use model, new updates, events, integration with other tools, SQL Compatible, Visualization tools, marketplace **What do you dislike about Snowflake?** Stored procedures, functions and other elements still use java syntax, No UI Downloadable Client, No dark mode in UI **What problems is Snowflake solving and how is that benefiting you?** Store lots of data and use ELT logic which saves on performance and integration hassle, warehouse scalability reduce cost ### 34. Scalable cloud based data platform **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** March 28, 2021 **What do you like best about Snowflake?** Powerful and feature rich data platform for industry with compliance needs. Continuous innovations with new features such as Snowsight and Snowpark. **What do you dislike about Snowflake?** Flexibility to select compute type for running data science models in Snowpark such as compute with GPU. **Recommendations to others considering Snowflake:** If you are in a regulated industry and looking for a cloud based data warehouse stack, Snowflake is the best. **What problems is Snowflake solving and how is that benefiting you?** Building analytics layer for BI and ad hoc analytics and support for Data Science use cases. ### 35. State of the art cloud data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** June 05, 2021 **What do you like best about Snowflake?** Ease of use, lack of maintenance, infinite scale **What do you dislike about Snowflake?** Cost management on snowflake isn't trivial. **What problems is Snowflake solving and how is that benefiting you?** Using it as a central datalake & warehouse ### 36. A faster, simpler way **Rating:** 5.0/5.0 stars **Reviewed by:** Tim C. | Principal Business Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** December 15, 2020 **What do you like best about Snowflake?** It just works. The advantage of this environment is that there is minimal administrative work required to support rapid developments and users of all types. Disk provisioning , performance concerns are a thing of the past. **What do you dislike about Snowflake?** This is largely a CLI environment. Many activities require writing code. **What problems is Snowflake solving and how is that benefiting you?** A single data source for many applications that scale to meet the demand of dashboard users and data scientists. ### 37. Using Snowflake since long time for data warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Enterprise (> 1000 emp.) **Reviewed Date:** May 13, 2021 **What do you like best about Snowflake?** Easy to use and easy to learn without even prior knowledge to warehouse **What do you dislike about Snowflake?** Need to understand how it is configured with other tools **What problems is Snowflake solving and how is that benefiting you?** Connecting DB ### 38. The best technology choice we have made from long time **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Apparel & Fashion | Mid-Market (51-1000 emp.) **Reviewed Date:** December 15, 2020 **What do you like best about Snowflake?** Simplicity of use, performance Almost compatible with every other tools : legacy or new Data tools **What do you dislike about Snowflake?** nothing, we haven't find, so fare, any limitation to the datacloud platform **Recommendations to others considering Snowflake:** From our point of view THE best cloud data platform **What problems is Snowflake solving and how is that benefiting you?** One unique source of truth in the company for IT department and data departement, serving all the business needs ### 39. Cloud Datawarehousing solution -Snowflake **Rating:** 4.5/5.0 stars **Reviewed by:** Vivek P. | Senior data engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 16, 2020 **What do you like best about Snowflake?** Snowflake is better than snow decoupling of data and compute time-traveling and data backup Auto scalability. Software as a service no need to maintain hardware or software Supports cloud provider like Azure, AWS, google cloud pay as use. Highly tolerant and scalable. support ODBC JDBC connection support standard SQL. Data Virtualization which makes data retrieval so fast across downstream systems. **What do you dislike about Snowflake?** Not Available for on-premise. still growing so not large scale community Data modeling features can be enhanced further. No Certification or dedicated training program **What problems is Snowflake solving and how is that benefiting you?** We have to host our Datawarehouse on the cloud. We find Snowflake as a good data warehousing solution. It is very easy to create Fact and Dimension Tables. we can clone the data which secure data and fast retrieval of data without impacting other downstream systems ### 40. Fantastic resource to collect information. **Rating:** 4.5/5.0 stars **Reviewed by:** Hemant A. | Senior Credit Manager, Enterprise (> 1000 emp.) **Reviewed Date:** April 24, 2020 **What do you like best about Snowflake?** With a genuinely effective database, instead of spending time on retrieval and documentation solutions, you will be able to generate real results with little to no effort in constructing and maintaining your database and little to no time in collecting data. Additionally, when a customer is found, you can now see if they have been ordered, whether they have been ordered, and what procedures are being changed. **What do you dislike about Snowflake?** Snowflake does not support general table expressions. We make the most of encryption, but we think there's space for development. Also, error messages are often confusing, particularly when a configuration table is added, and the new database ends up doing just that. **Recommendations to others considering Snowflake:** Snowflake is a fantastic resource since a lot of information is processed easily. This is very useful for businesses who want to optimize the balance in a big search engine. **What problems is Snowflake solving and how is that benefiting you?** You should consult our information proactively at Snowflake.com to collect information on all facets of your business and activities. I often use it to increase my awareness of search engines as it helps me to collect information that researchers do not automatically have access to. ### 41. Our solution for data management. **Rating:** 4.5/5.0 stars **Reviewed by:** Edric M. | Sales Business Development, Enterprise (> 1000 emp.) **Reviewed Date:** April 20, 2020 **What do you like best about Snowflake?** Snowflake is an amazing system that covers organized and semi-structured information to provide ready-to-use applications including JSON, ORC, XML and other semi-structured information. This allows you to focus on data management instead of functional testing in a database engine that has been developed. Its layout is common to the another SQL frameworks I've been using, and it's relatively simple to use because of the efficient way it looks at the connections between tables. **What do you dislike about Snowflake?** For fairly complex queries, the response time may be very long; SSIS is connected to its ODBC, but it takes a little longer to get information from Snow Brand. In addition, co-related sub-inquiries are not endorsed. **Recommendations to others considering Snowflake:** Snowflake is the way to go if you want a massively scalable cloud storage system. This will allow software engineers to focus more on technical work to help them grow. **What problems is Snowflake solving and how is that benefiting you?** A few years ago, my company used Snowflake instead of Redshift to query data at SQL level, and Snowflake is the most common standard SQL data browser used as a data storage tool. You can easily process and delete resources on your computer, easily expand and contract them with simulated storage while maintaining secure data transfer. ### 42. Storing data about key clients is easier. **Rating:** 4.5/5.0 stars **Reviewed by:** Sarah K. | Key Account Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** April 15, 2020 **What do you like best about Snowflake?** The Snowflake is easy to install and operate. The ability to immediately move clusters from top to bottom provides great adaptability in terms of achievement and profitability. In my opinion, the best feature of the snowflake should be "time-travel". Time journey is a thought of capturing data at a certain time and Snowflake also provides a "share" capacity that makes it easier to share data internally. The ability of Snowflake to clone has served us well in our experience. **What do you dislike about Snowflake?** There is not much to say, but a cloud storage study has shown that Snowflake is one of the various adjustable and scalable data storage solutions on the market. **Recommendations to others considering Snowflake:** Hire an expert to help you move, support ANSI SQL and use Oracle SQL language, though it is designed in many aspects that are very different from other databases. **What problems is Snowflake solving and how is that benefiting you?** Snowflake allows you to combine most data sources into one theoretical space, making it easy for clients to create reports. ### 43. Easy to Use **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in E-Learning | Small-Business (50 or fewer emp.) **Reviewed Date:** October 13, 2020 **What do you like best about Snowflake?** It is web-based and is intuitive. There are support forums to use also. **What do you dislike about Snowflake?** Nothing as it gives me everything I need to be successful with my position. **Recommendations to others considering Snowflake:** Have a plan for what you are wanting to do and enjoy the experience. **What problems is Snowflake solving and how is that benefiting you?** It is great to use with data and see what areas we are succeeding in. ### 44. Automate the configuration. **Rating:** 4.5/5.0 stars **Reviewed by:** Magda M. | HR Advisor, Mid-Market (51-1000 emp.) **Reviewed Date:** April 27, 2020 **What do you like best about Snowflake?** The strength of Snowflake is that its SQL is robust and easy to use in a changing environment. Snowflake supports various data sets, both structured and unstructured. That makes climbing much easier, but also more economical. **What do you dislike about Snowflake?** Speed and mobility could be increased. Snowflake is predicated on a non-PMPP database and may delay automation for temporary loads. **Recommendations to others considering Snowflake:** When comparing storage systems with computer systems, consideration should be given to the concept of completely separating them from competition. You should also understand that you need to set up a way to load information into its environment. **What problems is Snowflake solving and how is that benefiting you?** Snowflake makes it easy to automate the configuration, procurement, maintenance and expansion of your cloud storage. We are meeting our business intelligence reporting needs. The time it takes to obtain information is much shorter, and more detailed questions about the data can be asked. ### 45. Easy to Impliment **Rating:** 3.5/5.0 stars **Reviewed by:** Andries v. | Data Scientist/Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 19, 2020 **What do you like best about Snowflake?** Cloud solution is easy to impliment - We had it up and running in an hour or two. IDE remembers the tabs and queries you had open. Cheap solution to impliment. Costing platform is great. **What do you dislike about Snowflake?** Limited functionality in terms of functions, sub queries and some flexible dynamic tricks that SQL can do , that Snowflake can't. **Recommendations to others considering Snowflake:** Really easy to implement and their costing platform is great. There is a bit of learning and frustrations if you switch from MS SQL, as snowflake has its own little quirks and some more advanced sub quering and transformations that does not work. **What problems is Snowflake solving and how is that benefiting you?** Setup our datawarehouse over a weekend and was able to bring together different data sources. ### 46. Revolutionized the Data Warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Construction | Enterprise (> 1000 emp.) **Reviewed Date:** November 05, 2020 **What do you like best about Snowflake?** Separation of storage vs compute and very transparent billing **What do you dislike about Snowflake?** Performance with visualization tools is not the best **Recommendations to others considering Snowflake:** Go for it. start small because costs can otherwise add up quickly. Don't jump on to big migrations without testing the difficult parts. **What problems is Snowflake solving and how is that benefiting you?** Solving problems for good access to data and quick onboarding of users ### 47. Snowflake is Faster & Reliable **Rating:** 5.0/5.0 stars **Reviewed by:** Rakesh K. | Assistant Manager Finance, Food & Beverages, Enterprise (> 1000 emp.) **Reviewed Date:** October 01, 2019 **What do you like best about Snowflake?** It takes almost no time to provide the result, The results show us Faster than Instant Noodles. **What do you dislike about Snowflake?** Nothing as of now. The user experience is really good that I don't find any negative experience to share with, Hoping this will continue to work like this. Just wanted to continue with Snowflake until we find any error in it, The Snowflake team, for now, all seems good if there is any requirement when the team contacts them they provide a proper solution within a short period of time that. My SQL was so slow if we awere working them prodivicity was going down as uploading in that & Querying was a very bad experience since the team was looking for a better solution after a lot of analyzing the team figure out Snowflake will be the best option for an organization like Swiggy **Recommendations to others considering Snowflake:** If the COmpany is looking for cutting down waiting time through Query or uploading the data faster to provide a hassle-free end-user result then this is the best solution for the Company. Data synchronization is also faster than other tool. **What problems is Snowflake solving and how is that benefiting you?** Pulling the data through a query in MySql was giving a very bad end result we were waiting for more as that was taking more time to pull, however, this has helped us to save time, As in the corporate world Time this Cost to company. ### 48. Snowflake - Speed on the Cloud! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** November 20, 2019 **What do you like best about Snowflake?** Snowflake is a database and a storage warehouse on the cloud. Since it's scalable on demand, retrieving data through Snowflake Warehouses is lighting fast. All the computing power required to run the SQL queries are taken care by the Warehouse size we choose. If a query is taking too long to run a quick switch to a bigger warehouse does wonders. Migrating and loading data into Snowflake is a breeze too via Snowflake Stages and COPY TO commands. **What do you dislike about Snowflake?** Snowflake doesn't enforce constraints, especially primary keys. So, care should be taken while doing INSERTs and UPSERTs to maintain data integrity. This lack of this feature is understandable since it's projected more as a storage warehouse. **Recommendations to others considering Snowflake:** Companies with on-premise database systems moving to Snowflake cloud database is a no-brainer. Snowflake has command line tools which help in rapid data loading. Snowflake supports multiple data sources and various flat file types. **What problems is Snowflake solving and how is that benefiting you?** Maintaining on-premise database systems is expensive and maintenance heavy. Moving to a cloud database like Snowflake cuts down costs and is easy to maintain also. Since Snowflake supports a variety of flat file formats as sources, it becomes easier to bulk load data as flat files in storage spaces like AWS S3. Migrating data from cloud storage to Snowflake becomes much more easier. ### 49. Great Analytical data warehouse tool **Rating:** 5.0/5.0 stars **Reviewed by:** Svetlana N. | Senior Business Analyst, Consultant - IT Digital, Enterprise (> 1000 emp.) **Reviewed Date:** July 16, 2020 **What do you like best about Snowflake?** The Snowflake data warehouse uses a new SQL database engine with a unique architecture designed for the cloud **What do you dislike about Snowflake?** I like this tool, nothing that i can think about. So far so good **What problems is Snowflake solving and how is that benefiting you?** Snowflake is a top cloud data warehousing solution ### 50. Snowflake is amazing **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Consumer Goods | Enterprise (> 1000 emp.) **Reviewed Date:** September 15, 2020 **What do you like best about Snowflake?** Snowflake is the easiest cloud data mart I’ve used. **What do you dislike about Snowflake?** Snowflake does not allow you to extend the length of table names - you have to know what you’re looking for **What problems is Snowflake solving and how is that benefiting you?** Snowflake is allowing me to bring data to decision makers faster. ## Snowflake Discussions - [What's the best way to manage change data capture in Snowflake?](https://www.g2.com/discussions/what-s-the-best-way-to-manage-change-data-capture-in-snowflake) - 4 comments, 2 upvotes - [What is Snowflake used for?](https://www.g2.com/discussions/what-is-snowflake-used-for) - 2 comments, 1 upvote - [Why Python is best for career?](https://www.g2.com/discussions/why-python-is-best-for-career) - 1 comment, 1 upvote - [How do you optimize query performance in snowflake while analysing?](https://www.g2.com/discussions/how-do-you-optimize-query-performance-in-snowflake-while-analysing) - 1 comment, 1 upvote - [Snowflake - how to connect to Snowflake using NodeJS](https://www.g2.com/discussions/snowflake-how-to-connect-to-snowflake-using-nodejs) - 2 comments, 1 upvote - [View Snowflake pricing details and edition comparison](https://www.g2.com/products/snowflake/reviews?page=59§ion=pricing&secure%5Bexpires_at%5D=2026-06-01+00%3A04%3A51+-0500&secure%5Bsession_id%5D=ec4f7d63-fb6e-4564-91ad-5f122ba3a0ec&secure%5Btoken%5D=121cac26fc7507bc159dd61029730d919cc57b94d335ca9951292c24febaa4e9&format=llm_user) ## Snowflake Integrations - [Agentforce 360 Platform (formerly Salesforce Platform)](https://www.g2.com/products/agentforce-360-platform-formerly-salesforce-platform/reviews) - [Agentforce Sales (formerly Salesforce Sales Cloud)](https://www.g2.com/products/agentforce-sales-formerly-salesforce-sales-cloud/reviews) - [Airbyte](https://www.g2.com/products/airbyte/reviews) - [Airtable](https://www.g2.com/products/airtable/reviews) - [Amazon EC2](https://www.g2.com/products/amazon-ec2/reviews) - [Amazon Elastic Container Service (Amazon ECS)](https://www.g2.com/products/amazon-elastic-container-service-amazon-ecs/reviews) - [Amazon S3 Glacier](https://www.g2.com/products/amazon-s3-glacier/reviews) - [Anaplan](https://www.g2.com/products/anaplan/reviews) - [Apache Airflow](https://www.g2.com/products/apache-airflow/reviews) - [Apache Kafka](https://www.g2.com/products/apache-kafka/reviews) - [Appian](https://www.g2.com/products/appian/reviews) - [Applicant Tracking System](https://www.g2.com/products/info-tech-systems-integrators-applicant-tracking-system/reviews) - [Athena](https://www.g2.com/products/bennett-technologies-pvt-ltd-athena/reviews) - [Atlassian Atlas](https://www.g2.com/products/atlassian-atlas/reviews) - [Attentive](https://www.g2.com/products/attentive/reviews) - [AWS Glue](https://www.g2.com/products/aws-glue/reviews) - [AWS Lambda](https://www.g2.com/products/aws-lambda/reviews) - [Azure Databricks](https://www.g2.com/products/azure-databricks/reviews) - [Azure Pipelines](https://www.g2.com/products/azure-pipelines/reviews) - [Braze](https://www.g2.com/products/braze/reviews) - [Codex](https://www.g2.com/products/openai-codex/reviews) - [Collate](https://www.g2.com/products/collate-collate/reviews) - [Dataiku](https://www.g2.com/products/dataiku/reviews) - [Data Studio](https://www.g2.com/products/data-studio/reviews) - [dbt](https://www.g2.com/products/dbt/reviews) - [dbt + Looker](https://www.g2.com/products/dbt-looker/reviews) - [ETL tools](https://www.g2.com/products/etl-tools/reviews) - [Fivetran](https://www.g2.com/products/fivetran/reviews) - [Heap](https://www.g2.com/products/heap/reviews) - [ICEBERG](https://www.g2.com/products/iceberg/reviews) - [Informatica Cloud Data Integration](https://www.g2.com/products/informatica-cloud-data-integration/reviews) - [Informatica PowerCenter](https://www.g2.com/products/informatica-powercenter/reviews) - [Jotform](https://www.g2.com/products/jotform/reviews) - [JumpCloud](https://www.g2.com/products/jumpcloud/reviews) - [Looker](https://www.g2.com/products/looker/reviews) - [Metabase](https://www.g2.com/products/metabase/reviews) - [Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) - [Monte Carlo](https://www.g2.com/products/monte-carlo/reviews) - [n8n](https://www.g2.com/products/n8n/reviews) - [NextGen Healthcare EHR](https://www.g2.com/products/nextgen-healthcare-ehr/reviews) - [Node.js](https://www.g2.com/products/node-js/reviews) - [Okta](https://www.g2.com/products/okta/reviews) - [Omni Analytics](https://www.g2.com/products/omni-analytics-inc-omni-analytics/reviews) - [OutSystems](https://www.g2.com/products/outsystems/reviews) - [Pipedream](https://www.g2.com/products/pipedream/reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - [PowerBI Tiles Pro](https://www.g2.com/products/powerbi-tiles-pro/reviews) - [Python](https://www.g2.com/products/python/reviews) - [Qualtrics Strategy & Research](https://www.g2.com/products/qualtrics-strategy-research/reviews) - [ServiceNow IT Service Management](https://www.g2.com/products/servicenow-it-service-management/reviews) - [Shopify](https://www.g2.com/products/shopify/reviews) - [Sigma](https://www.g2.com/products/sigma-computing-sigma/reviews) - [Tableau](https://www.g2.com/products/tableau/reviews) - [Twilio Segment](https://www.g2.com/products/twilio-segment/reviews) - [Via.Delivery](https://www.g2.com/products/via-delivery/reviews) - [Zapier](https://www.g2.com/products/zapier/reviews) ## Snowflake Features **Administration** - Data Modelling - Recommendations - Workflow Management - Dashboards and Visualizations **Deployment** - Language Flexibility - Framework Flexibility - Versioning - Ease of Deployment - Scalability **System** - Data Ingestion & Wrangling **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Storage** - Data Model - Data Types **Management** - Business Glossary - Data Discovery - Data Profililng - Reporting and Visualization - Data Lineage **Deployment** - Language Flexibility - Framework Flexibility - Versioning - Ease of Deployment - Scalability **Centralized computation** - Centralized Computation **Model Development** - Language Support - Drag and Drop - Pre-Built Algorithms - Model Training **Database** - Real-Time Data Collection - Data Distribution - Data Lake **Data Transformation** - Real-Time Analytics - Data Querying **Compliance** - Sensitive Data Compliance - Training and Guidelines - Policy Enforcement - Compliance Monitoring **Management** - Cataloging - Monitoring - Governing - Model Registry **Model Development** - Feature Engineering **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Availability** - Auto Sharding - Auto Recovery - Data Replication **Security** - Access Control - Roles Management - Compliance Management **Operations** - Metrics - Infrastructure management - Collaboration **Localized computation** - Localized computation **Machine/Deep Learning Services** - Computer Vision - Natural Language Processing - Natural Language Generation - Artificial Neural Networks **Integrations** - Hadoop Integration - Spark Integration **Data Quality** - Data Preparation - Data Distribution - Data Unification **Machine/Deep Learning Services** - Natural Language Understanding - Deep Learning **Deployment** - On-Premise - Cloud **Security** - Data Encryption - User Access Control **Performance** - Integrated Cache **Maintainence** - Data Quality Management - Policy Management **Management** - Cataloging - Monitoring - Governing **Deployment** - Managed Service - Application - Scalability **Platform** - Machine Scaling - Data Preparation - Spark Integration **Connectivity** - Hadoop Integration - Spark Integration - Multi-Source Analysis - Data Lake **Performance ** - Scalability **Security** - Role-Based Authorization - Authentication - Audit Logs - Encryption **Generative AI** - AI Text Generation - AI Text Summarization **Generative AI** - AI Text Generation - AI Text Summarization **Processing** - Cloud Processing - Workload Processing **Operations** - Data Visualization - Data Workflow - Governed Discovery - Embedded Analytics - Notebooks **Security** - Data Governance - Data Security **Support** - Multi-Model - Operating Systems **Generative AI** - AI Text Generation - AI Text Summarization - AI Text-to-Image **Agentic AI - Data Governance** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration - Adaptive Learning - Natural Language Interaction - Decision Making **Generative AI** - AI Text Generation - AI Text Summarization **Agentic AI - Data Science and Machine Learning Platforms** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration - Adaptive Learning - Natural Language Interaction - Proactive Assistance - Decision Making **Building Reports** - Data Transformation - Data Modeling - WYSIWYG Report Design - Integration APIs **Platform** - Mobile User Support - Customization - User, Role, and Access Management - Internationalization - Sandbox / Test Environments - Performance and Reliability - Breadth of Partner Applications ## Top Snowflake Alternatives - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (761 reviews) - [Cloudera Data Platform](https://www.g2.com/products/cloudera-cloudera-data-platform/reviews) - 4.1/5.0 (131 reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,147 reviews)