We just raised a $30M Series A: Read our story
JC
General Manager of Data Science at a non-profit with 501-1,000 employees
Real User
Good data ingestion capability, scalable based on the requirement, and very stable

Pros and Cons

  • "The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
  • "They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."

What is most valuable?

The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently.

What needs improvement?

They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production.

They should also make its initial setup easier. Its customization and configuration are not very straightforward.

Their technical support is awesome, but it is just too expensive.

For how long have I used the solution?

I have been using this solution for about two years. I am currently using its latest version.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

It is very simple to scale up and down depending on the project or situation, which is an advantage.

How are customer service and technical support?

They are fantastic but just too expensive. They charge hourly rates and are very expensive.

How was the initial setup?

Its setup is not very straightforward. Its customization and configuration are not very straightforward. For two large data factories, the configuration is too complicated. They should work on it.

What other advice do I have?

It is a good solution. At the moment, I can't find another product that is better than Snowflake, but it needs better ETL functionality, easier configuration, and cheaper support. All products have got some limitation.

I would rate Snowflake an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
ST
Solutions Architect-AI & ML at a tech services company with 10,001+ employees
Real User
Top 20
Good performance and it is easy to write queries

Pros and Cons

  • "The querying speed is fast."
  • "We would like to have an on-premises deployment option that has the same features, including scalability."

What is our primary use case?

I work as a data scientist and our primary use of Snowflake is for machine learning.

Recently, we were trying to extract data to determine the best configuration settings for one of our products.

What is most valuable?

As it is SQL-like, it is easy to write queries.

The querying speed is fast.

What needs improvement?

We would like to have an on-premises deployment option that has the same features, including scalability.

For how long have I used the solution?

I have been working with Snowflake for six or seven months.

What do I think about the stability of the solution?

From what I have seen and heard, I think that Snowflake is pretty stable. I haven't faced any such problems, myself. I am not aware of the entirety of the lifecycle, but I haven't heard any complaints.

What do I think about the scalability of the solution?

My impression is that this product is pretty scalable.

How are customer service and technical support?

I have not been in contact with technical support, although my team has been and they are okay with it. My impression is that they are good.

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

The pricing for Snowflake is competitive.

What other advice do I have?

My advice for anybody who is considering implementing Snowflake is that from a user's standpoint, it is a good product. Having a database in a cloud setup means that you don't have to scale and it has got many features already included.

For our use case, we found this Snowflake was good enough and did not need any enhancements. I recommend using it.

I would rate this solution a ten out of ten.

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
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
543,424 professionals have used our research since 2012.
Anoop Anoop SLK
Enterprise architect at a computer software company with 201-500 employees
Real User
Top 5Leaderboard
Ease to use, highly secure, and flexible

Pros and Cons

  • "I have found the solution's most valuable features to be storage, flexibility, ease of use, and security."
  • "There is a need for improvements in the documentation, this would allow more people to switch over to this solution."

What is our primary use case?

We use the solution for data warehouses and data modeling.

What is most valuable?

I have found the solution's most valuable features to be storage, flexibility, ease of use, and security.

What needs improvement?

There is a need for improvements in the documentation, this would allow more people to switch over to this solution. I would like to see in the future a wizard for data modelization automation.

For how long have I used the solution?

We have been using this solution for approximately one year.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

I have found the solution to be scalable. We have a few employees working on this solution in my organization.

How was the initial setup?

The solution is a SaaS, it can be installed and managed by your provider. The installation setup is not difficult in this case. However, the configuration took us a couple of days.

What about the implementation team?

We did the configuration of the solution ourselves. You need a data engineer and modeler for the movement of information into the solution.

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

There is a licensing for this solution and we purchased an enterprise license. Overall the solution is cost-effective.

Which other solutions did I evaluate?

We did evaluate some other solutions previously, such as Snap Analytics. All the different solution have their pros and cons. However, many are moving to this solution because it is in the cloud.

What other advice do I have?

I would recommend this solution to others and we are going to keep using the solution in the future.

I 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.
Flag as inappropriate
Subhrajit Mitra
Sr. Technical Architect - Business Intelligence / Data Warehouse at a computer software company with 1,001-5,000 employees
Real User
Top 5
A stable and scalable solution with very good memory management and easy installation

Pros and Cons

  • "Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
  • "For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."

What is our primary use case?

We use this solution for business intelligence. We have three persons in the team for developing the end product.

What is most valuable?

Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services.

What needs improvement?

For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file.

Its price should be improved. It should be cheaper than Microsoft.

For how long have I used the solution?

I have been using this solution for eight to ten months.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

It is scalable.

How are customer service and technical support?

Their technical support is good. I always get a response from them when I send an email to their support team.

How was the initial setup?

