Snowflake Reviews

Overall rating
Filter by
Company size
Time used
87 Reviews

- Industry: Retail
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 8.0 /10
Best Data Warehouse in the Market
Reviewed on 2023/03/03
Overall for us Snowflake platform is highly scalable and secure. It includes a number of advanced...
Overall for us Snowflake platform is highly scalable and secure. It includes a number of advanced features and functionalities that help businesses store, process, and analyze large amounts of data in real time. The advantages for our organization include its ease of use, fast query processing, and robust security features. Lately we have used for snowflakes to migrate from our legacy systems as this platform was faster and easier and also integration with other tools was also very efficient.
Pros
For us Snowflakes has been critical to process and store the data day in and day out. Integration with various data sources and tools, including ETL/ELT tools, BI tools, and data science platforms has been critical for our organization and the teams. Snowflake's ability to handle large amounts of data and process it quickly is impressive. The platform is adaptable and provides us with numerous options for data management. Snowflake's distinct architecture enables us to easily manage and process data. The user interface is simple, and the platform is dependable.
Cons
Lately the new user interface is not comfortable and is confusing. The older user interface was much more easier. At times query performance issues are observed and timeout happens. Also cost per query is concern and expensive. Cost should be priced reasonable.
- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Great Cloud-Based Relational Database
Reviewed on 2022/01/13
Pros
The convenience of a single data lake that can be sectioned off in any way needed paired with a pricing model that encourages a high volume of data storage and ease of use make Snowflake an enjoyable tool to navigate. They've developed a solid community for knowledge sharing and have experienced, competent staff.
Cons
It can take a minute to remember which admin account needs to be used for performing specific actions. Sometimes pressure may be felt to save multiple queries and run them close together rather than sporadically to minimize computation costs, although after the first minute these are billed by the second and the pressure lessens.
Alternatives Considered
Amazon RedshiftReasons for Switching to Snowflake
Snowflake rated with higher ease of use for the end user and the pricing plan and capacity made the most sense for a small to mid-sized operation looking to continue growing.- Industry: Consumer Goods
- Company size: 10,000+ Employees
- Used for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Save your Data
Reviewed on 2020/07/16
I really like the fact that i can store my data in snowflake and use that to create visualizations...
I really like the fact that i can store my data in snowflake and use that to create visualizations in tableau.
Pros
1 - I like the way it stores the big data.
2 - Convenient to connect with tableau for visualizations.
Cons
1 - Costly if data is too big
2 - You can't own the data, you have to depend on the Data Engineering team.

- Industry: Electrical/Electronic Manufacturing
- Company size: 5,001–10,000 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 8.0 /10
Snowflake, Unique just like Us
Reviewed on 2019/10/31
My overall experience with Snowflake has been a pleasurable one. Though there have been some...
My overall experience with Snowflake has been a pleasurable one. Though there have been some frustrations at times I have learned and overcome and become a better programmer, and SQL developer for it. I feel like Snowflake is an old friend now.
Pros
The thing that I like most about this software is really if you can think it you can do it with Snowflake. I mean as long as it deals with data. I first started at my company using oracle and I didn't stick with that for long because we adopted snowflake. When we started using snowflake my knowledge of SQL just jumped sky high. Instead of just selecting from tables, I was using cte's and partitions and all of that fun stuff. Snowflake made it super easy to understand and learn. The ability it has to handle the amount of columns that it does is amazing.
Cons
There is a little bit of a learning curve to get the hang of it. But on the surface it is just like any other sql language and you just have to figure out the different quirks that it has. I wish it could give data instantaneously and read my mind on what I want but that is pretty much impossible so I'm going to stick with what I have.
- Industry: Construction
- Company size: 10,000+ Employees
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Solid Modern platform for EDW
Reviewed on 2022/04/28
Their customer service and training have been solid - I think MS takes the edge here for training...
Their customer service and training have been solid - I think MS takes the edge here for training but Snowflake wins for customer service (at least on non-business critical issues)
Pros
Exceptionally easy to scale up or out based on needs, and some nice cost-saving features like auto-suspend/resume for compute stuff. It supports ANSI SQL so it's not the end of the world to port over code from legacy SQL platforms. It also has a ton of integrations with your cloud provider of choice (as long as it's GCP, AWS, or Azure). According to their roadmap it will support Python eventually as well as their current SQL and JavaScript syntax for stored procs. Just a ton of functionality out of the box.
Cons
Pricing isn't the MOST transparent at first glance, but is fairly intuitive/controllable once you understand it . The current WebUI is absolute garbage. Luckily that's being deprecated for "Snowsight". Role inheritance and object ownership also has a decent learning curve compared to SQL Server, for example. This isn't a knock against Snowflake, but users should not expect this to have the same sort of OLTP-type performance and a typical relational DBMS. Just know the limits.
- Industry: Computer Software
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Great Data Warehouse Product
Reviewed on 2022/08/01
This is a very good product. I've had a very good experience with Snowflake.
This is a very good product. I've had a very good experience with Snowflake.
Pros
If you know SQL this is an easy product to use. I love that it can search on JSON and it allows us to create very custom User Defined Functions that can use multiple languages such as JS and Python as well as SQL.
Cons
Setting up the permissions can be confusing and complicated.
Alternatives Considered
Amazon RedshiftReasons for Switching to Snowflake
We chose Snowflake since it has a better feature set and was much more stable.- Industry: Consumer Services
- Company size: 51–200 Employees
- Used Weekly for 6-12 months
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 8.0 /10
Relatively new to using Snowflake, but the documentation provided is very helpful
Reviewed on 2024/04/01
Pros
I like that when I make an error when writing SQL, that I get a prompt that is descriptive enough for me to correct my mistake.
Cons
I haven't used it long enough to have any cons. Thus far it does what I need it to do.

