We just raised a $30M Series A: Read our story
RajeshBalasubramaniyan
Principal Technologist at a healthcare company with 10,001+ employees
Real User
Top 20
Good snapshot and rollback features and has good scaling options

Pros and Cons

  • "The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
  • "Availability is a problem."

What is our primary use case?

We use this product basically for developing an IoT (Internet of Things). Currently, we are sending data from our S3 (Simple Storage Service) storage. In the future, we are planning to directly stream data to Snowflake.

What is most valuable?

In terms of features, we have not yet explored the product completely. So we are still in the proof of concept phase. As of now, the product meets our preliminary requirements. The snapshot feature is good and the rollback feature is good. That is why we have the product and these are the key things we need.

What needs improvement?

The recovery process is very simple and very user-friendly as well. The constraint files could be improved. But the most important things are there. Also, the interface is good to work with and user-friendly.

If I had to say what needs improvement, in my experience is that the availability is a problem. Availability should be high and has to be enhanced.

I still have not explored all of the existing features. Because I have not been deeply involved with using the program it is hard to say what else is missing or what I would need.

For how long have I used the solution?

We have just explored the product for a few months.

What do I think about the stability of the solution?

The stability of Snowflake is very good.

What do I think about the scalability of the solution?

Scalability is very good and very simple.

Within the company, we currently have a total of fewer than 50 people using the product. Their general roles vary from data analyst to data scientist, to IT professionals, and maybe one or two of the upper managers.

How are customer service and technical support?

I tried using technical support once and they were very helpful. But after that, I have not had any reason to explore the support services.

How was the initial setup?

The initial setup was simple.

What about the implementation team?

The implementation was done by the vendor.

Which other solutions did I evaluate?

Before choosing to work with Snowflake we looked at virtual solutions and we looked at Redshift, we looked at Qubole and a couple of other cloud options. Earlier when we did a mining site, I was working with Alteryx, so I was already familiar with that product and its capabilities to use for comparison. We decided to go with Snowflake because it seemed mature and had what we wanted.

What other advice do I have?

My advice to someone who is looking at Snowflake is that if they are looking at analytics tools in addition to warehousing and certain advantages of cloud computing, then I would suggest Snowflake. But if they are just looking for the warehousing part where you will later just use another solution on top of it, then I would not suggest Snowflake.

On a scale from one to ten where one is the worst and ten is the best, I would rate Snowflake as an eight or nine. Let's say 8.5.

Which deployment model are you using for this solution?

Public Cloud

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

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Yaniv Meir
BI & BIG DATA Director at Malam-Team
Real User
Top 20
A good platform that can handle structured and semi-structured data and is very fast to implement and integrate

Pros and Cons

  • "It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
  • "In future releases, it can also support full unstructured data."

What is our primary use case?

We implement this solution for our customers. It is a cloud data warehouse. It is SaaS, and it can be run on Azure, AWS, or something else. We are using its latest version.

What is most valuable?

It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud.

It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it.

What needs improvement?

In future releases, it can also support full unstructured data.

For how long have I used the solution?

We have been using this solution for 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 has very good scalability. Your data can grow in the platform. We have at least 50 users of this solution in an organization.

How are customer service and technical support?

Their vendor is wonderful. I only have good words for them.

How was the initial setup?

It is not too complex. Its implementation is easy even for those people who don't know Snowflake and are coming from other environments, such as Oracle or SQL Server.

It can be implemented very quickly. Our customers in Israel implemented it very quickly. It was much faster to implement than other platforms.

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

It is on a monthly basis. It is based on your usage. There are no additional costs from the point of the licensing fee.

We do give some kind of evaluation to the customers about how much it is going to be. You can decide in Snowflake the virtual machine that you are using for customers. There are several kinds of virtual machines that you can use. It is similar to the clothing sizes: small to extra large. If you need more power in the coming month, you can decide in advance and take a more powerful machine. You can just select it from the platform. You can also decide which machine you want to take for extracting data.

What other advice do I have?

I would advise others to check themselves how fast its implementation can be and how responsive it is. I would also recommend evaluating it before choosing other solutions, such as Microsoft Synapse or Amazon Redshift. You can test it yourself by using a test case. You can try to load the data on each platform, which can take a few weeks, but you will get to know the advantages of this solution. It is very different from other solutions.