It is very easy to install. After the installation, you just have to input some information into the Snowflake database. It is very easy.

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

Its price should be improved. It should be cheaper than Microsoft.

What other advice do I have?

I would recommend this solution. I would rate Snowflake an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
JH
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees
Real User
Top 5
Simple installation, well designed, and reasonably priced

Pros and Cons

  • "All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
  • "There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."

What is our primary use case?

Snowflake is used in my organization for our data warehouse.

What is most valuable?

All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse. 

It has very nice features, such as snapshots, marketplace, and it is very easy to receive data-warehouse specifications.

What needs improvement?

There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful.

For how long have I used the solution?

I have been using Snowflake for approximately three years.

How was the initial setup?

The installation is very easy. What is needed is a good extract, transform, and load (ELT) tool and we used Matillion.

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

The price of the solution is reasonable.

What other advice do I have?

My advice to those wanting to implement Snowflake is it is easy. However, the way to choose to implement your data in the warehouse matters. When we started to implement our data with Snowflake, we also switched to a metadata-driven approach, but the method depends on the people involved in the implementation. Overall, the implementation of Snowflake follows similar principles as any other data-warehouse implementation except many aspects are a lot easier and helpful. 

I rate Snowflake an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
MA
Senior Solutions Architect at NessPRO Italy
Real User
Top 5
The syntax is advanced which reduces the time to write code

What is our primary use case?

We use it for presentations to clients. 

What is most valuable?

The syntax is advanced which reduces the time to write code. 

What needs improvement?

They should improve the reporting tools.  They could increase their bandwidth to connect to other ETL tools. 

For how long have I used the solution?

I have been using Snowflake for around six months. 

What do I think about the stability of the solution?

The stability is good. There is no performance downtime. 

What do I think about the scalability of the solution?

If there is a need for scaling the setup is not so good. 

How are customer service and technical support?

Their support is good. 

How was the initial setup?

The initial setup was not complex. We needed a dedicated person…

What is our primary use case?

We use it for presentations to clients. 

What is most valuable?

The syntax is advanced which reduces the time to write code. 

What needs improvement?

They should improve the reporting tools. 

They could increase their bandwidth to connect to other ETL tools. 

For how long have I used the solution?

I have been using Snowflake for around six months. 

What do I think about the stability of the solution?

The stability is good. There is no performance downtime. 

What do I think about the scalability of the solution?

If there is a need for scaling the setup is not so good. 

How are customer service and technical support?

Their support is good. 

How was the initial setup?

The initial setup was not complex. We needed a dedicated person for the setup. Once we know the requirements, it's not that complex. It has straightforward parameters. 

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: My company has a business relationship with this vendor other than being a customer: Partner
DE
Data Architect and ETL Manager at a manufacturing company with 10,001+ employees
Real User
A stable data warehousing solution that is simple to set up and has good support

What is our primary use case?

We use Snowflake for data warehousing.

What needs improvement?

We would like to see more security including more masking and more encryption at the database level.

For how long have I used the solution?

We have been using Snowflake for three months.

What do I think about the stability of the solution?

Stability-wise, this product is good.

What do I think about the scalability of the solution?

Snowflake is quite scalable. We have four people who are using it.

How are customer service and technical support?

So far, technical support has been good.

How was the initial setup?

The initial setup is very simple.

What other advice do I have?

My advice for anybody who is implementing Snowflake is to start small, then prove out the value…

What is our primary use case?

We use Snowflake for data warehousing.

What needs improvement?

We would like to see more security including more masking and more encryption at the database level.

For how long have I used the solution?

We have been using Snowflake for three months.

What do I think about the stability of the solution?

Stability-wise, this product is good.

What do I think about the scalability of the solution?

Snowflake is quite scalable. We have four people who are using it.

How are customer service and technical support?

So far, technical support has been good.

How was the initial setup?

The initial setup is very simple.

What other advice do I have?

My advice for anybody who is implementing Snowflake is to start small, then prove out the value and you can grow.

I would rate this solution 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.
Yuval Klein
Pre-sale Leader, Big Data Enterprise Solutions at Ness Technologies
Real User
Top 5
In one second, you can take a snapshot of the database for test purposes

What is our primary use case?

The primary use case is big data warehouses.

How has it helped my organization?

Excellent performance Very easy to use Amazing UI

What is most valuable?

The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.

For how long have I used the solution?

One year.

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

Basically, it is not cheap.

What is our primary use case?

The primary use case is big data warehouses.

How has it helped my organization?

  • Excellent performance
  • Very easy to use
  • Amazing UI

What is most valuable?

The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.

For how long have I used the solution?

One year.

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

Basically, it is not cheap.

Disclosure: My company has a business relationship with this vendor other than being a customer: