What is our primary use case?
Our aim was to migrate everything from on-premise, so we just migrated as it is and then we had issues. Some use cases that were running on-premises were not installed. We just went through each case and then finalized the issues with some of the packages that were not working or some users that were not getting what they were expecting. We did deep analysis on each and every case and then looked for options in Snowflake and are now working with the team to move everything over to Snowflake.
What is most valuable?
The data warehouse is one of the great concepts of Snowflake. The coding plans are also a great feature. You can switch out the values or sizes.
What needs improvement?
It would be helpful if implementation could be handled more on the user-side. We need to train the users on best practices and how to use the solution properly. It's a cost issue. If they don't run it properly then it'll end up costing more money.
There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source.
For how long have I used the solution?
I've been using the solution for one year.
What do I think about the stability of the solution?
The solution is stable. We had only one failure, but that was because of AWS issues. Beyond that, I haven't seen anything else. From the Snowflake side, within 10 minutes they reported the AWS issue. It was under two hours of downtime because of the quick response.
What do I think about the scalability of the solution?
As long as you don't need to worry about storage or cost, this solution would be one of the best ones on the market for scalability purposes. We've migrated about 400-450 dealers onto the solution so far. We do intend to expand usage so there will be more users and more data. The drawbacks we've had with on-premises was space being a constraint and the user code having limitations.
How are customer service and technical support?
Customer support is good. There is always someone who's going to respond. They will let you know what can be done and what is possible.
How was the initial setup?
We did some testing and some comparisons, but it's all set up now and running fine. The deployment took about three months. Since we didn't want to disrupt the on-premises, or overload the system, we did most of the migrations on the weekend.
For maintenance, in the beginning, until you are through with training and performance tuning, you will need more people. You might need to start with seven or so, and then, for ongoing work, probably one or two people can manage it.
What about the implementation team?
We had a Snowflake consultant on-site that assisted us with the implementation.
What's my experience with pricing, setup cost, and licensing?
It's an expensive solution. We can't predict exactly how much until we've streamlined everything and the user requirements have been completed, but normally they charge on the storage, which depends upon the average storage amount used for the month.
Which other solutions did I evaluate?
We looked at IBM because it also has on-premise solutions. We also looked at Azure as well as AWS.
What other advice do I have?
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.
Which version of this solution are you currently using?