Try our new research platform with insights from 80,000+ expert users
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.

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

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 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
reviewer1225515 - PeerSpot reviewer
Lead Data Analyst at a wholesaler/distributor with 1,001-5,000 employees
Real User
Feature-wise complete, good speed and performance, and easy to configure
Pros and Cons
  • "Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
  • "Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."

What is our primary use case?

It was only a workshop with training to know the tool. We were just testing the technology, and it was just a demo of the tool. We wanted is to connect switches with IoT and use Snowflake as an engine to process all the big data. It was on top of AWS, but our infrastructure is on top of the Google Cloud Platform.

The intention was to see if we can process on the front-end that we have. We have a console that processes a big amount of data. Instead of using BigQuery, we used Snowflake to see if it is cheaper than using BigQuery, but Snowflake wasn't cost-effective. In the end, we didn't go for this solution. We just saw how it can be implemented, but we never bought anything.

How has it helped my organization?

We don't have a metric, but I would say that the processing time was a key benefit and value-add. It provided on-time processing.

What is most valuable?

Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit.

What needs improvement?

Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution.

What do I think about the scalability of the solution?

Its scalability is great. We have data processing of one terabyte per month.

How was the initial setup?

It was not complex. Our implementation strategy was to put Snowflake on top of Google Cloud solutions instead of BigQuery, but BigQuery was better in price. So, BigQuery won in this case instead of Snowflake.

What about the implementation team?

We got the guidance directly from Snowflake. They have a technical expert for Latin America.

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

We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue. 

What other advice do I have?

My advice is to consider Snowflake when you have more customers. I wouldn't consider Snowflake until I have sufficient customers. 

Whether we will consider Snowflake in the future depends on how BigQuery behaves. If the cost of BigQuery starts increasing and becomes similar to Snowflake, we're going to switch. If not, we're going to remain with BigQuery. 

We might also consider other similar solutions, such as Yellowbrick, or switch to another cloud solution, such as Azure or AWS, depending on the price. Right now, we are paying about $2,000 per month. Our goal is to have the total cost of everything to be around $3,000 per month. It is more or less our goal for KPI kind of thing.

I would rate Snowflake an eight 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?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Snowflake
March 2025
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
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
Marketing Communications Manager at a financial services firm with 1,001-5,000 employees
Real User
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
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
reviewer739716 - PeerSpot reviewer
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees
Real User
Simple installation, well designed, and reasonably priced
Pros and Cons
  • "All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
  • "There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."

What is our primary use case?

Snowflake is used in my organization for our data warehouse.

What is most valuable?

All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse. 

It has very nice features, such as snapshots, marketplace, and it is very easy to receive data-warehouse specifications.

What needs improvement?

There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful.

For how long have I used the solution?

I have been using Snowflake for approximately three years.

How was the initial setup?

The installation is very easy. What is needed is a good extract, transform, and load (ELT) tool and we used Matillion.

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

The price of the solution is reasonable.

What other advice do I have?

My advice to those wanting to implement Snowflake is it is easy. However, the way to choose to implement your data in the warehouse matters. When we started to implement our data with Snowflake, we also switched to a metadata-driven approach, but the method depends on the people involved in the implementation. Overall, the implementation of Snowflake follows similar principles as any other data-warehouse implementation except many aspects are a lot easier and helpful. 

I rate Snowflake an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Director - Data Analytics at Sunera Technologies
MSP
Great performance, good technical and community support, and resizable according to your needs
Pros and Cons
  • "Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
  • "There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."

What is our primary use case?

We are using it for a migration from on-prem to cloud.

What is most valuable?

Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake. 

What needs improvement?

There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it.

For how long have I used the solution?

It has been almost two years.

What do I think about the scalability of the solution?

A great feature of Snowflake is that you can resize your warehouse according to your needs. Whenever we are expecting a huge amount of data, we can scale it up. It does that automatically as well, which is the best thing. We don't have to worry about that, and there is also no need for a database administrator. We do not need any DBA for this.

How are customer service and technical support?

We have contacted them only for the basic setup. Most of the time, we were able to get the right solution at the right time. We got great support from them.

They're doing a pretty great job in providing all the information. They have a great community and great coverage, and there is a lot of information available over the internet.

How was the initial setup?

Its setup was quite straightforward. I did not find any complexity with that.

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

I am not much aware of the price, but based on what I have analyzed so far, its cost is reasonable as compared to on-prem data warehouse solutions. It provides a great deal for production.

What other advice do I have?

One of the concerns related to Snowflake is about longevity in terms of how long can we use Snowflake. It is a big question in the market. It is a new baby in the market, and we don't know for how long will it trend. It has some big competitors. Firebolt claims to be the number one in this area. They have much better features than Snowflake. I would not say that Snowflake is the best and in the right position at this point in time. Snowflake is good for the next year, but Firebolt is going to bring it down.

I would rate Snowflake 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
Senior Solutions Architect at NessPRO Italy
Real User
The syntax is advanced which reduces the time to write code
Pros and Cons
  • "The syntax is advanced which reduces the time to write code."
  • "They should improve the reporting tools."

What is our primary use case?

We use it for presentations to clients. 

What is most valuable?

The syntax is advanced which reduces the time to write code. 

What needs improvement?

They should improve the reporting tools. 

They could increase their bandwidth to connect to other ETL tools. 

For how long have I used the solution?

I have been using Snowflake for around six months. 

What do I think about the stability of the solution?

The stability is good. There is no performance downtime. 

What do I think about the scalability of the solution?

If there is a need for scaling the setup is not so good. 

How are customer service and technical support?

Their support is good. 

How was the initial setup?

The initial setup was not complex. We needed a dedicated person for the setup. Once we know the requirements, it's not that complex. It has straightforward parameters. 

What other advice do I have?

I would rate Snowflake an eight out of ten. 

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