We use the solution for data. We like that there are so many different formats and many structures for analysis.
Principal Consultant at a tech services company with 51-200 employees
Excellent data warehousing, quick to scale, and knowledgable technical support
Pros and Cons
- "From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
- "The user interface continues to be an issue, especially when we need to get data out of Snowflake. It's very easy to get data in, but it's not too easy to get it out or extract it."
What is our primary use case?
What is most valuable?
The architecture we'll be using due to being on the cloud will assure we have less to do. There will be no indexing, for example. Everything's managed by the servers. That way, we can focus on the data warehouse and on the data.
From a data warehouse perspective, it's an excellent all-round solution. It's very complete.
What needs improvement?
The user interface continues to be an issue, especially when we need to get data out of Snowflake. It's very easy to get data in, but it's not too easy to get it out or extract it.
It would be nice to have some built-in solutions that would solve. for example, how to delete data from a customer when they request it.
There needs to be stronger data protection.
For how long have I used the solution?
I've been using the solution for just a bit less than a year at this point.
Buyer's Guide
Snowflake
October 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
815,854 professionals have used our research since 2012.
What do I think about the stability of the solution?
Our clients have been very impressed with the solution's overall stability.
What do I think about the scalability of the solution?
The scalability is incredible. It's the best I've ever seen. Organizations can scale easily. I can scale up four times faster as well. Something that usually takes 60 minutes can be done in 15 or 20 minutes. It's faster and I save costs because I only pay for the time. Even though I'm paying "more" I end up saving money with this time based costing.
How are customer service and support?
I've only contacted technical support a handful of times. I have, however, found them to be very savvy product-wise and very helpful. Their technical support staff are all experts. They know the product extremely well.
How was the initial setup?
The initial setup is very straightforward. I wouldn't describe it as complex.
How long it takes to deploy depends on your knowledge and your background. It's difficult to judge. I've been working for 20 years now with data warehouses. For me, it was very easy because of my extensive background. However, it depends on what someone knows, and their technical background. It can be difficult for others who maybe don't have as much knowledge or first-hand experience with warehouses.
What about the implementation team?
We're partners with Snowflake. We support our customers and can help them implement it as necessary.
What's my experience with pricing, setup cost, and licensing?
The solution has an excellent pricing strategy. The costs are open and transparent. If you don't use it, you don't pay for it. It's that simple.
What other advice do I have?
We're partners with Snowflake.
The difference between Snowflake, and, for example, Azure, is that there is real separation between the computer and storage. Snowflake is the only one that's really separate and it's much simpler to scale or shift data. It makes everything much easier.
One of the best options on the market right now is to have a cloud-only setup. Not everyone is using the cloud, but everyone will catch up.
I'd rate the solution nine out of ten. If the user interface was better and they had a few more features and did some useability tweaks it would be perfect. Also, it's hard to get the data out of Snowflake, and that's a real issue design-wise.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Data & Analytics Practitioner at a tech services company with 1,001-5,000 employees
Could use better integration, but very stable with an easy initial setup
Pros and Cons
- "They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises."
- "The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template."
What is our primary use case?
We primarily use the solution for data warehousing.
What is most valuable?
The entire managed service operations for the solution is great. Snowflake does everything for us. Whatever version they have, they implement the latest for us; we don't have to worry about any versions, any upgrades, anything else because they handle it.
What needs improvement?
The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template.
The integration capabilities could be improved.
For how long have I used the solution?
I've been using the solution for six months.
What do I think about the stability of the solution?
The solution has been very stable for us.
What do I think about the scalability of the solution?
We have not tested scalability, but the solution claims that it's scalable. It's on the cloud, so I imagine you could scale rather easily if you needed to.
They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.
We have about 40 people using the solution. They're mostly business users.
How are customer service and technical support?
Technical support is good. Occasionally, they take a bit of time to resolve issues, but other than that they are okay. We're mostly satisfied with them.
Which solution did I use previously and why did I switch?
We're system integrators, so we use different solutions including SQL Server Data Warehouse and Greenplum as well as Snowflake at the moment.
I've used many data warehouse solutions, including Hadoop, and Oracle SQL Server Data warehouses. I switched from those to Snowflake because Snowflake is on the cloud and gives you separate computing and storage scalability, which Hadoop is unable to offer.
How was the initial setup?
The initial setup is straightforward. There's no deployment; it's just your code solution that needs to get up and running. You have a deal with Snowflake in terms of what environment you want, and when you want to use it, and they'll set it up within a day for you.
What about the implementation team?
Snowflake helped us with the implementation.
What other advice do I have?
We are system integrators, so for all our customers, we offer different solutions.
We only use the cloud deployment model. Snowflake doesn't offer on-premises deployments.
Snowflake on cloud is the best right now. There are only a few other options. Redshift is not scalable. With SQL Data Warehouse the concurrency is an issue, as well as scalability. Also, it does not have all the features that you see in an on-premises SQL Server.
Snowflake a good database. I'd recommend the solution to others.
I'd rate the solution seven out of ten. We are still new to the solution. There are a few things we still have to explore before we would give it 10. Typically, I come from a Hadoop background, so compared to Hadoop I think everything looks good before the data warehouse side. We're quite pleased with Snowflake and moving from Hadoop into Snowflake has been a very good transformation.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Snowflake
October 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
815,854 professionals have used our research since 2012.
Senior Solutions Architect at a tech consulting company with 201-500 employees
Highly stable, extremely scalable, and easy to install
Pros and Cons
- "Data Science capabilities are the most valuable feature."
- "To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools."
What is our primary use case?
We use Snowflake as a data migration platform.
What is most valuable?
Data Science capabilities are the most valuable feature.
What needs improvement?
To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools. As a result, our solution architects must devote most of their time to addressing this issue.
For how long have I used the solution?
I have been using Snowflake for two years.
What do I think about the stability of the solution?
I give the stability a nine out of ten.
What do I think about the scalability of the solution?
I give the scalability a nine out of ten.
How are customer service and support?
The technical support team is good.
How was the initial setup?
The initial setup is straightforward. Since Snowflake is software, the only requirements to start using it are to select a subscription and activate our account.
What other advice do I have?
I give Snowflake a nine out of ten.
Snowflake is being used at the enterprise level.
If an organization is interested in embarking on its cloud journey and Snowflake fulfills its requirements, I would recommend it as a viable solution.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
An extremely stable and easy-to-set-up solution with valuable features like cloning and data sharing
Pros and Cons
- "The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem."
- "It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
What is our primary use case?
I work for a company that are Snowflake partners and help clients implement solutions using Snowflake.
How has it helped my organization?
Snowflake solves many of the challenges that traditional data warehousing tools have such as a lack of agility, scalability and fine-tuning.
What is most valuable?
The use of micropartitions and metadata means that there is very little management needed and the user can focus purely on actually getting value out of their data. In addition, the cloning feature makes problem resolution and cutover extremely pain-free.
What needs improvement?
Whilst flexibility is one of its key strengths, it would be useful if there could be some better governance built into the product. In addition, functionality out of the box to deal with common data warehousing scenarios (e.g. slowly-changing dimensions etc.) would be great.
For how long have I used the solution?
I have been using Snowflake for about a year and a half.
What do I think about the stability of the solution?
It is extremely stable.
How are customer service and technical support?
The support from Snowflake is absolutely great. All kinds of content and things are available to support yourself as well as to be able to talk through issues and have their engineers take a look at the problems. They are very responsive.
Which solution did I use previously and why did I switch?
We use Snowflake alongside other data warehousing tools. Ultimately it depends on what the client wants to implement and their existing architecture as to what would be the best choice.
How was the initial setup?
The initial setup is very straightforward.
What's my experience with pricing, setup cost, and licensing?
Snowflake has a very efficient pricing mechanism where you only pay for what you use by the second making it very easy to control costs.
What other advice do I have?
The best advice I would give is to push for a POC. Pick a couple of use cases where you think you could quickly get value and just see how quickly you can get it implemented. One of the key features of Snowflake is that you can get it up and running straight away.
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
CEO, Senior Consultant at a tech services company with 1-10 employees
Sophisticated- cutting edge technology with zero clone copy and near zero maintenance
Pros and Cons
- "Great scalability and near zero maintenance."
- "Some SQL language functions could be included."
What is our primary use case?
The solution is mainly used for analytics in data warehouses. We are independent consultants and customers of Snowflake.
What is most valuable?
The scalability of this product is great and the fact that it has a so-called zero clone copy and is near zero maintenance is also great. There are a lot of good features, it's a very sophisticated, cutting edge technology and is super easy to use. They are developing the platform very, very quickly so there are plenty of new features implemented all the time. You can concentrate on implementing things in Snowflake without tuning or configuring it.
What needs improvement?
There are some functions in the SQL language in other products which are not yet included in Snowflake's SQL. It would be helpful to have those included, they're nice features. It's a minor issue because all those things can be implemented in some other way. Not essential, but it would be nice to have them.
For how long have I used the solution?
I've been using this solution for 18 months.
What do I think about the stability of the solution?
This is a stable solution and the maintenance and updates are automatic. Snowflake is responsible for that.
How are customer service and technical support?
I have been quite satisfied with the technical support.
How was the initial setup?
The initial setup is very simple, just go to the internet and start using it. Of course, if it has to implement to part of the customer's own cloud infrastructure, then there are more steps to configure. We provide that service for our customers.
What's my experience with pricing, setup cost, and licensing?
Everything is included in the license fee which is mid-range in terms of pricing.
Which other solutions did I evaluate?
The advantage of Snowflake is that you can focus on implementing things in Snowflake without tuning or configuring it. That's the advantage of this solution compared to others. Many other data warehouse solutions need some kind of maintenance or database administration, and that takes time. The extra time means you're being taken away from other things and in that regard, Snowflake is an absolutely great product.
What other advice do I have?
I think the solution is suited to big companies because they tend to have lots of data. The more data you have, the more you need power and scalability to process it. I would recommend finding a good partner already familiar with the solution for implementation. It's good to have someone familiar with the architecture.
I rate this solution a 10 out of 10.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Consultant
Big Data & Cloud Manager at a tech services company with 1,001-5,000 employees
A cloud solution with many useful features and data science capability
Pros and Cons
- "It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability."
- "We would like to be able to do modeling with Snowflake. It should support statistical modeling."
What is our primary use case?
We are using it for optimizing costs and using financial data.
What is most valuable?
It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability.
What needs improvement?
We would like to be able to do modeling with Snowflake. It should support statistical modeling.
For how long have I used the solution?
I have been using this solution for more than a year.
What do I think about the stability of the solution?
It is stable.
What do I think about the scalability of the solution?
It is very scalable. We currently have more than 50 users. We can increase its usage.
How are customer service and support?
I have not contacted their support.
Which solution did I use previously and why did I switch?
I used Cloudera One about two years ago.
How was the initial setup?
It is easy. It is a SaaS solution, so there is no installation. Therefore, you don't need the infrastructure team, but you need a few data analysts.
What's my experience with pricing, setup cost, and licensing?
It is pay-as-you-go. Its cost is in the medium range.
What other advice do I have?
I would rate it a 10 out of 10.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Engineer at Celebal Technologies
Easy to scale, a simple initial setup, and good stability
Pros and Cons
- "The initial setup is straightforward. You just need to follow the documentation."
- "The solution could improve the user interface and add functionality to the system."
How has it helped my organization?
We mainly used SQL scripts and provided a solution for different owners who want to query a database but have several tables. Typically, it is not an easy task to read several tables, so we provided our client with a very crisp data model where they can get results in a very quick manner. We implemented distribution as well as weekly partitioning.
What is most valuable?
The relational piece and how one dimension relates to another just by using a key is the solution's most valuable aspect. We are managing everything by using simple relations. It's all about the relationships between dimensions.
What needs improvement?
Right now, we need to write code, but if they could create a version of Snowflake that was more drag and drop for those managers that don't know how to code, it would be great for our business.
The solution could improve the user interface and add functionality to the system.
For how long have I used the solution?
I've used the solution for two years.
What do I think about the stability of the solution?
The solution is stable. We bring in incremental loads into Snowflake. There are pipelines that daily seed data from Oracle to a data warehouse. It's a prebuilt code and it allows for great stability.
What do I think about the scalability of the solution?
It's very easy to scale because Azure cloud's own data warehouse gives us that capabilities to scale up or down at any time we want. There are a great number of users on the solution, but it differs from client to client. One client, for example, has about 30,000 users.
How are customer service and technical support?
We've never been in touch with technical support.
How was the initial setup?
The initial setup is straightforward. You just need to follow the documentation.
What about the implementation team?
We handled the implementation ourselves. I've handled two or three projects previously, so I'm comfortable with the solution. We don't need assistance because we handle the consulting part.
What other advice do I have?
The solution is deployed on the cloud using Azure, where there's a data warehouse. We primarily use SQL scripts.
For those considering implementing, I'd advise that they understand the business very deeply first. Not every business would have a demand for Snowflake, so it's not for everyone. It's important to understand the requirements and then, if it makes sense, to implement Snowflake.
I'd rate the solution eight out of ten. I'd rate it higher if it had a better user interface.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Enterprise BDM and Solutions Speacialist at a tech services company with 10,001+ employees
Scalable, easy to understand, and has reasonable pricing
Pros and Cons
- "The pricing is reasonable and matches the rest of the market."
- "The pricing of the solution should be much easier to calculate or find by yourself."
What is our primary use case?
The solution provides services to our customers.
What is most valuable?
The solution is very easy to understand. It's a simple solution. It's not complicated.
The product does a lot of wonderful stuff that a lot of these companies want to do without too much effort.
The initial setup is straightforward.
The pricing is reasonable and matches the rest of the market.
The solution is quite stable.
Our clients have not had any trouble scaling.
What needs improvement?
The pricing of the solution should be much easier to calculate or find by yourself.
Clients want to get a rough idea as to how much it's going to cost for year one, year two, year three, et cetera. There is a calculator that Snowflake gives you, however, more often than not, you have to go to Snowflake to get those numbers. You can't do it yourself. To simplify things, it could be easier if they made it maybe easier to understand the cost and what the outgoing cost for a customer would be.
In the future, if they added AI capabilities, that would be ideal.
For how long have I used the solution?
I've been using the solution for about a year. It hasn't been that long. The company that I work for, on the other hand, has likely used it for three or four years or so.
What do I think about the stability of the solution?
The stability of the solution is very good. There are no bugs or glitches. It doesn't crash or freeze. It's very reliable in terms of performance.
What do I think about the scalability of the solution?
We haven't heard of clients having issues with scalability. It can expand well. A company that needs to grow it out can do so without any trouble.
How was the initial setup?
The initial setup is not too complex. It is pretty straightforward. A company shouldn't have too much trouble implementing the solution.
What about the implementation team?
We deploy such solutions for our clients if they require it.
What's my experience with pricing, setup cost, and licensing?
We are the first global premier partner. We have the highest level of Snowflake partnership
The licensing is a bit tricky as it's hard to calculate pricing ahead of time.
That said, most customers I have dealt with have no issues at all with the pricing. They think it's reasonable. Obviously, everybody, every single customer, wants to receive a price. That goes without saying. However, if you ask me if it's a fair price for the market, the answer is yes.
What other advice do I have?
We don't recommend a cloud typically. We leave it to the customer. If the customer has AWS, and then we sell Snowflake on AWS. If the customer has Google, we sell Snowflake on Google or Azure, or if they have Azure, we sell Azure. They may even have a private cloud. We don't force the customer to buy a particular cloud. We go with the customer's preference from their cloud services because Snowflake works on all three clouds.
In general, I would rate the solution eight out of ten. It does what it says it will, and I have yet to hear of customers complaining about its capabilities.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Popular Comparisons
Azure Data Factory
Teradata
Microsoft Azure Synapse Analytics
Oracle Exadata
Vertica
Amazon Redshift
VMware Tanzu Data Solutions
Matillion ETL
VAST Data
BigQuery
Dremio
AWS Lake Formation
Amazon EMR
Apache Hadoop
Oracle Autonomous Data Warehouse
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?
- What is the major difference between AWS Redshift and Snowflake?
- What is the biggest difference between Apache Hadoop and Snowflake?
- Which solution do you prefer: Oracle Exadata or Snowflake?
- Which is better - Azure Synapse Analytics or Snowflake?
- How to achieve sub-second query performance with JSON data (~1B rows) in Snowflake?
- Which is better for Snowflake integration, Matillion ETL or Azure Data Factory (ADF) when hosted on Azure?
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?