I would rate Snowflake a nine 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
Flag as inappropriate
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
543,424 professionals have used our research since 2012.
FG
Lead Data Analyst at a wholesaler/distributor with 1,001-5,000 employees
Real User
Top 20
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.
Flag as inappropriate
SS
Senior Software Engineer at a financial services firm with 1,001-5,000 employees
Real User
Top 5
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.

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: I am a real user, and this review is based on my own experience and opinions.
NP
DBA at a venture capital & private equity firm with 11-50 employees
Real User
Top 5Leaderboard
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."
  • "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.

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 technical 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: I am a real user, and this review is based on my own experience and opinions.
RAHULVERMASIR
Technical Architect at a computer software company with 501-1,000 employees
MSP
Top 20
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.
Flag as inappropriate
AH
CEO, Senior Consultant at a tech services company with 1-10 employees
Consultant
Sophisticated- cutting edge technology with zero clone copy and near zero maintenance

Pros and Cons

  • "Great scalability and near zero maintenance."
  • "Some SQL language functions could be included."

What is our primary use case?

The solution is mainly used for analytics in data warehouses. We are independent consultants and customers of Snowflake. 

What is most valuable?

The scalability of this product is great and the fact that it has a so-called zero clone copy and is near zero maintenance is also great. There are a lot of good features, it's a very sophisticated, cutting edge technology and is super easy to use. They are developing the platform very, very quickly so there are plenty of new features implemented all the time. You can concentrate on implementing things in Snowflake without tuning or configuring it.

What needs improvement?

There are some functions in the SQL language in other products which are not yet included in Snowflake's SQL. It would be helpful to have those included, they're nice features. It's a minor issue because all those things can be implemented in some other way. Not essential, but it would be nice to have them. 

For how long have I used the solution?

I've been using this solution for 18 months. 

What do I think about the stability of the solution?

This is a stable solution and the maintenance and updates are automatic. Snowflake is responsible for that.

How are customer service and technical support?

I have been quite satisfied with the technical support.

How was the initial setup?

The initial setup is very simple, just go to the internet and start using it. Of course, if it has to implement to part of the customer's own cloud infrastructure, then there are more steps to configure. We provide that service for our customers. 

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

Everything is included in the license fee which is mid-range in terms of pricing.

Which other solutions did I evaluate?

The advantage of Snowflake is that you can focus on implementing things in Snowflake without tuning or configuring it. That's the advantage of this solution compared to others. Many other data warehouse solutions need some kind of maintenance or database administration, and that takes time. The extra time means you're being taken away from other things and in that regard, Snowflake is an absolutely great product.

What other advice do I have?

I think the solution is suited to big companies because they tend to have lots of data. The more data you have, the more you need power and scalability to process it. I would recommend finding a good partner already familiar with the solution for implementation. It's good to have someone familiar with the architecture.

I rate this solution a 10 out of 10. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Consultant
Flag as inappropriate
JatinArora
Data Engineer at Celebal Technologies
Real User
Easy to scale, a simple initial setup, and good stability

Pros and Cons

  • "The initial setup is straightforward. You just need to follow the documentation."
  • "The solution could improve the user interface and add functionality to the system."

How has it helped my organization?

We mainly used SQL scripts and provided a solution for different owners who want to query a database but have several tables. Typically, it is not an easy task to read several tables, so we provided our client with a very crisp data model where they can get results in a very quick manner. We implemented distribution as well as weekly partitioning. 

What is most valuable?

The relational piece and how one dimension relates to another just by using a key is the solution's most valuable aspect. We are managing everything by using simple relations. It's all about the relationships between dimensions.

What needs improvement?

Right now, we need to write code, but if they could create a version of Snowflake that was more drag and drop for those managers that don't know how to code, it would be great for our business.

The solution could improve the user interface and add functionality to the system.

For how long have I used the solution?

I've used the solution for two years.

What do I think about the stability of the solution?

The solution is stable. We bring in incremental loads into Snowflake. There are pipelines that daily seed data from Oracle to a data warehouse. It's a prebuilt code and it allows for great stability.

What do I think about the scalability of the solution?

It's very easy to scale because Azure cloud's own data warehouse gives us that capabilities to scale up or down at any time we want. There are a great number of users on the solution, but it differs from client to client. One client, for example, has about 30,000 users.

How are customer service and technical support?

We've never been in touch with technical support.

How was the initial setup?

The initial setup is straightforward. You just need to follow the documentation.

What about the implementation team?

We handled the implementation ourselves. I've handled two or three projects previously, so I'm comfortable with the solution. We don't need assistance because we handle the consulting part.

What other advice do I have?

The solution is deployed on the cloud using Azure, where there's a data warehouse. We primarily use SQL scripts.

For those considering implementing, I'd advise that they understand the business very deeply first. Not every business would have a demand for Snowflake, so it's not for everyone. It's important to understand the requirements and then, if it makes sense, to implement Snowflake.

I'd rate the solution eight out of ten. I'd rate it higher if it had a better user interface.

Disclosure: I am a real user, and this review is based on my own experience and opinions.