Try our new research platform with insights from 80,000+ expert users
Marketing Communications Manager at a financial services firm with 1,001-5,000 employees
Real User
Top 10
Configurable and scalable
Pros and Cons
  • "The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
  • "I have heard people having difficulty with the machine learning model, so there may be room for improvement."

What is our primary use case?

We use the solution to support our data infrastructure.

What is most valuable?

The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake. We can configure the size of our workloads because Snowflake gives us control over the use of resources and costs.

What needs improvement?

I have heard people having difficulty with the machine learning model, so there may be room for improvement.

The cost of the solution is high and has room for improvement.

For how long have I used the solution?

I have been using the solution for over one month.

Buyer's Guide
Snowflake
December 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,020 professionals have used our research since 2012.

What do I think about the scalability of the solution?

I give the scalability an eight out of ten.

What's my experience with pricing, setup cost, and licensing?

The solution is expensive but worth the cost because the quality is there.

What other advice do I have?

I give the solution an eight out of ten.

I advise people to do as much research as they can before utilizing the Snowflake.

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.
PeerSpot user
reviewer1550751 - PeerSpot reviewer
CEO at a computer software company with 51-200 employees
Real User
A cloud computing-based data warehousing solution with a valuable feature called Snowpipe
Pros and Cons
  • "Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
  • "It would be better if they had a data profile tool that tells me where the gaps are in my time series data."

What is our primary use case?

We have a data mart, and we are using it to share data with big enterprise customers with major security requirements.

What is most valuable?

Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost. Then we just share it out, and all the compute expenses are charged directly to our clients.

What needs improvement?

It would be better if they had a data profile tool that tells me where the gaps are in my time series data. We are anxiously waiting for them to release their data catalog and analytics capabilities, which is going to happen in June or July. If that works the way we think it might, then that would just extend our firm's capabilities into a space that we have never been interested in building ourselves. It could be a really good thing for us.

For how long have I used the solution?

We started using Snowflake this year.

What do I think about the stability of the solution?

There's never any outage, and it's cross-cloud. The stability is not even a good question for that platform. It makes no sense to us.

What do I think about the scalability of the solution?

Snowflake is scalable. It does cost more money, but it's some kind of magic they're doing behind the scenes that you don't have to think about. It's brilliant, and it's going to take over completely.

How are customer service and technical support?

Their tech support is good. Their sales team is very technical, and they're able to speak to our engineers and walk them through what we need to do. 

Which solution did I use previously and why did I switch?

About three years ago, Databricks was sort of the hot thing among our clients, and everyone was using it for low-code analytics. We had to deliver data in a format that was specific to Databricks. Databricks had this massive growth, use, and adoption. They have a very good footprint now, but we see those same clients shifting their data to Snowflake, and pretty much nobody asks for Databricks anymore.

I think there's this big war sort of brewing between Databricks and snowflake. Snowflake is going to come out with the analytics capability that Databricks has. They're working furiously to get it released. I don't know what it's going to look like, but they're going head-to-head with Databricks. I think Snowflake is going to crush them.

What's my experience with pricing, setup cost, and licensing?

In the beginning, we didn't know what we were doing, and we racked up huge compute costs, shockingly and quickly. But the sales team was extremely helpful and showed us where we were doing everything wrong, and they explained to us how best to use their platform. We have massively funded data engineering teams, but now our use has plummeted to almost free.

Because of the caliber of our customers at the time, we had to sign on to the enterprise subscription tier. We're a startup, and we didn't know it at the time, but the cost per credit for the enterprise tier was almost double. 

The cost per credit, that's where you get all this unlimited autoscale that you don't even have to think about. We don't really need any of that because they already provide all the redundancy, backup, failover, and all of that stuff. We scaled down and cut all of our costs almost in half by getting rid of that scalability capability because we don't need that.

They give a different price for every single company. I don't know if I negotiated that well, but we got the enterprise tier for $3 a credit, and the other two were a dollar-ninety a credit. I suspect we don't have almost zero compute usage, but I know that our annual contract packages are below all of their minimums.

What other advice do I have?

On a scale from one to ten, I would give Snowflake an eight.

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.
PeerSpot user
Buyer's Guide
Snowflake
December 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,020 professionals have used our research since 2012.
Principal Director at a tech vendor with 10,001+ employees
Real User
Easy to use, stable, and scalable
Pros and Cons
  • "The solution is easy to use."
  • "The price could be improved."

