Try our new research platform with insights from 80,000+ expert users
it_user1174809 - PeerSpot reviewer
Business Intelligence Consultant at a tech services company with 201-500 employees
Consultant
A flexible solution with good clustering, and the pay-per-use feature is useful
Pros and Cons
  • "The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications."
  • "Support needs improvement, as it can take several days before you get some initial support."

What is our primary use case?

We are an IT Analytic Consulting company and we work with many different products. We have Snowflake and a Snowflake account mainly for education purposes and our internal training.

We connected it to different sources, mainly internal sources. Most of them are on-premises and some are on the cloud.

The deployment model is public.

What is most valuable?

The most valuable features are: 

The multi-clustering: being able to access stored data without contention.

Virtual Warehouse (VW) sizing: Change the size of your VW on demand. 

Zero copy clone: Easy to create development and test environments.

What needs improvement?

I would like to have a tool where you can easily see the price because they need clarity of pricing.

Support needs improvement, as it can take several days before you get some initial support.

Integration could be the key to provide an optimal solution.

In the near future, I would like to see a built-in basic analytics solution that can be embedded for testing purposes, so you can see data not only in tables but also in a graphical way in order to better prepare data for analytics.

Embedded analytics would be nice.

For how long have I used the solution?

I have been using this solution for four months.
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 scenarios that we are using are not complex. For what we are using it's pretty stable.

What do I think about the scalability of the solution?

With a different cloud that warehouses are the standard for now but the scalability is pretty straightforward.

How are customer service and support?

In terms of support, it can take some time as there are not many people to provide support. Compared to other more stable providers it's a bit slower.

You have to wait several days to get support.

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

Snowflake is not the only solution we are working with but it is the only solution that we are heavily focusing on and investing our efforts into the knowledge and the training.

How was the initial setup?

The initial setup can be complex at the beginning but once you get into it, it can be straightforward.

When you come from an on-premises solution and you have to change or shift to the cloud, it works very differently. Once you know the differences then it is straightforward.

What about the implementation team?

We did not implement this solution through a vendor, we did it ourselves.

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

Pricing can be confusing for customers. For example, if a customer is asking for an estimate of the price, it's hard to tell because it is not easy to measure.

Improvement on the pricing and how it is presented is needed.

What other advice do I have?

I would suggest being careful with selecting resources. Each customer case can be completely different and each can require different resources.

It's not only the database itself but also how you integrate it with the analytics and the resources. The estimation of the resources is something that you have to pay a lot of attention to when selecting the resources because sometimes you will need EPL or ELT integration, which requires a tool, as does analytics.

For an end to end solution, you have to include other products.

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
NitinKumar - PeerSpot reviewer
NitinKumarDirector of Enginnering at Sigmoid
Real User

Yeah, the pricing is something which I too felt can be more open and explicit for the customers.

reviewer1572522 - PeerSpot reviewer
ML Lead at a tech services company with 201-500 employees
Real User
Well-distributed with different data engines, great stability and scalability, and easy to deploy
Pros and Cons
  • "It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."
  • "The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."

What is our primary use case?

It was used in my previous company for a massive data warehouse. It was used for events and actions from other data sources. We had its latest version.

What is most valuable?

It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way.

What needs improvement?

The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. 

They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python.

For how long have I used the solution?

I worked on it a lot in the past 12 months in my previous company.

What do I think about the stability of the solution?

Its stability is absolutely great. There are no problems with its stability.

What do I think about the scalability of the solution?

It is scalable. There are no problems with the scalability of this solution. There were 50 or 60 users using it at the same time.

How are customer service and technical support?

I don't have much experience with their technical support. When we asked them some technical questions related to Spark integration, they were quite supportive. Their support was fine.

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

I have used BigQuery on Google Cloud Platform and Spark on an internal cloud.

How was the initial setup?

It was quite straightforward. There is no problem with that. However, managing the database and roles and access is complicated. Its deployment didn't take a long time.

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