IT Central Station is now PeerSpot: Here's why
Buyer's Guide
Data Warehouse
July 2022
Get our free report covering Oracle, Snowflake Computing, Microsoft, and other competitors of IBM Netezza Performance Server. Updated: July 2022.
619,967 professionals have used our research since 2012.

Read reviews of IBM Netezza Performance Server alternatives and competitors

Senior Snowflake Data Architect @ COOP Financials NC at a tech services company with 1,001-5,000 employees
Real User
High performance, useful features, and scales well
Pros and Cons
  • "The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
  • "The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."

What is our primary use case?

We use the solution for a data warehouse and we generating reports and dashboards.

How has it helped my organization?

Snowflake has improved my organization because of its high performance compared to the old way we used to operate with Microsoft SQL Server. We are migrating everything from SQL Server to Snowflake. It used to take a lot of time to query the database but now it is done a lot faster, we receive millions and billions of reports. This is a major benefit because it is our major use case.

What is most valuable?

The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed.

The solution is very easy to run the queries. We have a built-in query optimizer in Snowflake that works very well.

What needs improvement?

The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart.

There should be an IDE concept similar to the Java IDE or Eclipse feature. I should be able to see all of the functions available on a particular object. Every time we need to go to the Snowflake documentation and look if there are any methods we need. It is hard to remember everything, go and search, and use that that eventually found method. If it was possible to list out all the methods and functions available in an object that would help the developer's a lot.

In an upcoming release, we should be able to send or receive data from external systems but this is not able to be done. There should be built-in logging and monitoring features, we should not need to be dependant on third-party solutions, such as Splunk. There should be more DevOps features to reduce the usage of third-party tools. If these features were part of Snowflake it would be a fully functional complete solution.

For how long have I used the solution?

I have been using Snowflake for approximately two and a half years. 

What do I think about the stability of the solution?

They claim zero maintenance support and from my experience, I would agree with that statement. When I was on a previous project we had a lot of support for the Netezza platform we were using. We had approximately twelve people, three onsite and seven offshore. When we migrated from Netezza to Snowflake we reduced the number of people required and kept only some of the team as developers. There is very little support required for this solution. Stability is very good in SnowFlake.

What do I think about the scalability of the solution?

The scalability is built into this solution as being on the cloud. It is able to scale in all directions. Additionally, they have a multi-cluster warehouse, and based on the business use case it is very good.

There are approximately 4,000 portals. However, we do not know how many users our clients have that are using their portals.

We are building new data warehouses and we are migrating from SQL Server to Snowflake.

How are customer service and technical support?

The support is very good. We create tickets and they respond with a solution.

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

We were using SQL Server previously and we switched because of the increased performance, multi-clustered shared environment, scalability, and we wanted to use a cloud-based solution.

How was the initial setup?

Everything with the installation went smoothly. I believe when I joined the company Snowflake was already here. They bought the Business Edition that is encrypted everywhere because they are a financial insurance company and most of them choose the Business Edition because of the security.

What about the implementation team?

The company I work for used SnowFlake integrators for implementation assistance.

Which other solutions did I evaluate?

I have evaluated Eclipse and IBM Netezza.

What other advice do I have?

The solution is very easy and flexible to integrate with any type of API.

I rate Snowflake a nine 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.
Buyer's Guide
Data Warehouse
July 2022
Get our free report covering Oracle, Snowflake Computing, Microsoft, and other competitors of IBM Netezza Performance Server. Updated: July 2022.
619,967 professionals have used our research since 2012.