Try our new research platform with insights from 80,000+ expert users
reviewer1113963 - PeerSpot reviewer
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
Pros and Cons
  • "The initial setup is very simple."
  • "We would like to see more security including more masking and more encryption at the database level."

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.

Buyer's Guide
Snowflake
December 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,020 professionals have used our research since 2012.

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 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.
PeerSpot user
reviewer2179353 - PeerSpot reviewer
Soullution Architech at a tech services company with 51-200 employees
Real User
Top 5Leaderboard
Has good stability and processes the data efficiently
Pros and Cons
  • "The solution's customer service is good."
  • "Its transaction application needs improvement."

What is our primary use case?

We use the solution for data storage and integration purposes.

What is most valuable?

The solution's most valuable feature is path application.

What needs improvement?

They should improve the performance of the solution's transaction application.

What do I think about the stability of the solution?

It is a stable solution.

What do I think about the scalability of the solution?

We have 20-30 solution users in our organization.

How are customer service and support?

The solution's customer service is good.

How was the initial setup?

The solution's initial setup was very straightforward.

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

The price for the solution's license depends on the use cases.

What other advice do I have?

I recommend the solution to others and rate it as a nine. It efficiently processes the data and gets reports as well.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Snowflake
December 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,020 professionals have used our research since 2012.
reviewer2124444 - PeerSpot reviewer
Solutions Architect at a recruiting/HR firm with 1-10 employees
Real User
Top 10
Easy to query, provides accurate results
Pros and Cons
  • "Very easy to use and easy to query."
  • "The cost of the solution could be reduced."

What is our primary use case?

We use Snowflake as a data warehouse and analytics platform. I'm a solution architect and we are customers of Snowflake. 

What is most valuable?

It's very easy to use, easy to query, and it provides pretty accurate results. It's a market leader. 

What needs improvement?

The price could be reduced, it's quite high.  

For how long have I used the solution?

We've been using this solution for about three months. 

What do I think about the stability of the solution?

The solution is stable. 

What do I think about the scalability of the solution?

The solution is highly scalable. 

How are customer service and support?

I haven't used the technical support. 

How was the initial setup?

The initial setup is very easy, especially if you have cloud knowledge. We have around 150 users. 

Which other solutions did I evaluate?

We moved from Red Shift to Snowflake because of scalability and the independence it provided. 

What other advice do I have?

I rate this solution eight out of 10 and recommend it to other users. 

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.
PeerSpot user
reviewer1601793 - PeerSpot reviewer
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
Real User
Easy to use, flexible, and very stable
Pros and Cons
  • "The solution is very easy to use."
  • "The solution needs more connectors."

What is our primary use case?

The solution is primarily used as a data warehouse.

What is most valuable?

The solution is very easy to use.

The product is very stable and flexible. The performance is good.

The product is quite scalable.

What needs improvement?

The solution needs to offer more functionality related to machine learning and artificial intelligence.

The solution needs more connectors.

For how long have I used the solution?

I've been using the solution for close to two years.

What do I think about the stability of the solution?

The solution is very stable and extremely reliable. There are no bugs or glitches. It doesn't crash or freeze. The performance is very good.

What do I think about the scalability of the solution?

The scalability of the solution is very good. If a company needs to expand it, it can do so with ease.

We have about 100 people on the product currently.

How are customer service and technical support?

Technical support overall has been good. They are helpful and responsive. We have no complaints. 

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

I have some experience with Teradata.

How was the initial setup?

There is no installation process, as it is run as software as a service on the cloud.

For deployment, I would say two to five people would be enough. It depends on the size of the project and can have from one person to 20 people supporting it. It really depends on the implementation. The people would likely be admins, engineers, and managers.

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

The product requires the purchase of an annual license.

Which other solutions did I evaluate?

Before choosing this solution, we looked at SQL Server and Teradata.

What other advice do I have?

We're customers and end-users.

We're using the latest version of the solution. I can't speak to the exact version number.

I'd rate the solution at a nine out of ten. We've been mostly very happy with its capabilities.