What is our primary use case?

We use the solution to migrate data from old legacy ERP systems into Snowflake which reduces our work by 70 percent.

What is most valuable?

The solution is easy to use. We have third-party integrations, which make it easy to migrate from our landing to our warehouse. Inside Snowflake, we can convert what we create, unlike other hyperscalers.

What needs improvement?

The price could be improved. The more data we consume, the higher the cost becomes. Our licensing will also increase. How can we use our licensing system effectively? We have expertise and experience in different implementations, and we have control of our licensing. Therefore, there is an accelerator that allows us to control these effective methods of licensing.

For how long have I used the solution?

I have been using the solution for three years.

What do I think about the stability of the solution?

We have had no issues with the stability.

What do I think about the scalability of the solution?

I give the scalability an eight out of ten.

How was the initial setup?

The initial setup is not complex.

What's my experience with pricing, setup cost, and licensing?

The solution is costly, making it unsuitable for midsize organizations due to its price.

I give the cost of the solution a seven out of ten.

What other advice do I have?

I give the solution an eight out of ten.

For organizations that do not wish to be confined to one type of hyperscalar, such as VM Azure, I recommend Snowflake as it provides greater flexibility.

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
PeerSpot user
reviewer1498041 - PeerSpot reviewer
Founder & CIO at a computer software company with 11-50 employees
Real User
Reasonable pricing with a straightforward setup and a good user experience
Pros and Cons
  • "The technical support on offer is excellent."
  • "There are always a few operation updates here and there that can be made."

What is our primary use case?

We primarily use the solution to build some cost-effective solutions for a data warehouse, mostly for all non-transactional data.

What is most valuable?

The solution is very fast. It's not clunky or slow.

The product, overall, is quite inexpensive. It's very cheap to use.

The solution is extremely user-friendly and easy to navigate. The user experience is very good.

The initial setup is pretty straightforward. It's simple.

We found that the initial setup was pretty easy.

The solution has been stable and has provided good overall performance.

A company can easily scale the solution. It's not too difficult to pull off.

The technical support on offer is excellent. They're helpful for the most part.

What needs improvement?

There are always a few operation updates here and there that can be made. However, overall, there aren't any features or glaring shortcomings. It's pretty good. We can't complain.

While the solution is quite inexpensive, there is always a push from clients that want it to be cheaper in the future.

For how long have I used the solution?

I have about six years' worth of experience with the product. I've been using it for a while. I'm comfortable with its aspects. I've used it over the last 12 months as well.

What do I think about the stability of the solution?

The stability is very good. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. The performance is good.

What do I think about the scalability of the solution?

The product scales quite well. If a company needs to expand it, it can do so without any problem.

We deal mostly with clients that have medium to large-scale organizations. It works well for both.

How are customer service and technical support?

Technical support has been excellent. I'd rate them nine out of ten. They are knowledgeable and responsive. We are quite happy with the level of assistance we receive if we need help.

Which solution did I use previously and why did I switch?

We've used a few other solutions including MySQL and a few other notable databases.

Right now, we are looking for some other options as well.

How was the initial setup?

The initial setup is quite simple. It's a straightforward process. It's not overly complex. A company shouldn't have any issues with the implementation process.

What about the implementation team?

We are implementors. We can implement the solution for clients if they need us to.

What's my experience with pricing, setup cost, and licensing?

The product is very reasonably priced. It's quite cheap to use. It's less expensive than, for example, Oracle.

What other advice do I have?

We are implementors of the solution.

We are using previous versions of the solution. It may not necessarily be the latest version all the time.

I'd advise other organizations to try it out and play with it a bit to see if it would fit their needs.

Overall, I would rate the solution at a nine out of ten. We've been mostly very happy with it.

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?

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1077408 - PeerSpot reviewer
R&D Operations Manager at a manufacturing company with 1,001-5,000 employees
Real User
You can assign roles and responsibilities, limiting access to data
Pros and Cons
  • "I like the idea that you can assign roles and responsibilities, limiting access to data."
  • "If you go with one cloud provider, you can't switch."

What is our primary use case?

We are a big data company. We have many thousands of devices deployed from our customer base. These devices upload data, on an hourly basis, to a central storage. Next, we run some ETF processes that crunch and process data, then we store that data in a structured way on Snowflake.

Over the past six months, it has been more of a development project.

I am using the latest version.

