Try our new research platform with insights from 80,000+ expert users
Senior Software Engineer at a financial services firm with 1,001-5,000 employees
Real User
Stable and capable of processing data in bulk but needs to have SLAs in place
Pros and Cons
  • "The solution is very stable."
  • "They don't have any SLAs in place. It would be better if they did."

What is our primary use case?

We primarily use the solution in order to have the daily transactions of trades. It's to manipulate and find out the benchmark of every broker and institutional manager.

What is most valuable?

The solution's most valuable aspect is the ability to process the bulk amount of data and try to clone the database. We try to clone the production database. Instead of syncing the whole database, we can just clone it up and start working on it. Basically, the cloning and the database are very user-friendly.

The solution is very stable.

What needs improvement?

Right now, Snowflake doesn't have any analytical functions, especially in comparison to Oracle and other databases. The analytical performance needs to improve. It would be ideal if Snowflake was able to use the analytical functions, and what we have in the relational database. That would be really helpful. 

They don't have any SLAs in place. It would be better if they did.

For how long have I used the solution?

I've been working with the solution for two years now. The company, however, has been using it for three years 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?

The solution is quite stable. It's reliable. It doesn't crash or freeze. There aren't bugs or glitches.

What do I think about the scalability of the solution?

The solution is definitely scalable. We're able to add nodes to grow it out when we need to. If an organization needs to expand the solution, they can do so easily. We find it to be very reliable.

There are about 300 people using the solution at this time. We don't plan on increasing usage at this time.

How are customer service and support?

Technical support is very, very good. It's a responsive and knowledgable team. We're quite satisfied with the level of service we receive.

That said, Snowflake technical support doesn't have any SLAs. If they had a small amount of SLAs, then it would be helpful for us to clear or solve any production issues, etc. that we may run into.

How was the initial setup?

We need about 50-60 people to maintain the solution.

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

Snowflake's pricing is a bit higher than other competitors.

Which other solutions did I evaluate?

We were looking at Amazon Redshift previously. However, we decided that Snowflake was more reliable and scalable.

What other advice do I have?

We're a customer. We don't have a business relationship with the solution.

Users considering adding the solution should understand that Snowflake can be used only for transactional processing, not for analytical processing. If they want to go for transaction processing, they can go for Snowflake and if they want to go for analytical processing, they should look at or go for an Oracle database.

I'd rate the solution seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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
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.
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.

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
reviewer1601793 - PeerSpot reviewer
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
Real User
Easy to use, flexible, and very stable
Pros and Cons
  • "The solution is very easy to use."
  • "The solution needs more connectors."

What is our primary use case?

The solution is primarily used as a data warehouse.

What is most valuable?

The solution is very easy to use.

The product is very stable and flexible. The performance is good.

The product is quite scalable.

What needs improvement?

The solution needs to offer more functionality related to machine learning and artificial intelligence.

The solution needs more connectors.

For how long have I used the solution?

I've been using the solution for close to two years.

What do I think about the stability of the solution?

The solution is very stable and extremely reliable. There are no bugs or glitches. It doesn't crash or freeze. The performance is very good.

What do I think about the scalability of the solution?

The scalability of the solution is very good. If a company needs to expand it, it can do so with ease.

We have about 100 people on the product currently.

How are customer service and technical support?

Technical support overall has been good. They are helpful and responsive. We have no complaints. 

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

I have some experience with Teradata.

How was the initial setup?

There is no installation process, as it is run as software as a service on the cloud.

For deployment, I would say two to five people would be enough. It depends on the size of the project and can have from one person to 20 people supporting it. It really depends on the implementation. The people would likely be admins, engineers, and managers.

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

The product requires the purchase of an annual license.

Which other solutions did I evaluate?

Before choosing this solution, we looked at SQL Server and Teradata.

What other advice do I have?

We're customers and end-users.

We're using the latest version of the solution. I can't speak to the exact version number.

I'd rate the solution at a nine out of ten. We've been mostly very happy with its capabilities.

I'd recommend the solution to other users and companies.

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
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
reviewer2179353 - PeerSpot reviewer
Soullution Architech at a tech services company with 51-200 employees
Real User
Top 5Leaderboard
Has good stability and processes the data efficiently
Pros and Cons
  • "The solution's customer service is good."
  • "Its transaction application needs improvement."

What is our primary use case?

We use the solution for data storage and integration purposes.

What is most valuable?

The solution's most valuable feature is path application.

What needs improvement?

They should improve the performance of the solution's transaction application.

What do I think about the stability of the solution?

It is a stable solution.

What do I think about the scalability of the solution?

We have 20-30 solution users in our organization.

How are customer service and support?

The solution's customer service is good.

How was the initial setup?

The solution's initial setup was very straightforward.

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

The price for the solution's license depends on the use cases.

What other advice do I have?

I recommend the solution to others and rate it as a nine. It efficiently processes the data and gets reports as well.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Sr. Technical Architect - Business Intelligence / Data Warehouse at a computer software company with 1,001-5,000 employees
Real User
A stable and scalable solution with very good memory management and easy installation
Pros and Cons
  • "Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
  • "For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."

What is our primary use case?

We use this solution for business intelligence. We have three persons in the team for developing the end product.

What is most valuable?

Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services.

What needs improvement?

For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file.

Its price should be improved. It should be cheaper than Microsoft.

For how long have I used the solution?

I have been using this solution for eight to ten months.

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 scalable.

How are customer service and technical support?

Their technical support is good. I always get a response from them when I send an email to their support team.

How was the initial setup?

It is very easy to install. After the installation, you just have to input some information into the Snowflake database. It is very easy.

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

Its price should be improved. It should be cheaper than Microsoft.

What other advice do I have?

I would recommend this solution. I would rate Snowflake an eight out of ten.

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: October 2024
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros sharing their opinions.