No more typing reviews! Try our Samantha, our new voice AI agent.
DBA Individual Contributor at Aristeia Capital
Real User
Oct 6, 2020
Good performance, straightforward to set up, and there is flexibility in pricing
Pros and Cons
  • "It's ultra-fast at handling queries, which is what we find very convenient."
  • "My advice for anybody who is considering Snowflake is that it is a really good product, especially if you are having issues with Big Data."
  • "Snowflake has support for stored procedures, but it is not that powerful."

What is our primary use case?

Snowflake is used for very large data, such as in the case where tables might contain 600 to 700 million records.

What is most valuable?

It's ultra-fast at handling queries, which is what we find very convenient.

The pricing and licensing model is good.

What needs improvement?

Snowflake has support for stored procedures, but it is not that powerful. They have a lot of limitations. For example, it is really basic and there are limitations on subqueries.

The functions are not very good. Improving this would help to make sure data manipulation much easier. Right now, the inbuilt stored procedures and functions are all Java-based.

For how long have I used the solution?

I Have been using SnowFlake for about five months.

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

What do I think about the scalability of the solution?

We have approximately 10 people in the organization who are using Snowflake.

How are customer service and support?

The technical support is very good.

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

We use Snowflake in conjunction with Matillion, which is another AWS-based ETL tool. It is being used as a bridge between our on-premises data and Snowflake. 

How was the initial setup?

The initial setup is very straightforward. You simply log in and start using it.

When it comes to deployment, you can choose between the AWS and Azure cloud. We chose AWS.

What about the implementation team?

It is easy to create an instance and you can do it yourself if you have an AWS account. Snowflake will give you the connection ID and other relevant details.

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

The pricing is flexible in that, for example, if I run a query and it is slow then I can increase the processing power while it is still running, and they charge more for the time. The cost is on a per-query basis.

If you're running with a base processor, called a warehouse, the query might cost 1.0 cents. But, if my query is slow and I want to increase the speed, the next level adds a little more cost to that.

On average, with the number of queries that we run, we pay approximately $200 USD per month.

Which other solutions did I evaluate?

Recently, we have been doing a review of Redshift. However, we finally decided to go with Snowflake.

What other advice do I have?

My advice for anybody who is considering Snowflake is that it is a really good product, especially if you are having issues with Big Data. It is not good for a typical OLTP environment, such as a small table.

I would rate this solution an eight out of ten.

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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
General Manager at itcinfotech
MSP
Oct 5, 2020
Great interface tool which is really useful for our computation and storage needs
Pros and Cons
  • "Can be leveraged with respect to better performance, auto tuning and competition."
  • "I think this solution provides the best potential of any data warehousing product where they choose to use Snowflake instead of Oracle or DBII."
  • "Pricing is an issue for many customers."
  • "We've come to realize that for many customers, pricing of this solution is an issue."

What is our primary use case?

We work with multiple customers who were asking for this and other similar solutions. We've since had several team members certified in Snowflake and we have a certified team working with that solution and keeping up to date with developments. I'm the general manager of the company and we are implementers. 

What is most valuable?

Snowflake has its own features in comparison to other similar solutions like Exadata. This gives it huge competitive power. It has a very good interface tool with its own benefits and features which are really useful for our needs from a computation and storage perspective. I think this solution provides the best potential of any data warehousing product where they choose to use Snowflake instead of Oracle or DBII. The product can be leveraged with respect to better performance, auto tuning, competition and performance. From an architectural perspective, the solution has all the ingredients it requires. 

What needs improvement?

We've come to realize that for many customers, pricing of this solution is an issue. Maintaining Snowflake clusters is challenging and cost intensive. Reporting could also be improved. Any data that moves out of Snowflake is being cached. If I have 400 to 500 end users, with 100 or 200 reports on a daily basis, all the reports will be cached. It's a matter of ensuring that costs can be optimized. The combination of Red Warescape plus Snowflake is a combination from the design and development perspective. But the combination from the reporting perspective to micro strategy on top of Snowflake could be a better feature, so there's a combination that has to be considered.

For how long have I used the solution?

I've been using this solution for about 10 months. 

What do I think about the stability of the solution?

Our customers tell us that it is a stable solution. 

What do I think about the scalability of the solution?