- Industry: Information Technology & Services
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
My take on Snowflake
Reviewed on 2023/02/13
It perfectly bridges the gap between a Data Warehouse and a Data Lake being highly available, good...
It perfectly bridges the gap between a Data Warehouse and a Data Lake being highly available, good for scaling up or down as per needs automatically to provide the best performance and optimization for your queries. Can store and give access to huge volumes of data which can be necessary for future decision making.
Pros
Using Snowflake has been a great experience; I appreciate how easy it is to view, analyse, and produce reports that are helpful for the organization's business. Its cloud nature, eliminates the need to install software and does not affect how our machines work at all during analysis, is another feature I thoroughly appreciate. I adore how it offers many modernised SQL capabilities as well as practical tools for protecting data which can be sensitive in nature.
Cons
The capability to launch numerous queries is absent. The searches occasionally take longer than usual, and with no estimated time as to how long it takes is agonising. There could be a history tab for instance to see all the previous queries written or executed so it can be easy to refer and take part of the previous query instead of writing it again from scratch. There is no straightforward way to convert the SQL queries to Snowflake.

- Industry: Computer Software
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Snowflake - Next generation cloud warehouse
Reviewed on 2022/01/15
Best cloud data warehouse platform at the moment. Love, everything Snowflake has to offer. Easy to...
Best cloud data warehouse platform at the moment. Love, everything Snowflake has to offer. Easy to build pipelines, data sharing from production to non-prod in seconds, 0-copy cloning in 0-seconds :), amazing time travel, robust security, near real-time data ingestions, flexible compute power, and all possible compliance and certifications we can expect (Hippa/PCI/sox etc) indeed "built for the cloud"
Pros
Snowflake is easy to onboard and adopt, implement, easy to use.
Cons
Limited monitoring capability and data analytics features.
Alternatives Considered
Amazon RedshiftReasons for Switching to Snowflake
Better pricing and support :)
- Industry: Computer Software
- Company size: 10,000+ Employees
- Used Weekly for Free Trial
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Great platform that can be used to govern your data, and manage data warehousing
Reviewed on 2023/02/06
Pros
I like best that they have unified all the data-relevant features on one platform, so be it a single database or end-to-end data management, all can be done using snowflake. I was able to store structured, semi-structured, and unstructured data, all in one place.
Cons
Their support team was a little slow in addressing my queries. I belive they can improve their onboarding process.
- Industry: Farming
- Company size: 51–200 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Corporate isn’t Complete without Data
Reviewed on 2023/03/27
Snowflake automatically integrate, model and visualize data.
Snowflake automatically integrate, model and visualize data.
Pros
It is through Snowflake that we eradicated the need for data scientists since it offers self-service data modeling tools that help model and visualize data.
Cons
I haven’t used Snowflake for quite long, but I have never had any challenge for the entire duration I have turned to it.

