Snowflake Review

Could use better integration, but very stable with an easy initial setup

What is our primary use case?

We primarily use the solution for data warehousing.

What is most valuable?

The entire managed service operations for the solution is great. Snowflake does everything for us. Whatever version they have, they implement the latest for us; we don't have to worry about any versions, any upgrades, anything else because they handle it.

What needs improvement?

The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template. 

The integration capabilities could be improved.

For how long have I used the solution?

I've been using the solution for six months.

What do I think about the stability of the solution?

The solution has been very stable for us.

What do I think about the scalability of the solution?

We have not tested scalability, but the solution claims that it's scalable. It's on the cloud, so I imagine you could scale rather easily if you needed to. 

They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises. 

We have about 40 people using the solution. They're mostly business users.

How are customer service and technical support?

Technical support is good. Occasionally, they take a bit of time to resolve issues, but other than that they are okay. We're mostly satisfied with them.

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

We're system integrators, so we use different solutions including SQL Server Data Warehouse and Greenplum as well as Snowflake at the moment.

I've used many data warehouse solutions, including Hadoop, and Oracle SQL Server Data warehouses. I switched from those to Snowflake because Snowflake is on the cloud and gives you separate computing and storage scalability, which Hadoop is unable to offer.

How was the initial setup?

The initial setup is straightforward. There's no deployment; it's just your code solution that needs to get up and running. You have a deal with Snowflake in terms of what environment you want, and when you want to use it, and they'll set it up within a day for you.

What about the implementation team?

Snowflake helped us with the implementation.

What other advice do I have?

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.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Snowflake reviews from users
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
457,459 professionals have used our research since 2012.
Add a Comment