What is most valuable?

  • I like the idea that you can assign roles and responsibilities, limiting access to data. That has been very interesting to us. 
  • The robustness of the system is very useful to us. 
  • The availability of the system. 

What needs improvement?

We would like Snowflake to be able to do inter-cloud migrations. That would be great. I want to be able to switch clouds.

For how long have I used the solution?

Six months.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

If you go with one cloud provider, you can't switch.

We have very few users. There is just a very limited number who are mostly developers. We did not roll out the end product. We did not roll out product and services based on that foundation/infrastructure yet.

How are customer service and technical support?

I have not personally contacted technical support.

Which solution did I use previously and why did I switch?

We previously used HPE and Microsoft Insight. We switched to Snowflake for the availability, security, and loading times.

How was the initial setup?

The initial setup was very straightforward. It was very quick. The complexity came from our specific use case scenario.

Which other solutions did I evaluate?

We also looked at HPE and Microsoft Insight.

What other advice do I have?

Analyze your user scenario. If your scenario is managing large amounts of data in extremely, different environments in a structured way, then this is a good option.

I would rate this solution as an eight (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.
PeerSpot user
Director Consultoria at tecnoscala consulting
Real User
Simple importing, but reporting and documentation could improve
Pros and Cons
  • "Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
  • "The documentation could improve. They should provide architecture information."

What is our primary use case?

We use Snowflake for data warehouse modeling and reports.

What is most valuable?

Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.

What needs improvement?

The documentation could improve. They should provide architecture information.

There could be better integration with tools other than the common databases used to receive data. There are other tools that have ETL tools within, such as Tableau. You are able to work with information prior to sending it to Tableau. This feature would be nice to have in a tool from Snowflake.

In a future release, they should make it easier to do reporting. A drag and drop type feature would be good. If not a drag and drop feature, there should be some other easier way to do it than it is now.

For how long have I used the solution?

I have been using Snowflake for approximately six months.

How are customer service and support?

The experience that we have had until now is that we can use the Snowflake very well from the videos on the web. The knowledge that our company already has regarding this solution has helped. We are producing some very sophisticated solutions. There is plenty of material on the web that you would be able to have lessons and learn.

Which solution did I use previously and why did I switch?

We have worked a lot with Tableau previously.

How was the initial setup?

We deploy the solution on-premises because we are developers, the customer is the one who has it on the Cloud. We helped them with the on-premises deployment and then we install the software and we deployed our solutions made on-premises. We complete any changes that need to be done in order to work in the customer's landscape.

The time of the deployment depends on the solution the customer requires. If it's a small solution, typically it will take approximately two weeks. A medium solution, that takes from two weeks to eight weeks.  However, it depends on what you are trying to accomplish with the solution. If you are trying to do a very complex data warehouse, it's not the tool that times the most time, it's the analysis and design that takes the most time for deployment. Once that you have the analysis, design, and you transport them to Snowflake this is not difficult.

In any BI solution, you have a lot of changes because of what you need to do with the end-users, there are a lot of changes to the end-user. This can also take up some time for the deployment for the first time. It can take two to six weeks for a medium-sized project.

What about the implementation team?

On average a small project can take three people. That's in small BI projects, in some customers that we have the project takes a maximum of six weeks in order to have all the data fields. This is not for a whole data warehouse but for sales and customers. Those are all small to medium-sized projects, that require three people maximum for deployment. You might always want to have in addition, an analyst and the senior architect. 

Most of our team are technicians.

What other advice do I have?

Snowflake has a lot of capabilities and performance. However, the tool is not a silver bullet and can do everything. If you designed what you need according to the tool, then everything is going to be okay.

This is true for any tool. Many people start the projects without validating what they are going to expect to have at the end, they receive a big surprise. They were thinking that the tool has this capability and it doesn't have it or perhaps it has the capability but the design you have does not work correctly.

If you see the percentage of projects in the different customers in many places, such as in Mexico, Florida, and Miami. Snowflake is a tool that is currently being used but has not been in the past. There is not a lot of history.

I rate Snowflake a six out of ten.

We have not used Snowflake long enough to better rate it. If we had a lot more formal education or had more information or reference manuals our experience would be better.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Consultant
PeerSpot user
reviewer1488372 - PeerSpot reviewer
Associate Manager at a consultancy with 501-1,000 employees
Real User
A secure and fast solution with inbound and outbound share features and good integrations
Pros and Cons
  • "Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
  • "I am still in the learning stage. It has good security, but it can always be more secure."

What is our primary use case?

We are using it for our security products. We have a trial account, and we are using the trial database and practicing on top of it. We have the latest version of this solution.

What is most valuable?

Its performance is a big advantage. When you run a query, its performance is very good.

The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. 

It has good security, and we can easily integrate it. We can connect it with multiple source systems.

What needs improvement?

I am still in the learning stage. It has good security, but it can always be more secure. 

For how long have I used the solution?

I have been using this solution for a few months. I am in the learning stage.

What do I think about the stability of the solution?

It is stable. Its performance is very good.

What do I think about the scalability of the solution?

It is scalable. We have four users who are using Snowflake. 

How are customer service and technical support?

We are going through the online version, and we don't find any difficulty with this.

Which solution did I use previously and why did I switch?

I also use Azure. Snowflake has more advantages than Azure.

How was the initial setup?

There is no installation as such. After you register with Snowflake, you get a demo database, which you can configure and use. It only takes around 30 minutes. 

What about the implementation team?

I did it myself.

What's my experience with pricing, setup cost, and licensing?

Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license.

What other advice do I have?

I would recommend this solution to others. We plan to keep using it. 

I would rate Snowflake a nine out of ten.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Information Management Architect at Raken
Real User
I like how quickly the solution can be implemented
Pros and Cons
  • "The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
  • "It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."

What is our primary use case?

We are a consulting company so our primary use depends on the niche that we are providing the services to and on which of the different versions they have. I think we are mainly using Snowflake Enterprise.

In general, it is being used for integrating information. Snowflake is a database platform, it gives information to support analytic needs, such as advanced data analytics like machine learning. In some of those cases it is also used for descriptive analytics, for instance BI.

How has it helped my organization?

One of example of how Snowflake has improved a client's organization is the democratization, it makes information available to more of the users.

What is most valuable?

The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also.

What needs improvement?

I think that the area of improvement with Snowflake is to improve the administration. It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud.

I also heard from a company we work for that it could be more user-friendly because it provides some tools but they are not user-friendly.

Additionally, it would be very helpful if Snowflake integrated machine learning and some other advanced analytics features within their language or product capabilities. Right now, they do it through some other company where you have to buy these capabilities from other vendors. There are some customers that don't have complex needs for machine learning or advanced analytics so they don't have to buy it from another vendor but can use it from the product itself if they have it.

For how long have I used the solution?

The whole company has been using Snowflake for about three years.

What do I think about the stability of the solution?

In terms of stability, so far it is very stable.

What do I think about the scalability of the solution?

Snowflake is very scalable. Our client companies where we implement Snowflake are medium to large sized. These companies have offices in different parts of the world, not just some regions, but companies with office users in different parts of the world. We are dealing with international companies. Their tendency is to increase the use of the Snowflake platform. It would serve all the analytical needs in these companies.

How are customer service and technical support?

I have not directly experienced the technical support. It's not part of my job to be involved on those kind of issues, but we constantly receive information as a partner from them and we are very in good touch with them and with the people we are working with, meaning the representatives that are within the Latin American market, which is where I work. They are very open and very fast with communication.

How was the initial setup?

The initial setup is easy. Full deployment takes a few weeks. The initial deployment for the first initiatives might take weeks. It's not complex, really. You may have it loaded after a full day and already providing results or interacting, but there are some other companies that have to be implemented to extract and consume the information from the database. But it's very easy.

Which other solutions did I evaluate?

There have been a couple of other solutions that we've been participating in the evaluation process of and some others that have been included in the decision process, including Redshift from AWS and also Azure Synapse from Microsoft.

For instance, AWS Redshift looked like it was easier to implement and to be adopted by the technical users, the programmers and database programmers. So far it has been far easier to adapt this technology. I'm not saying that AWS is a better technology. It's very complex, but at least what I've seen is that for them, it looks like it's been easier to use the first time.

We liked that Snowflake is able to be used as a multi-Cloud service - it can be used in AWS Cloud, Azure Cloud, or Google Cloud. Whereas AWS, or even Synapse, can only be used in their corresponding networks.

What other advice do I have?

I would definitely recommend Snowflake.

On a scale of one to ten, I would give Snowflake an eight.

I give it an eight out of 10 due to its room for improvement in the user interface for the monitoring of the credit consumption and that the user experience is not friendly. And also because the machine learning is lacking some advanced analytic features.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2024
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros sharing their opinions.