- Industry: Security & Investigations
- Company size: 10,000+ Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 6.0 /10
Great Database Storehouse
Reviewed on 2022/06/09
It is a great data warehouse that allows you to create different tables very quickly. It has been...
It is a great data warehouse that allows you to create different tables very quickly. It has been great to use even if there are some quirks with it.
Pros
It is able to hold and process extremely large amounts of data in a timely manner. It also allows you to organize the data and limit access which roles have access to which data.
Cons
There are two features that could use improvement. First is the inability to move tabs with different code around. This makes it impossible to organize tabs that go along with certain projects which is frustrating. It also saves every tab you ever created even when you delete the tab. While I understand this can be helpful if you accidently delete something, it would be nice to have the option to delete the cached tabs if I wanted to.
- Industry: Retail
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Cloud based database and warehousing improves performance and reduces cost
Reviewed on 2020/12/19
its a great experience, our API's have become faster in response time, we stoped worrying about...
its a great experience, our API's have become faster in response time, we stoped worrying about storage size and computation power , now its scalable and decoupled
Pros
This is a fully managed cloud data-warehousing solution , or database as a service, the advantage of this with the traditional server based database is the performance boost, here the warehouse or the computing power and data storage is fully decoupled, this means , you can pay for what you need, your warehouse can be in sleep when its not in use so you save money, you can modify the size of warehouse so you get your performance as you want, and it supports the advance queries like 'copy' into local files and s3 etc ..,
coming to the operations, the snowflake has query history well maintained with importance performance metrics , and they have a good support team who responds quick,
they have a web workbench which stores our query on different tabs with different configurations, they have role based authentication for each elements on database,
they have good documentations and community for an help regarding the queries etc..
Cons
we use to have some outages in the past, which was resolved quick, now a days i don't see those that's a good thing, if you are trying to migrate from a psql to snowflake then some query syntaxes will be different
- Industry: Pharmaceuticals
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
Did a proof of concept for my company comparing Snowflake to other databases that we use.
Reviewed on 2017/12/26
Pros
The three features of many great features that stand out are:
-The REAL separation of compute and storage gives the ultimate flexibility. You can match workloads to the proper level of compute without having one workload collide with another. You can optimize what you spend by only using what you need with the ability to change the size of your compute multiple times a day and the ability to stop and resume compute nodes easily.
-No other database I have ever used can handle concurrency like Snowflake. Additional clusters are automatically spun up if a query is queued
-There is no tuning that needs to be done as this is a data warehouse as a service. No other database comes close to the Snowflake performance without additional tuning. I can put in some time and tune my Oracle, Teradata or HANA database to get similar or slightly better performance but the level of DBA needed to do this is costly. This is especially helpful when the query patterns to be run against the database are unknown.
Cons
One of the positives above can also be a negative. Snowflake is a service and not software that you can run in your own data center or your own cloud VPC. This CON can be overcome with end to end encryption where you own the key and other Snowflake features.

- Industry: Computer Software
- Company size: 1,001–5,000 Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Fast and easy Data warehouse.
Reviewed on 2022/10/16
Its been very good experience to use snowflake. Our product performance is increased by using this...
Its been very good experience to use snowflake. Our product performance is increased by using this tool.
Pros
Its very fast and easy to use. Execution of query is very fast and manage caching for improving performance. For getting data from different different databases its easy to get the data with snowflakes.
Cons
As I have used Sql server so some times it’s difficult to find syntax. Finding error if you have long query and showing ambiguous error then its very difficult to resolve as not suggest any line number. Tabs are not movable which I don’t like.
- Industry: Information Technology & Services
- Company size: 501–1,000 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Snowflake - Speed in the Cloud!
Reviewed on 2019/11/20
Maintaining on-premise database systems is expensive and maintenance heavy. Moving to a cloud...
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.
Pros
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.
Cons
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.
- Industry: Computer Software
- Company size: Self Employed
- Used Weekly for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Review for Snowflake
Reviewed on 2021/09/22
Snowflake is very appropriate assuming your association needs to begin little with negligible...
Snowflake is very appropriate assuming your association needs to begin little with negligible speculation, and afterward develop at any speed. It is additionally useful for groups that definitely know SQL from chipping away at another stage, like MS SQL Server. It matches all around well with incorporation errands on account of its local capacity to deal with JSON information, for both import and questioning.
In the event that your instruments can just associate by JDBC (no local Snowflake connector) you might have a few issues with enormous informational collections. This is actually a restriction of utilizing JDBC, not Snowflake, but rather it is something to know about.
Pros
This is a cloud-based application that gives me a safe stage to the simple sharing of information with my customers.
I feel sure to associate with my various colleagues as a result of its high level security and successful programming.
Through this instrument, I am equipped for incorporating, dissecting, and the whole information in an exact structure and with investigation also, because of which I generally have a straightforward thought regarding the information extraction and its exchange from numerous mists.
Cons
Security jobs and access are difficult to comprehend and oversee
Rollout of new components appears to intensely support US West coast, every other person needs to pause
Visual interface doesn't permit you to oversee custom capacities and schedules. For those, it is code as it were. The board of tables and perspectives is visual

