--- title: Snowflake Reviews meta_title: 'Snowflake Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 756 reviews by the users' company size, role or industry to find out how Snowflake works for a business like yours. aggregate_rating: rating_value: 4.5 review_count: 756 scale: '5' date_modified: '2026-07-18' parent_category: name: IT Infrastructure url: https://www.g2.com/categories/it-infrastructure --- # Snowflake Reviews **Vendor:** Snowflake, Inc. **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.5/5.0 **Total Reviews:** 756 ## 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 appreciate the **ease of use** of Snowflake, finding it fast and effective for data sharing and analytics. (183 reviews) - Users value the **reliable features** of Snowflake, enjoying its intuitive interface and seamless data integration for analytics. (118 reviews) - Users find Snowflake's **data management capabilities** excellent for efficiently aggregating and querying across multiple datasets. (108 reviews) - Users admire the **seamless scalability** of Snowflake, effortlessly accommodating work demands and ensuring optimal performance. (99 reviews) - Users appreciate the **fast data analysis** of Snowflake, enabling quick insights without infrastructure worries. (90 reviews) - Efficiency Improvement (89 reviews) - Users appreciate the **excellent integrations** of Snowflake, enhancing data management and deployment across multiple cloud platforms. (88 reviews) - Speed (86 reviews) - Database Management (78 reviews) - Easy Integrations (78 reviews) **What users dislike:** - Users find Snowflake's **high costs** burdensome, especially for small businesses with limited budgets. (91 reviews) - Users find **feature limitations** in Snowflake, such as lack of code blocks and challenge in permissions management. (54 reviews) - Users find that **cost management** requires discipline, as unexpected charges can accumulate quickly without careful monitoring. (44 reviews) - Users find the **cost structure difficult to optimize** , leading to unexpectedly high initial expenses during implementation. (44 reviews) - Users find Snowflake's **limited features** in dynamic scripts and monitoring hinder flexibility and usability. (42 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 overwhelming, especially for inexperienced team members requiring additional training. (34 reviews) - Performance Issues (32 reviews) - UX Design (29 reviews) ## Snowflake Reviews ### 1. Reliable, handles big data fast, like the new **Rating:** 4.0/5.0 stars **Reviewed by:** Dani S. | Product Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** October 20, 2021 **What do you like best about Snowflake?** Lots of functions, flexible SQL, easy to use interface, I like the new visualization tools. I don't talk to customer service, but teams seem to think They're very responsive. They're becoming our default database in the company. Admin has good access to query history. **What do you dislike about Snowflake?** The Documentation for functions is sometimes worded confusingly and does not provide a lot of examples. Incredibly tough to upload CSV files into tables, have to use SE files through AWS, very few straightforward ways to go about it locally within a snowflake. Sometimes active queries suddenly disappear. Need dev/admin permissions to check historical info such as previously run queries. **Recommendations to others considering Snowflake:** Store your queries elsewhere if you plan on reusing. Visualizations still leave some things to be desired. Make sure you know who admin permissions to access history in case something gets lost in the mix since it'll be hard to recover otherwise has. **What problems is Snowflake solving and how is that benefiting you?** Data analytics and applied data science, product analytics, business analytics, deep dives into big data, bug finding. ### 2. User Experience **Rating:** 5.0/5.0 stars **Reviewed by:** Jeyanth K. | Associate Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** September 29, 2022 **What do you like best about Snowflake?** User-interface and easy to work with an environment **What do you dislike about Snowflake?** if we have standalone software it could be usefull **What problems is Snowflake solving and how is that benefiting you?** data migration and process of data ### 3. Cloud Database **Rating:** 4.5/5.0 stars **Reviewed by:** Jetender V. | Program Manager, Enterprise (> 1000 emp.) **Reviewed Date:** June 30, 2022 **What do you like best about Snowflake?** 1. Easy setup 2. Self-training Videos 3. Can process structured and nonstructured data easily 4. Analytic Database for large datasets 5. Integration with cloud-based reporting **What do you dislike about Snowflake?** UI interface needs can be improved a lot. It should embed more features from Oracle database. **What problems is Snowflake solving and how is that benefiting you?** It is solving the need for rich analytics, speed. Its ability to handle non-structured data is a great help for our day to day activity. ### 4. Probably the best warehouse in the market. It is definitely a bit expensive though. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** August 31, 2022 **What do you like best about Snowflake?** Governance is really straight forward and queries run very fast. **What do you dislike about Snowflake?** Expensive. No transparency on specs of warehouses. **What problems is Snowflake solving and how is that benefiting you?** We are able (for the most part) to execute our queries very quickly and organize them well. ### 5. Snowflake - a modern cloud based Datawarehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 13, 2022 **What do you like best about Snowflake?** Snowflake can be based on any of the three major cloud service providers namely GCP, Azure and AWS. So it is easy for organizations to stick to their preferred CSP and avail Snowflake services. **What do you dislike about Snowflake?** Probably a graphical user interface for developers who want to do data modeling in the Snowflake environment. **What problems is Snowflake solving and how is that benefiting you?** Snowflake is giving a very robust cloud-based data warehousing solution with all the benefits of going to the cloud. Data sharing is one critical area in data management and SNowflake's innovative way of sharing data without physically moving it as a great feature. ### 6. Datalake using snowflake **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Utilities | Enterprise (> 1000 emp.) **Reviewed Date:** October 31, 2022 **What do you like best about Snowflake?** Ease of use for people with basic sql knowledge, OLTP and OLAP under same roof, auto scaling **What do you dislike about Snowflake?** Cost, limitations of stored procedure unless JavaScript is chosen as a language **What problems is Snowflake solving and how is that benefiting you?** Scalable data lake, minimal management for infrastructure, managed disaster recovery ### 7. Snowflake connection to Workiva **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** November 10, 2022 **What do you like best about Snowflake?** Ease of setup and linking to underlying table **What do you dislike about Snowflake?** Chains can be a bit hard to understand but was an easy setup for our Eng team **What problems is Snowflake solving and how is that benefiting you?** Automatically pulls in monthly metrics for our reporting ### 8. Good for database management **Rating:** 5.0/5.0 stars **Reviewed by:** Sanjit P. | Software Engineer 1, Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2021 **What do you like best about Snowflake?** We are using Snowflake for pushing data metrics and storing them in collaboration with AWS infra DB. The table organization and querying on database tables are smooth. It also captures the history of all your query and also provides an SQL auto-completion feature. It has a beautiful syntax color highlighting, which makes things readable. A new interface is now available, which offers full account search, chart visualization, SQL autocomplete, dashboards, and much more features. **What do you dislike about Snowflake?** Nothing I can think of right now. Snowflake works great for my team and me. **What problems is Snowflake solving and how is that benefiting you?** We have been using Snowflake for pushing data metrics and storing them in either AWS infra DB, Snowflake Sample data. It also allows importing worksheets from the classic version to Snowsight, making the relocation easier. We also use Snowflake's secure share to consume data shared in our organization and provide it to others. ### 9. Snowflake: Iconic and Full-featured Data Virtualization Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Tony H. | Data Visualization & Reporting Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Snowflake?** It is seamless to integrate data from multi-cloud and on-premise repositories. Automatically prepare, model and visualize data. **What do you dislike about Snowflake?** I am fully satisfied with Snowflake in terms of features coverage and customization. **What problems is Snowflake solving and how is that benefiting you?** I relish a lot with Snowflake from saving time, finances to unlocking actionable insights on data. ### 10. Game Changer **Rating:** 5.0/5.0 stars **Reviewed by:** Michael S. | Director, Business Intelligence and Web Services, Higher Education, Mid-Market (51-1000 emp.) **Reviewed Date:** December 17, 2020 **What do you like best about Snowflake?** Snowflake gives you the opportunity to start small and grow quickly, while not overspending up front. It has completely transformed our ability to deliver analysis of large data sets. The product is continuously improving. We are able to use many different tools to interface with Snowflake and have yet to run into a challenge we could not address. **What do you dislike about Snowflake?** New features are released only in the West Coast region, and it takes a long time before everyone else can use them. **What problems is Snowflake solving and how is that benefiting you?** We are combining data from more than 20 different data sources into a Snowflake-based data lake. The flexibility in formats of the source data has helped us achieve maximum compatibility. ### 11. Cloud based data warehousing tool with Analytics services **Rating:** 4.5/5.0 stars **Reviewed by:** Shiv Dutt S. | IN Enterprisewide Prg Analyst lvl3, Enterprise (> 1000 emp.) **Reviewed Date:** November 27, 2021 **What do you like best about Snowflake?** Performance of the tool, you can perform complex logic calculations on huge volume of data very quickly. At any point of time, you can add/remove servers to increase the performance. Easy to learn and deployment of code. **What do you dislike about Snowflake?** We have not encountered any drawbacks so far with this tool. The only challenge that we see is direct connectivity with the sources. For example, to pull data from SAP, you need to use a replication tool. **What problems is Snowflake solving and how is that benefiting you?** We are building a centralized database in our organization for reporting purposes. As of now, we have multiple systems which are not synched with each other. We are bringing data from all of them in snowflake then transforming data as per business need for reporting. ### 12. Best cloud database service provider **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Snowflake?** Easy to understand through user guide. Nice gui. Fast results. Additional feature snowsight is an amazing add on. **What do you dislike about Snowflake?** Every feature i have used so far is great **What problems is Snowflake solving and how is that benefiting you?** Database querying -results are fast The result table can b directly copied without downloading. ### 13. Snowflake best datawarehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 09, 2022 **What do you like best about Snowflake?** Snowflake is very modern cloud data warehouse which reduces the complexity of designing Analytical data solution. **What do you dislike about Snowflake?** Snowflake doesn't allow to share a database from one snowflake account to other account which has different cloud vendor and located at different region. **What problems is Snowflake solving and how is that benefiting you?** We were able to design the data warehouse as per our business requirement and that too in very much feasible way and with many other features. ### 14. Great way to organize complex databases and return information for large enterprises **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospitality | Enterprise (> 1000 emp.) **Reviewed Date:** April 27, 2022 **What do you like best about Snowflake?** No frills here. Input SQL and get outputs. Easy control of who from the org gets access to what certain databases. **What do you dislike about Snowflake?** Using Snowflake requires some degree of technical expertise that not all members of a business may possess. Best for folks in at data organization. **What problems is Snowflake solving and how is that benefiting you?** We can control what readouts are seen by certain parts of the business. Prevent complicating matters for teams who do not need access and grant permissions to those who do need to see. ### 15. Snowflake Review **Rating:** 4.5/5.0 stars **Reviewed by:** Sharath G. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about Snowflake?** * Storage capacity can run on almost all cloud software *Scalable everything is in cloud so can add up resources easily * Performance tuning option * Security features * Very good analytical and machine learning option **What do you dislike about Snowflake?** Snowflake is not supporting unstructured data right now Bulk load is bit problem No usage limit company may see some surprise in pricing if they use more resources **What problems is Snowflake solving and how is that benefiting you?** We have data warehouse which migrated from hadoop to snowflake.very scalable appliance with awesome performance. Very easy to use and not much of admistration work ### 16. Snowflake or Nothing **Rating:** 5.0/5.0 stars **Reviewed by:** Todd G. | Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** January 25, 2022 **What do you like best about Snowflake?** It could churn through data so fast, which is nice in a data warehouse tool. I wasn't the only one either in our company there were probably 20 analysts or more doing simlar things to what I was doing and it rarely missed a beat. **What do you dislike about Snowflake?** The thing that I didn't like about it was the fact that the only interface that we had to interact with it with was online. There were other ways but they were build directly from snowflake. **What problems is Snowflake solving and how is that benefiting you?** Being able to pull a ton of data, and check results so that we can publish the data to our BI Tool. This is used for reporting purposes to see how the company was doing. ### 17. Best tool for cloud based data warehousing implementation **Rating:** 5.0/5.0 stars **Reviewed by:** Partik A. | Technical Project Manager, Enterprise (> 1000 emp.) **Reviewed Date:** July 27, 2022 **What do you like best about Snowflake?** Data sharing, zero-copy cloning, time travel **What do you dislike about Snowflake?** There is nothing to be disliked about it **What problems is Snowflake solving and how is that benefiting you?** Data Ingestion/Processing with separate storage and processing capabilities through virtual warehouses ### 18. How snowflake become leader of the cloud storage in current situation. **Rating:** 4.5/5.0 stars **Reviewed by:** Arpan s. | System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 04, 2022 **What do you like best about Snowflake?** The best thing i like about the snowflake is its supports both share disk and share nothing architecture.it is a centralised based storing cloud database and its support all the new cloud services like AWS,Azure,GCP. **What do you dislike about Snowflake?** Its not cost effective as it is charge the money for the duration that a warehouse is on and how much time you use the warehouse for analysis or any purpose. So its not good for taking snowflakes clouds storage for a small projects. **What problems is Snowflake solving and how is that benefiting you?** Best benefits of snowflakes I would say the caching part.in snowflakes it provides two levle of caching one is the Result caching and another is the meta data caching. Due to this caching its avoid the unwanted use of any warehouse. ### 19. Review **Rating:** 4.0/5.0 stars **Reviewed by:** Okan . | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** June 14, 2022 **What do you like best about Snowflake?** Cloud based database system which has a great interface to develop easily and fast **What do you dislike about Snowflake?** Cost of implementation and very low level or administration abilities **What problems is Snowflake solving and how is that benefiting you?** Having one single source of db technology where we can manage the huge portion of data ### 20. Makes it really easy to have all your data in one, easily-queryable place **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** September 02, 2022 **What do you like best about Snowflake?** Really strong performance and speed, also easy sharing **What do you dislike about Snowflake?** The only thing I don't like is that you cannot collaborate with teammates on a query **What problems is Snowflake solving and how is that benefiting you?** It makes it easy to query data and quickly get metrics that we need ### 21. Snowflake as tool to fuel Marketing, Sales and Success Metrics **Rating:** 5.0/5.0 stars **Reviewed by:** Bhagyalakshmi L. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 16, 2021 **What do you like best about Snowflake?** Lot of success in storing large amounts of structured data and managing compute for fast queries across the data lake. As of today, we currently have ~50TB of data in Snowflake and hundreds of tables. Snowflake handles storage and compute efficiently. Snowflake can work well with large amounts of data with auto micro partitions of your data and you can also add clustering to improve usage. **What do you dislike about Snowflake?** Large amounts of data might not work well if it’s not partitioned and regularly pruned out. We are considering other options for real-time use cases. **What problems is Snowflake solving and how is that benefiting you?** A good go to tool for large amount of structured data. Like I said before you can clustering to improve usage. Very easy to use. A little SQL knowledge goes a long way. ### 22. I Have Used Snowflake in Data Quality Assurance, Data Migration and ETL Testing **Rating:** 4.0/5.0 stars **Reviewed by:** Priyanshu S. | Associate Quality Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** October 22, 2021 **What do you like best about Snowflake?** Using and Working with Snowflake is Like Cake Walk if You have Some Knowledge on Databases and SQL/Oracle. Snowflake Provides an Intensive Set of Connector APIs Such as Spark connector, Python connector, etc., and Javascript Language-Based Stored Procedure Support. Snowflake is a Virtual Data Warehouse So You Don't Need to Worry about Managing things Physically or Hectically. Performance of Query Execution is Incredible even for larger Datasets. **What do you dislike about Snowflake?** The Only Thing I Dislike about Snowflake Data Warehouse is Inability of Inferring Schema of Data Files Reading from Stage Area Such as Reading CSV, Json, Parquet, ORC etc from S3. **Recommendations to others considering Snowflake:** If You are in Business or Work of Data Analysis, Data Science, and Data Warehousing, Quickly go for it Don't Even Think Twice. **What problems is Snowflake solving and how is that benefiting you?** When I Worked On Data Quality Framework, the Client was required to Execute Custom SQL Queries for Creating Aggregated Datasets or Dataframes either for S3 Data Files or Snowflake Tables using Snowflake Compute and Triggering all the System through AWS Step Function and AWS Lambda, By this way we Saved the Cost of AWS EMR and Also Reduced the Time Taken to Access or Operate Large Datasets(Size>4GB). ### 23. Snowflake Data Warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** January 06, 2022 **What do you like best about Snowflake?** The separation of compute and storage and the flexibility in being able to control costs. Snowflake role hierarchy is also a very nice feature that allows for a flexible yet robust privilege hierarchy. **What do you dislike about Snowflake?** It would be nice if Snowflake offered a cost breakdown per user. Having the resource monitors is nice, but having the ability to see who is utilizing compute would make cost management a lot nice. **What problems is Snowflake solving and how is that benefiting you?** We are solving the problem of concurrency. Our current solution is not a highly concurrent system, and a couple of big queries can impact the rest of the users in the system. Snowflake does an excellent job of isolating the problematic compute areas. ### 24. Great DB tech with evolving tooling for enterprise use **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 01, 2022 **What do you like best about Snowflake?** The flexibility in performance is pretty remarkable. Good third-party support. Good SQL improvements. **What do you dislike about Snowflake?** Can't use native SQL to build a stored procedure, swapping to Javascript is odd coming from a SQL Server background. Costs can be difficult to control at times **What problems is Snowflake solving and how is that benefiting you?** It gives us a secure space that can be made easily accessible to many tools supported by great query performance. ### 25. Better than Sift app **Rating:** 5.0/5.0 stars **Reviewed by:** Mikayla S. | Customer Service Representative, Enterprise (> 1000 emp.) **Reviewed Date:** December 15, 2021 **What do you like best about Snowflake?** I like how detailed oriented and easier it is to be able to look more into customer's information when it comes to verifying information traces of customers using DoorDash. **What do you dislike about Snowflake?** I didn't have access for a while until now. There isn't anything to dislike about snowflake yet, since it's a new program that I'm using. **What problems is Snowflake solving and how is that benefiting you?** I'm able to trace a deeper information on customers for multiple accounts, how much refund/credits they received in the entire time using DoorDash, and if they have multiple accounts. ### 26. Super fast and easy **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** December 02, 2021 **What do you like best about Snowflake?** i like snowflake sql syntaxes (10x better than MYSQL) and the query speed. Storage is also super cheap since they charge by compute usage like a utility bill. Its not laggy and i can share my sql sheets easily with others **What do you dislike about Snowflake?** I do not like the UI experience for users, I end up using pycharm or dbeaver and connect to snowflake to write my sql queries. yes, the new snowsights is better than the classic console, but it also took away some of the things I enjoy about classic console. I like the ability to access the accounts (admin related stuff) / datawarehouses pages on the same sql page **What problems is Snowflake solving and how is that benefiting you?** query speed. customers are happy with the results returned compared to some competitor tools... ### 27. Snowflake Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Wholesale | Small-Business (50 or fewer emp.) **Reviewed Date:** December 28, 2021 **What do you like best about Snowflake?** Snowflake has a very clean UI, and it is simple to use. After about a week of playing around, I understood how most of the functionality worked in the tool which saved me so much time. **What do you dislike about Snowflake?** The biggest issue I ran into so far is that Snowflake doesn't have the capabilty to automatically refresh data in a maternalized view, so the table I created can't be refreshed unless it is a manual process or set up outside of Snowflake. **What problems is Snowflake solving and how is that benefiting you?** We now have a warehouse that centralizes all of our data, which we never had before. This is great for security reasons, as we all as organization. ### 28. Data Analyst **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 18, 2022 **What do you like best about Snowflake?** I enjoy how easy it is to search up different tabs that I'm working on. Another feature I find helpful is Snowflake highlighting the specific syntax or part of the query causing the query to run unsuccessfully. **What do you dislike about Snowflake?** Snowflake's documentation on its syntax and the examples provided can be confusing and hard to follow. I want Snowflake to provide more detailed and broken-down SQL queries with the matching results for more complicated functions. **What problems is Snowflake solving and how is that benefiting you?** Using Snowflake, I've run a distribution analysis and set target goals for an incentive program rolling out for the company's Customer Service representatives. ### 29. good enough terraform support in snowflake **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** August 04, 2022 **What do you like best about Snowflake?** Was able to configure and manage via terraform provider **What do you dislike about Snowflake?** Not all config is available via terraform **What problems is Snowflake solving and how is that benefiting you?** Simplified data analysis and allowed us to move expensive queries off of our production systems. ### 30. Snowflake - Cloud data warehouse of the Century **Rating:** 4.5/5.0 stars **Reviewed by:** Ronak A. | Technology Lead, Enterprise (> 1000 emp.) **Reviewed Date:** October 13, 2021 **What do you like best about Snowflake?** Snowflake is very easy to use and scale-out. I have seen my employer get miraculous insights into its Digital Supply Chain data. Its seamless and secured integration with ready-to-use adapters with ERP like SAP makes it yet more demanding. The dashboard and customizations are very handy and data warehousing becomes a cakewalk with proper implementation on Snowflake. **What do you dislike about Snowflake?** Costing can be a concern for large organizations as other providers like Azure, AWS, or GCP can provide cost-effective platforms with their offerings. **What problems is Snowflake solving and how is that benefiting you?** One of my previous company which majorly dealt with the sale of consumer electronics, faced an acute challenge of dead stock and monitoring its delivery and returns KPI. With the help of data warehousing solutions on Snowflake, we achieved a significant leap through in these areas. There was a month-on-month improvement seen in the supply chain KPIs. ### 31. No data silos with snowflakes **Rating:** 4.5/5.0 stars **Reviewed by:** Sanjana P. | Software Development Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 14, 2021 **What do you like best about Snowflake?** With snowflakes there's always encryption-on with data in rest and days in transit. It is one of the best platforms to ensure data security while aiding unification of data from data warehouses and data lakes. **What do you dislike about Snowflake?** Higher costs when compared to its competitors. Also, the performance optimization alerts and notifications are way lesser compared to other cloud data warehouses. **Recommendations to others considering Snowflake:** Go with it because it is far better than the other in-built warehousing services the cloud providers offer. **What problems is Snowflake solving and how is that benefiting you?** Our data team uses snowflake platform for offloading ETL. We are using it to store unstructed data. Snowflake offers high speed querying which is the best advantage of the platform. ### 32. Be able to scale your database with ease **Rating:** 5.0/5.0 stars **Reviewed by:** Derek P. | Business Intelligence Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** October 29, 2021 **What do you like best about Snowflake?** My favorite feature of Snowflake is the ability to scale production with ease. In addition, the query editor (worksheets) is a fantastic tool that enables users to interact with the database. **What do you dislike about Snowflake?** There is nothing to dislike about the product other than the ambiguity involved with the pricing. In addition, host information was slightly tricky to find. **What problems is Snowflake solving and how is that benefiting you?** Quickly scale our database at different times of the day. In addition, it's easy to set up new schemas, and perform CRUD operations. ### 33. Snowflake comes to New Zealand-a while back **Rating:** 5.0/5.0 stars **Reviewed by:** Dr Bradley I. | Enterprise Architect-Data, Enterprise (> 1000 emp.) **Reviewed Date:** January 17, 2022 **What do you like best about Snowflake?** It turns lots of source data into SSoT and feeds many data consumption tools, and potentially shares data with many other New Zealand Government organizations in a copy-less clone. **What do you dislike about Snowflake?** I am looking forward to unstructured data capability as it is restricted to structured and semi-structured data. **What problems is Snowflake solving and how is that benefiting you?** SF is SaaS, so we spend more time on data loading than managing the tech. True SSoT allows many users to access the same SSoT data to form MVoT info. ### 34. I've been using Snowflake for more then 5 years and very satisfy for their service **Rating:** 4.5/5.0 stars **Reviewed by:** Almog S. | VP Data & Research, Mid-Market (51-1000 emp.) **Reviewed Date:** October 15, 2021 **What do you like best about Snowflake?** It is fast, has no maintenance and operation around the tool, and has the ability to spin as much a WH you want in a click **What do you dislike about Snowflake?** not supporting yet Python UDF, support some time take some time to reply **Recommendations to others considering Snowflake:** go for it, it is the best out in the market **What problems is Snowflake solving and how is that benefiting you?** we are using it as our data lake and our DWH for all the business analysis we are performing and creating reports and dashboards on top of table stored in Snowflake ### 35. The Ultimate Data Warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Mid-Market (51-1000 emp.) **Reviewed Date:** November 25, 2021 **What do you like best about Snowflake?** Storage and compute power are separated so you can scale and manage performance levels as necessary. Integrates well with Tableau and Matillion ETL to form a robust software stack. **What do you dislike about Snowflake?** Whilst the different user roles help control permissions, it is easy to accidentally run an operation with the wrong one. New features are incrementally rolled out but would be nice to see the time-travel feature work over longer periods. **Recommendations to others considering Snowflake:** Would highly recommend going on the paid courses before setting anything up. These will prove invaluable in avoiding costly errors on setup and longer term. **What problems is Snowflake solving and how is that benefiting you?** We wanted to build a data warehouse in the cloud but outside of the company's network. This solution allows us to easily open up our data to clients as well as access external data sources. ### 36. Snowflake is recommended, but it doesn't come cheap. **Rating:** 4.0/5.0 stars **Reviewed by:** Kurt H. | Director - Data Management Office, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2022 **What do you like best about Snowflake?** Ease of administration and robust uptime. **What do you dislike about Snowflake?** Cost is quite high compared to competitors. **What problems is Snowflake solving and how is that benefiting you?** Data availability and ease of ingress. ### 37. Good Data warehousing tool and easy to use **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** October 30, 2021 **What do you like best about Snowflake?** Data pulling and querying is very good and it also can be connected to different other tools like tableau and python for the visualization and the analysis of the data. A very user friendly interface which does not take long to get used to it. I like that it's very fast and efficient. **What do you dislike about Snowflake?** Does not allow the user to use up the whole space for query writing and sql auto formatting is also not available. It would be great if the top menu ribbon can be minimized **What problems is Snowflake solving and how is that benefiting you?** As a data analyst, I use snowflake for pulling the data and analyzing it. Being a cloud managed tool, huge data can be accessed on the go without any need of in house data warehouse ### 38. Good cloud platform for analysing the data. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 21, 2022 **What do you like best about Snowflake?** We can get the data from AWS, GCP and analyze it on SF. **What do you dislike about Snowflake?** Faced functionality issues in some cases. **What problems is Snowflake solving and how is that benefiting you?** Was working on a migration project. Good UI, one should not worry about resource management. ### 39. Reliable data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 23, 2021 **What do you like best about Snowflake?** Snowflake is reliable, and pretty fast for most workloads. The best feature is you can save some money by using only the amount of computer that is needed. **What do you dislike about Snowflake?** Occasionally Snowflake takes a poor query optimization path. This is not unique to Snowflake though. **What problems is Snowflake solving and how is that benefiting you?** Data analtics, dashboards, training ML and evaluating ML quality. ### 40. Snowflake is core to our Data Hub **Rating:** 4.5/5.0 stars **Reviewed by:** Charles L. | Director - Data and Analytics, Enterprise (> 1000 emp.) **Reviewed Date:** December 15, 2020 **What do you like best about Snowflake?** on the fly scalable performance at an attractive cost. **What do you dislike about Snowflake?** The user interface could be a lot more GUI **Recommendations to others considering Snowflake:** Use their quick start program - its worth every penny **What problems is Snowflake solving and how is that benefiting you?** We are rationalize all the critical data elements from siloed systems of record into a Covata operational data store using a model purpose built for our business. ### 41. Best option for Data Lake **Rating:** 5.0/5.0 stars **Reviewed by:** Amit G. | Sr. Vice President, Enterprise (> 1000 emp.) **Reviewed Date:** December 23, 2021 **What do you like best about Snowflake?** ease of use, cloud based, quick onboarding, excellent integrations **What do you dislike about Snowflake?** Cost is an issue, getting skilled resources is a challenge **What problems is Snowflake solving and how is that benefiting you?** we have moved all our transaction data to snowflake and it is used for quick decision making, the stuff that was done with reports has now become on demand ### 42. An absolute dream **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Games | Enterprise (> 1000 emp.) **Reviewed Date:** October 28, 2021 **What do you like best about Snowflake?** Snowflake expedites the process of data querying in the best possible ways. It helps us out by: - finding compilation errors immediately - providing great functions - being insanely fast **What do you dislike about Snowflake?** I wish it had a dark mode! The linking process with Tableau is a little finicky, but on the whole, is a very good system. I do not have huge complaints about this product. **What problems is Snowflake solving and how is that benefiting you?** I use snowflake for querying, insights, and sharing our findings. ### 43. Great SQL alternative but sometimes not user-friendly **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Consumer Goods | Mid-Market (51-1000 emp.) **Reviewed Date:** November 16, 2021 **What do you like best about Snowflake?** I like that you only pay for what you use and it makes it easier for people starting their own businesses to have a reliable database without having to buy and pay for a server. **What do you dislike about Snowflake?** Not very user-friendly. It's hard to find table names and key words (like no autocorrect options). I also don't like not being able to use keyboard shortcuts like ctr+e and ctrl+H **What problems is Snowflake solving and how is that benefiting you?** Faster querying and ease to get data since the amount of data increased tremendously in my workplace and using sql server made things simply unmanageable. So a cloud-based solution was a great solution ### 44. Best Saas for dwh solutions **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 26, 2021 **What do you like best about Snowflake?** Time travelling and fail safe, good ui,IAM service **What do you dislike about Snowflake?** Can't search text and do operation on it (like edit) in a query available on snowflake. **What problems is Snowflake solving and how is that benefiting you?** Snowflake reduces the cost of operation, by MPP structure and many other features like time travel. ### 45. Snowflake the next gen cloud solution **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Investment Banking | Enterprise (> 1000 emp.) **Reviewed Date:** February 16, 2022 **What do you like best about Snowflake?** Ease of access, one-stop shop for data sharing problems in a financial sector **What do you dislike about Snowflake?** Perhaps, cost of owning a space is to be thought about **What problems is Snowflake solving and how is that benefiting you?** Socializing the data across enterprise without having multiple infrastructure and manpower within the same organization thereby optimizing the cost of ownership of data being acquired ### 46. Snowflake **Rating:** 2.5/5.0 stars **Reviewed by:** John H. | A, Small-Business (50 or fewer emp.) **Reviewed Date:** December 28, 2021 **What do you like best about Snowflake?** Excess of warehouse data/metrics that can be used internally **What do you dislike about Snowflake?** Customer service is not the best and can be slow **Recommendations to others considering Snowflake:** Make sure to research all their plans and technologies before selecting a plan **What problems is Snowflake solving and how is that benefiting you?** Warehouse capacity and efficientness ### 47. Snowflake is an excellent database **Rating:** 4.5/5.0 stars **Reviewed by:** Larry G. | Data Analytics Engineer (Remote), Mid-Market (51-1000 emp.) **Reviewed Date:** December 24, 2021 **What do you like best about Snowflake?** Very scalable and easy to integrate with my pipelines and visualization tools. Also very robust functions and functionality **What do you dislike about Snowflake?** User and profile management can be be a pain **What problems is Snowflake solving and how is that benefiting you?** Held our data for internal and external reporting ### 48. Data Management and Connection with Power BI **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** October 24, 2021 **What do you like best about Snowflake?** I usually use Snowflake with SAS and PowerBI, It is Awesome and very smooth with all microsoft products. Connectivity and refresh timing with PowerBI is phenomenal. **What do you dislike about Snowflake?** I really dont recall and dislike, but still i would recommend that screen size/Terminal size can be increased for writing SQL queries and result view window also can have some features like traversing to next/previous records, Sorting by variables, choosing top N records etc. **What problems is Snowflake solving and how is that benefiting you?** Yes, Very much, i use mainly as Data warehouse and consume that data using power BI. It really helps in faster connectivity and good refresh rate to manage data in millions. ### 49. Snowflake will capture a big Data Market soon **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** July 15, 2021 **What do you like best about Snowflake?** Snowflake is a growing Data Warehouse Storage and Analytics Technology which will capture a big Data Analytics market soon. Snowflake is a cloud-based technology that has reduced a significant burden from the customer in terms of hardware maintenance, replacing failed components, patch upgrade, 24*7 DBA support, etc. The best about Snowflake is its unique architecture. I worked on many DW Tools and found it better, among others with below reasons - 1. No hardware maintenance (it reduces Datacenter maintenance cost) 2. Architecture is simple and easy to understand 3. Cost is directly dependent on the system usage, less load - Payless and vice-versa. Most of the DBA work automated with its architecture - 1. Statistics collection 2. Query Optimization 3. Taking backup and maintenance 4. Warehouse auto-suspend and auto-resume. Cool features added in Snowflake - 1. Data Sharing 2. Data Marketplace 3. Data Masking 4. Zero-Copy Cloning 5. Time Travel 6. Fail-Safe 7. Structured and Unstructured data Storage and reading capabilities 8. And many more features I would surely recommend the companies that if you are planning to switch from the current DW env to another platform, do your POC on Snowflake once to know its benefits. Snowflake provides good customer support. **What do you dislike about Snowflake?** Currently, Snowflake has provided alerts set up only for resource monitoring if they can add the capabilities to generate custom alerts like sending notification on database size threshold increased, etc., through monitoring tool. **What problems is Snowflake solving and how is that benefiting you?** Few Snowflake features have saved DBA time in terms of taking data backup, creating dev, test environment using its zero-copy cloning features ### 50. Strategic Finance Manager **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** March 22, 2022 **What do you like best about Snowflake?** Easy usage for non-data savvy users and readers **What do you dislike about Snowflake?** The setup is not as straightforward as the usage **What problems is Snowflake solving and how is that benefiting you?** Using SQL to analyze financial and customer data ## 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?open_modal_url=%2Fproducts%2Fsnowflake%2Fwishlists%3Fhost_path%3D%252Fproducts%252Fsnowflake%252Freviews%253Fpage%253D6%26source%3Dsticky_header_pin&page=9§ion=pricing&secure%5Bexpires_at%5D=2026-07-18+04%3A24%3A52+-0500&secure%5Bsession_id%5D=75a7bd4b-faff-406a-b835-4afb1f075fd7&secure%5Btoken%5D=1271f8e5648a126664c51bba32f55175769b54578acc34285de4aa07feb7cf96&format=llm_user) ## Snowflake Integrations - [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) - [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) - [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) - [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) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - [Monte Carlo](https://www.g2.com/products/monte-carlo/reviews) - [MuleSoft Anypoint Platform](https://www.g2.com/products/mulesoft-anypoint-platform/reviews) - [n8n](https://www.g2.com/products/n8n/reviews) - [NextGen Healthcare EHR](https://www.g2.com/products/nextgen-healthcare-ehr/reviews) - [Okta](https://www.g2.com/products/okta/reviews) - [Omni Analytics](https://www.g2.com/products/omni-analytics-inc-omni-analytics/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 Market Research](https://www.g2.com/products/qualtrics-market-research/reviews) - [Salesforce Headless 360 Platform (formerly Salesforce Platform)](https://www.g2.com/products/agentforce-360-platform-formerly-salesforce-platform/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) ## 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 (1,319 reviews) - [Cloudera](https://www.g2.com/products/cloudera/reviews) - 4.1/5.0 (131 reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,144 reviews)