I'd recommend the solution to other users and companies.

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.
PeerSpot user
reviewer1225515 - PeerSpot reviewer
Lead Data Analyst at a wholesaler/distributor with 1,001-5,000 employees
Real User
Feature-wise complete, good speed and performance, and easy to configure
Pros and Cons
  • "Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
  • "Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."

What is our primary use case?

It was only a workshop with training to know the tool. We were just testing the technology, and it was just a demo of the tool. We wanted is to connect switches with IoT and use Snowflake as an engine to process all the big data. It was on top of AWS, but our infrastructure is on top of the Google Cloud Platform.

The intention was to see if we can process on the front-end that we have. We have a console that processes a big amount of data. Instead of using BigQuery, we used Snowflake to see if it is cheaper than using BigQuery, but Snowflake wasn't cost-effective. In the end, we didn't go for this solution. We just saw how it can be implemented, but we never bought anything.

How has it helped my organization?

We don't have a metric, but I would say that the processing time was a key benefit and value-add. It provided on-time processing.

What is most valuable?

Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit.

What needs improvement?

Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution.

What do I think about the scalability of the solution?

Its scalability is great. We have data processing of one terabyte per month.

How was the initial setup?

It was not complex. Our implementation strategy was to put Snowflake on top of Google Cloud solutions instead of BigQuery, but BigQuery was better in price. So, BigQuery won in this case instead of Snowflake.

What about the implementation team?

We got the guidance directly from Snowflake. They have a technical expert for Latin America.

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

We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue. 

What other advice do I have?

My advice is to consider Snowflake when you have more customers. I wouldn't consider Snowflake until I have sufficient customers. 

Whether we will consider Snowflake in the future depends on how BigQuery behaves. If the cost of BigQuery starts increasing and becomes similar to Snowflake, we're going to switch. If not, we're going to remain with BigQuery. 

We might also consider other similar solutions, such as Yellowbrick, or switch to another cloud solution, such as Azure or AWS, depending on the price. Right now, we are paying about $2,000 per month. Our goal is to have the total cost of everything to be around $3,000 per month. It is more or less our goal for KPI kind of thing.

I would rate Snowflake an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Sr. Technical Architect - Business Intelligence / Data Warehouse at a computer software company with 1,001-5,000 employees
Real User
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
PeerSpot user
reviewer739716 - PeerSpot reviewer
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees
Real User
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.
PeerSpot user
Director - Data Analytics at Sunera Technologies
MSP
Great performance, good technical and community support, and resizable according to your needs
Pros and Cons
  • "Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
  • "There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."

What is our primary use case?

We are using it for a migration from on-prem to cloud.

What is most valuable?

Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake. 

What needs improvement?

There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it.

For how long have I used the solution?

It has been almost two years.

What do I think about the scalability of the solution?

A great feature of Snowflake is that you can resize your warehouse according to your needs. Whenever we are expecting a huge amount of data, we can scale it up. It does that automatically as well, which is the best thing. We don't have to worry about that, and there is also no need for a database administrator. We do not need any DBA for this.

How are customer service and technical support?

We have contacted them only for the basic setup. Most of the time, we were able to get the right solution at the right time. We got great support from them.

They're doing a pretty great job in providing all the information. They have a great community and great coverage, and there is a lot of information available over the internet.

How was the initial setup?

Its setup was quite straightforward. I did not find any complexity with that.

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

I am not much aware of the price, but based on what I have analyzed so far, its cost is reasonable as compared to on-prem data warehouse solutions. It provides a great deal for production.

What other advice do I have?

One of the concerns related to Snowflake is about longevity in terms of how long can we use Snowflake. It is a big question in the market. It is a new baby in the market, and we don't know for how long will it trend. It has some big competitors. Firebolt claims to be the number one in this area. They have much better features than Snowflake. I would not say that Snowflake is the best and in the right position at this point in time. Snowflake is good for the next year, but Firebolt is going to bring it down.

I would rate Snowflake an eight out of 10.

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.
PeerSpot user
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2024
Buyer's Guide
Download our free Snowflake Report and get advice and tips from experienced pros sharing their opinions.