We're working in 32 countries with enterprise size customers. We're still waiting to see what happens with that level of scalability and how the solution performs. If this product can be further fine-tuned or optimized in such a way that it becomes a very good fit for the Azure platform, that would be great. 

How are customer service and technical support?

They provide very good documentation on implementation design and development perspectives. 

How was the initial setup?

I think the initial setup is straightforward. Anyone who has worked on these types of solutions will pick it up quickly.

What other advice do I have?

It really depends on the nature of the implementation. If it's a small or medium sized company, we focus more on the pricing. If that can be brought down, I think Snowflake has a high potential that it can meet and can create a big name for itself in the big data cloud implementation platform. It has all the features. It already has all the complementary features to deal with the challenges. Those are built in and taken care of. It could be on Google cloud, or it could be on Azure or it could be on Amazon.

I'll rate this solution a nine 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. Implementer
PeerSpot user
Buyer's Guide
Snowflake
June 2026
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
902,894 professionals have used our research since 2012.
Senior Software Engineer at a financial services firm with 1,001-5,000 employees
Real User
Jul 29, 2020
Stable and capable of processing data in bulk but needs to have SLAs in place
Pros and Cons
  • "The solution is very stable."
  • "Technical support is very, very good."
  • "They don't have any SLAs in place. It would be better if they did."
  • "Users considering adding the solution should understand that Snowflake can be used only for transactional processing, not for analytical processing."

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.

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 technical 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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer2179353 - PeerSpot reviewer
Soullution Architech at a tech services company with 51-200 employees
Real User
May 10, 2023
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer2009835 - PeerSpot reviewer
Senior Solutions Architect at a tech consulting company with 201-500 employees
Real User
Top 10
Apr 20, 2023
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?

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer2124444 - PeerSpot reviewer
Solutions Architect at a recruiting/HR firm with 1-10 employees
Real User
Apr 4, 2023
Easy to query, provides accurate results
Pros and Cons
  • "Very easy to use and easy to query."
  • "The cost of the solution could be reduced."

What is our primary use case?

We use Snowflake as a data warehouse and analytics platform. I'm a solution architect and we are customers of Snowflake

What is most valuable?

It's very easy to use, easy to query, and it provides pretty accurate results. It's a market leader. 

What needs improvement?

The price could be reduced, it's quite high.  

For how long have I used the solution?

We've been using this solution for about three months. 

What do I think about the stability of the solution?

The solution is stable. 

What do I think about the scalability of the solution?

The solution is highly scalable. 

How are customer service and support?

I haven't used the technical support. 

How was the initial setup?

The initial setup is very easy, especially if you have cloud knowledge. We have around 150 users. 

Which other solutions did I evaluate?

We moved from Red Shift to Snowflake because of scalability and the independence it provided. 

What other advice do I have?

I rate this solution eight out of 10 and recommend it to other users. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Principal Director at a tech vendor with 10,001+ employees
Real User
Mar 17, 2023
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
Marketing Communications Manager at a financial services firm with 1,001-5,000 employees
Real User
Mar 12, 2023
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1292229 - PeerSpot reviewer
Big Data & Cloud Manager at a tech services company with 1,001-5,000 employees
Real User
Mar 20, 2022
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
HarishAjjarapu - PeerSpot reviewer
Associate Director at a tech services company with 10,001+ employees
Real User
Feb 2, 2022
Stable tool with a variety of useful, unique features
Pros and Cons
  • "The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
  • "Snowflake is easy for business users to implement, allowing them to start small and grow big."
  • "I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."

What is our primary use case?

I am a solutions architect for Snowflake.

What is most valuable?

The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful.

What needs improvement?

I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end-users. 

Improvement to the end-to-end process of loading data into Snowflake could be made as well.

What do I think about the stability of the solution?

The product is stable so far.

What do I think about the scalability of the solution?

The product is scalable enough.

How was the initial setup?

The initial setup is not complex.

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

I believe that pricing is reasonable for this solution.

What other advice do I have?

Snowflake is easy for business users to implement, allowing them to start small and grow big.

I think people are still debating on whether they should still continue with S3 and add Snowflake or, whether they should take away S3 and completely rely on Snowflake.

I would rate this solution 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: June 2026
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros sharing their opinions.