IT Central Station is now PeerSpot: Here's why
Buyer's Guide
Cloud Data Warehouse
August 2022
Get our free report covering Snowflake Computing, Microsoft, Microsoft, and other competitors of AWS Lake Formation. Updated: August 2022.
620,068 professionals have used our research since 2012.

Read reviews of AWS Lake Formation alternatives and competitors

Senior Vice President at a tech services company with 201-500 employees
MSP
Top 20
Good at autoscaling and has a nice time machine feature but they need to add a basic ETL framework
Pros and Cons
    • "It's difficult to know how to size everything correctly."

    What is our primary use case?

    We primarily use the solution for the data warehouse.

    What is most valuable?

    The solution offers everything you'd find on Azure or AWS. It has a lot of industry-standard features and capabilities.

    The product has excellent autoscaling. We can actually compute and scale-out at the same time without having to depend on other tools. You can do it on the fly, or within queries, etc.

    The Visual Copy Cloning is definitely one feature that everyone looks forward to due to the fact that it gives you regular backups. 

    The solution offers a very good time travel function that allows you to travel back in time to before your systems we corrupted. You can go back into your history and grab the last backup before corruption so that you regain almost everything you need. It gives you 90 days to fetch the data back if you need to. It's better than Azure options.

    What needs improvement?

    We've spoken with Snowflake about the fact that there are a few bare minimum requirements now these days for any data cloud, data lake, or platform. They've lacked a bit here, however, they're adopting some new measures that will be available in the next release, so that is sorted.

    Snowflake is partners with only AWS as a cloud platform. However, in India, Microsoft has got a big subscription. The product needs to be able to adapt to Azure a bit more in order to meet the local market demands. 

    It's difficult to know how to size everything correctly.

    They should incorporate at least a basic ETL framework.

    It's early days, however, I would put the solution at a seven out of ten. It needs a bit more time to mature. If I were to look at it strictly from a warehousing perspective, I'd rate it at an eight out of ten.

    For how long have I used the solution?

    I've been using the solution for about ten months. I started using it originally when we started our partnership with the organization.

    What do I think about the scalability of the solution?

    The one thing that seems to be unclear for Snowflake customers is the cluster sizing. No one seems ot know how to compute that.

    For example, if I'm running a warehouse that is extra small, as per my query performance, if I see like if this query will run perfectly on the machine I will have. However, I don't know which machine to go for. There's no direct comparison between an extra small, or a small, or a medium warehouse. I never get to know, unless I run the case query on different sizes, which to go for. It's hard to say "Buy only this and go for that particular size". Sizing seems to be a bit of trial and error. If they had some sort of benchmarking around their cluster size, that would be helpful.

    How was the initial setup?

    The initial setup is pretty straightforward. We didn't have any issues with implementation. It's not too complex.

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

    The pricing of the solution is fine. The storage is pretty cheap. They also offer a lot of discounts. The cost shouldn't really be a problem. 

    That said, the agreement should be more of a subscription basis instead of asking for a commitment. For example, Microsoft tells your the price and allows you to subscribe to that, whereas, Snowflake wants you to commit to a certain amount of time before they really give you firm pricing. 

    What other advice do I have?

    We're partners with Snowflake. We've been partners for just under a year at this point.

    I'd definitely recommend the product. It's worked quite well for us. 

    A new customer needs to understand, however, that they need a roadmap of at least five years when they are deciding on their data warehouse. They should compare costs and sizing to make sure they are getting the solution that makes sense for their current and future needs. 

    The solution integrates well with other applications, and if you need it to integrate with existing applications, you still should check to make sure it's possible.

    I wouldn't necessarily recommend Azure over Snowflake, as they aren't really a good comparison. Snowflake is more focused on data repositories and data warehouses. AWS does give you many options, however.

    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
    Alexis Bustamante - PeerSpot reviewer
    STI Data Leader at grupo gtd
    Real User
    Top 5
    Stable and user-friendly but technical support needs improvement
    Pros and Cons
    • "The useability, the user interface, is very user-friendly."
    • "The initial setup is complex."

    What is most valuable?

    The stability of the solution is pretty good. It's one of the solution's most valuable aspects.

    The useability, the user interface, is very user-friendly.

    What needs improvement?

    The solution needs to improve its integration capabilities. It needs better integration with SQL and other databases. 

    The initial setup is complex.

    The product needs to implement more machine learning and artificial intelligence.

    If they had more IoT and streaming capabilities, it would be helpful.

    The product could use more analytics tools.

    It would be helpful if we could use the product with less coding.

    What do I think about the stability of the solution?

    Normally, the solution is quite stable. The performance is pretty good. We don't regularly deal with issues. It doesn't crash or freeze, and I can't recall any bugs or glitches.

    What do I think about the scalability of the solution?

    The solution can scale, however, it is expensive to do so. If a company wants to expand, it will have to pay. Therefore, they should be prepared for that.

    Currently, we have about 200 people using the solution.

    How are customer service and technical support?

    I don't have a direct relationship with the technical support when I have a problem. They aren't very good. We aren't satisfied with the level of support we get.

    How was the initial setup?

    The initial setup is not too straightforward. It's rather complex. We had to get some outside assistance.

    The deployment process took us about three months. It was a while.

    What about the implementation team?

    We hired a consultant to help us with the implementation of the solution.

    What was our ROI?

    I don't have exact KPIs on this, however, I need to improve the sizing in order to improve our ROI.

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

    The is a monthly licensing fee. I can't speak to how much we actually pay, however.

    There is just one fee. You do not have any more costs over and above that.

    Which other solutions did I evaluate?

    While we didn't previously evaluate other options, in 2021, we need to explore the other solutions. I intend to look at the Amazon and Google Cloud platforms as other options.

    What other advice do I have?

    We are both partners and end-users of the product. We use it internally and we use it with some of our clients.

    I would caution new users that there is one parameter they need to watch carefully. That is the size of the data warehouse. If you don't configure this parameter to be as small as possible, your costs will be quite high.

    I would rate the solution at a seven out of ten. It's a stable platform, however, the price model is questionable in comparison to Amazon and Google and the contact with support is a problem for me. 

    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.
    Buyer's Guide
    Cloud Data Warehouse
    August 2022
    Get our free report covering Snowflake Computing, Microsoft, Microsoft, and other competitors of AWS Lake Formation. Updated: August 2022.
    620,068 professionals have used our research since 2012.