2019-07-29T10:11:00Z

What advice do you have for others considering Snowflake?


If you were talking to someone whose organization is considering Snowflake, what would you say?

How would you rate it and why? Any other tips or advice?

Guest
99 Answers

author avatar
Top 5Real User

SnowFlake is useful to merge all kinds of data, no bother if you have heterogeneous or dispaired data sources. Try to check every requeriment to connect with the datawarehouses and be careful with the dederation and cost of resources.

2020-06-03T13:26:32Z
author avatar
Top 5LeaderboardReal User

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

2020-01-15T08:03:00Z
author avatar
Top 10Real User

This is an awesome tool, but there is room for improvement in terms of integration. Also, in terms of management, nothing is perfect and everything can be improved. I would rate this solution an eight out of ten.

2020-01-09T06:15:00Z
author avatar
Top 5Real User

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.

2019-12-30T06:00:00Z
author avatar
Top 10Real User

There is not really much advice I can give people considering this solution except that they should use it and enjoy it. It really sounds simple but that is it. Of course, you need to be careful with the usage of your credit points. Because there are so many possibilities in configuring the way you build your data warehouse or infrastructure, the data warehouse might seem logical, but it is not the best with respect to using credit points. You need to be careful about this. It probably takes half-a-year experience and then you will know how to do it. If you don't know what you are doing, Snowflake also helps to optimize your usage so that you do don't use too many credits points. After one year, we realized we had spent a huge number of credit points and we talked to Snowfake and then they came to us and we analyzed our systems together and we optimized the usage. On a scale from one to ten where ten is the best, I would rate Snowflake as at least nine. Why not a ten is only because maybe there is something better on the market which is a ten that I don't know about. For me, it is already a ten.

2019-12-12T07:48:00Z
author avatar
Top 10Real User

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.

2019-12-05T11:14:00Z
author avatar
Top 10LeaderboardReal User

We are system integrators, so for all our customers, we offer different solutions. We only use the cloud deployment model. Snowflake doesn't offer on-premises deployments. Snowflake on cloud is the best right now. There are only a few other options. Redshift is not scalable. With SQL Data Warehouse the concurrency is an issue, as well as scalability. Also, it does not have all the features that you see in an on-premises SQL Server. Snowflake a good database. I'd recommend the solution to others. I'd rate the solution seven out of ten. We are still new to the solution. There are a few things we still have to explore before we would give it 10. Typically, I come from a Hadoop background, so compared to Hadoop I think everything looks good before the data warehouse side. We're quite pleased with Snowflake and moving from Hadoop into Snowflake has been a very good transformation.

2019-10-21T17:16:00Z
author avatar
Top 20Consultant

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.

2019-10-06T16:38:00Z
author avatar
Top 20Real User

Because most of the issues you come across can be dealt with on the user's sites, it's important to educate the users and understand their requirements. The best advice I can give is to understand the product and to try to stick to what is required. From the business side, you need to monitor usage and monitor the space because of on-premises constraints. If it gets filled up then you will have to react. However, this solution is very scalable. I would rate this solution between seven and eight out of ten. The solution still has some constraints that need to be addressed.

2019-07-29T10:11:00Z
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,141 professionals have used our research since 2012.