- Industry: Computer Software
- Company size: 10,000+ Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Snowflake - The next generation cloud data warehouse
Reviewed on 2021/08/09
It's really great, Snowflake offered a lot of flexibility which parallel cloud-based warehouses...
It's really great, Snowflake offered a lot of flexibility which parallel cloud-based warehouses could not offer the same. Snowflake can scale both vertically and horizontally to cater all needs.
Pros
Snowflake is very easy to use and scale. It provides helpful features like merge, JSON flattening which are very handy options. Snowflake cloud SQL editor is very fast and helps easy developments.
Cons
It can be a costly solution if optimizations are not planned accordingly.
- Industry: Computer Software
- Company size: 201–500 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 9.0 /10
Totally satisfied from Snowflake
Reviewed on 2022/10/20
Pros
Configuring the Warehouses can give you endless possibilities.
Cons
There are some implicit casts in data types sometimes that seem to be the default behavior
- Industry: Information Technology & Services
- Company size: 10,000+ Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 10.0 /10
Best cloud data warehousing solution for all reporting needs.
Reviewed on 2022/10/12
Pros
We can schedule the data synchronization timelines, and store the data for analytical and reporting purposes.
Cons
I don't find any thing to dislike, it serves the purpose of data warehousing for reporting.
- Industry: Marketing & Advertising
- Company size: 51–200 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Vipul Chona - Snowflake Review
Reviewed on 2021/09/03
Pros
very easy to integrate with all our other tools
Cons
Honestly having a tough time coming up with what I like lease. Maybe some of the UI

- Industry: Financial Services
- Company size: 1,001–5,000 Employees
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 4.0 /10
Transition Extremely Difficult
Reviewed on 2020/06/16
The ramp up has been difficult. There are a couple key features missing that might overpower the...
The ramp up has been difficult. There are a couple key features missing that might overpower the strengths of the software.
Pros
The interface is very attractive, it is extremely fast to query huge datasets, and there is a strong online community of users to learn from.
Cons
I think it has the possibility to be a great software for querying huge databases, but some of the basic uses of that data are hard to come by - it is difficult to interface with Microsoft products.
- Industry: Automotive
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Best cloud data warehouse as a service available to date
Reviewed on 2018/02/16
Centralized data.
Centralized data.
Pros
Easy setup and configuration.
The Ability to scale up and scale down at needed.
Pay as you go and only for what you use.
Cons
Limited to AWS currently with planned expansion to Azure and GCP.
On-Premise is not an option, but VPC is.
- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Weekly for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Super Scalable
Reviewed on 2018/10/10
Pros
My favorite feature in Snowflake is the ease of use provided by SnowSQL. You can create variables in SQL that you reference throughout your queries. It additionally performs super fast and reduces many management needs.
Cons
Snowflake lacks the ability to create stored procedures, this would add a lot of value and ease of use to the software. While the lack of management is great, I find that it may not always be worth the cost for it. In addition to this, it does not perform well (or at all) as an ETL Tool.
- Industry: Hospitality
- Company size: 201–500 Employees
- Used Weekly for 1-5 months
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 10.0 /10
Great learning platform for SQL
Reviewed on 2022/12/26
I am currently learning SQL and my company uses Snowflake. It's been a great learning tool for me...
I am currently learning SQL and my company uses Snowflake. It's been a great learning tool for me to see how all of our data tables are connected and how to get the data I want from each table. We are able to take what we create in Snowflake and then make that a permanent metric in Looker, a fantastic feature to further help with visualization.
Pros
Product is easy to use to go along with a Udemy course I am taking. If making an error in how I input the SQL, it will point out to me where my error was, making it easy to correct.
Cons
So far I don't have any, as I'm still in the learning phase and wouldn't know if any limitations are based on the software, or based on my limited knowledge.