Snowflake Reviews

Snowflake is used for data warehousing.

The most valuable features of Snowflake are its performance and power.

Snowflake could improve if they had an Operational Data Store(ODS) space.

I have been using Snowflake for approximately four years.

The stability of Snowflake is good.

The scalability of Snowflake is very good.

I have approximately six customers using this solution but in addition, I am directing more.

The technical support from Snowflake was poor previously, they have improved significantly.

Snowflake has an easy setup and it is quick.

There is a license needed to use this solution. There are a few licensing options available. They have a pay-as-you-go option, but it is recommended to pay upfront.

I would recommend this solution to others.

I rate Snowflake a nine out of ten.

It is used in my company as well as in my client's company. We are a system integrator, so naturally, we need to have the centers of excellence and competencies in Snowflake.

The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management.

It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure.

There are three things that came to my notice. I am not very sure whether they have already done it. The first one is very specific to the virtual data warehouse. Snowflake might want to offer industry-specific models for the data warehouse. Snowflake is a very strong product with credit. For a typical retail industry, such as the pharma industry, if it can get into the functional space as well, it will be a big shot in their arm.

The second thing is related to the migration from other data warehouses to Snowflake. They can make the migration a little bit more seamless and easy. It should be compatible, well-structured, and well-governed. Many enterprises have huge impetus and urgency to move to Snowflake from their existing data warehouse, so, naturally, this is an area that is critical.

The third thing is related to the capability of dealing with relational and dimensional structures. It is not that friendly with relational structures. Snowflake is more friendly with the dimensional structure or the data masks, which is characteristic of a Kimball model. It is very difficult to be savvy and friendly with both structures because these structures are different and address different kinds of needs. One is manipulation-heavy, and the other one is read-heavy or analysis-heavy. One is for heavy or frequent changes and amendments, and the other one is for frequent reads. One is flat, and the other one is distributed. There are fundamental differences between these two structures. If I were to consider Snowflake as a silver bullet, it should be equally savvy on both ends, which I don't think is the case. Maybe the product has grown and scaled up from where it was.

I have been using this solution for close to three years. I kept a tab on Snowflake and its progress since it came into the market.

Personally, I have worked extensively with Oracle, SQL Server, and Teradata. SQL Server has the Fast Track Data Warehouse (FTDW) appliance. Oracle has both the database and the appliance. I haven't worked on Parallel Data Warehouse, which is a big one offered by Oracle. Teradata is an appliance in itself. There is also Metadata. I haven't worked on DB2. 

All of these had their own lacunae. Data warehouses had their own problems. There were failures, challenges, and difficulties in adoption, and all of these have been addressed by Snowflake a big way. It has tried to marry the best of both worlds in terms of turnaround time, scalability, adoption, and seamlessness.

I hail from a classical data warehouse background. Snowflake has been kind of a silver bullet. It is trying to meet the best of both worlds. I wish I could do much more on Snowflake, but I'm tied up with many other things, which is why I'm not able to concentrate that much, but it is an exceptionally good technology.

Its initial setup is very simple, which is its plus point. It is not at all a problem. You only need to understand a bit of the cloud ecosystem. When Snowflake is on Azure or AWS, you need to understand

• What exactly is happening?
• How these two are handshaking with each other?
• What part Snowflake is playing?
• How Azure or AWS is complementing it?

If these things are clear, the rest shouldn't be a problem.

This could be something that might be debated upon, but Snowflake has two parts to it. One is the data warehouse itself, and the other one is the cloud. It is important to know about the cloud in terms of:

• How a cloud functions?
• How a cloud orchestrates through its services, domains, invocation of services, and other things?
• How a cloud is laid out?

For example, let's take AWS. If AWS is invoking Lambda or something else, how will S3 come into the picture? Is there a role of DynamoDB? If you're using DynamoDB, how would you use it in the Snowflake landscape? So, cloud nuances are involved when we speak of Snowflake, and there is no doubt about that, but a more important area on which Snowflake consultants need to focus on is the core data warehousing and BI principles. This is where I feel the genesis of Snowflake has happened. It is the data warehouse on the cloud, and it addresses the challenges that on-prem databases had in the past, such as scalability, turnaround times, reusability, adoption, and cost, but the genesis, principles, and tenets of data warehousing are still sacrosanct and hold good. Therefore, you need the knowledge or background of what a data warehouse is expected to be, be it any school of thought such as Inmon school, a Kimball school, or a mix. You should know:

• Data warehouse as a discipline.
• The reason why it was born.
• The expectations out of it in the past.
• The current expectations.
• What being on the cloud would solve?

These things on the data warehouse side need to be crystal clear. The cloud part is important, but it is of lesser essence than the data warehouse part. That's what I see, personally, and I guess that's the way the Snowflake founders have built the product.

As a data warehouse, I would rate Snowflake an eight out of ten.

Our current plan and use case for this solution is to migrate the data from on-premises to the cloud. We are currently using on-prem monitor data and providing it on the cloud. We are using Snowflake so that once the data is in there, we are trying to create shares over it so that external systems can't consume it.

The features I found most valuable with this solution are sharing options and built-in time zone conversion.

I see room for improvement when it comes to credit performance. The other thing I'd like to be improved is the warehouse facility. 

In the next release, I'd like to see easier connectivity to the on-premises tools.

I have been using this solution for about three years.

My impression from using this product for the last three years is that it is quite stable.

My impression is that this is a scalable solution. There are around 200 users of this solution at our company, including three administrators.

The initial setup process was not that complex and it took around six months.

The implementation was done by an in-house team.

My impression is that the pricing of this solution is reasonable.

I would rate this solution a seven, on a scale from one to 10, with one being the worst and 10 being the best.

My current client is migrating from an on-premise data warehouse to the cloud, and they need to consolidate the data lake. I'm using Snowflake to develop the data lake and build data bots for certain functionalities. I've also used Snowflake to aggregate and clean data for my client's analytics.

I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well.

There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure. 

I started using this product about two years ago at my last company. Now, I'm a registered Snowflake partner, so working with Snowflake for one of my clients.

My clients haven't faced many stability challenges. It is a relatively new product that's still evolving. They're using it mainly for POCs, so they haven't faced any problems. 

The most valuable aspect of Snowflake is its scalability. The volume of data, which I have seen across almost in terms of five terabytes and other terabytes of data, I didn't see issues.

Snowflake technical support is good. At my previous company, they had a customer success officer for critical accounts, and they were accessible. When I registered as a partner, I also got a quick response from support. I would rate their support eight out of 10.

Positive

Setting up Snowflake isn't complex. I've not seen any challenges.

They have different pricing structures based on data usage. I think they have three or four tiers you can scale through. Most of the clients see an advantage from this type of licensing. That's the reason they go for it. It's priced competitively with other solutions.

I rate Snowflake eight out of 10. 

I have been working on Redshift, Snowflake, and AWS RDS Oracle. In the particular case of RDS Oracle, they were migrating from on-prem Solaris equipment to cloud-based RDS.

I would suggest Snowflake for anyone with the need for a reporting/business analytics view of their data that wants only wishes to maintain technical FTE's around processing the data into or out of a data repository but, doesn't want to go to extent of technical management of "AWS clusters" for the data repository.

It was relatively easy to use, and it was easy for people to convert to it. Moved 168 tables and appropriate indices to Snowflake with minimum modification to Current Oracle DDL. The largest degree of change was setting up the corresponding access Hierarchy to duplicate what was in Oracle ( customer had separate permission structures for application vs Admin/support vs direct reporting access to the data).

The aspect of it that was more complicated was stored procedures. It does not support SQL language-based stored procedures. You have to write in JavaScript. If they supported SQL language and stored procedures, it would make migration from on-prem much simpler. In most cases, if an on-prem solution has stored procedures, they're usually written in SQL. They're not written as what most on-prem DBMS would refer to as an external stored procedure, which is what these feel like to most people because they're written in a language outside of SQL.

The other thing that people found difficult to deal with was that they had several Oracle DBAs who were very experienced DBAs, but they were used to on-prem. They were used to having the ability to turn any dial and flip any switch. Moving to Snowflake did cause some issues there because they had to completely readdress the fact that they couldn't touch the engine, and they had to spend more time analyzing performance.

I probably used it about six months ago. I haven't been working with a client who is currently on this platform.

I haven't had to call on them for a problem at that level.

It was a cakewalk. The biggest thing that's hard to do with it is that you have to do an analysis of performance over time to determine the scale because they separate compute and storage.

Scaling the query to a proper size compute is the larger aspect of the problem for most people. That's because you're looking at something completely different. The problem is that you're now trying to figure out what is the largest compute you need to keep performance where you want it without going too large. If you were in an on-prem scenario, you would tweak and twaddle all the dials. You might rewrite the query, but at the end of the day, you're still working inside the same physical acquisition or same physical resources, whereas in Snowflake, you're literally saying that you've got a 10 million row table as part of your query, but what is the necessary compute facility that you need to run queries that are running against that table.

It is hard to say because we're usually engaged in the transition as opposed to the long term. Their storage costs are easily within pennies of what AWS S3 would normally cost. 

Most of the clients I've been working with are in the financial sector, and they're relatively small. I would put them in an SMB connection. The first thing we have to bring up for people is that they're going to build this. They shouldn't store their data in S3. They should pipeline directly into Snowflake and use it on their storage. So, the cost is a big issue because these are small to medium size companies, and that is the biggest thing we had to price point for them.

The biggest conversion problem we've seen so far is when someone had a large number of stored procedures that were SQL-based, as opposed to external stored procedures written in C or whatever the DBMS would support. Converting those stored procedures either to a SQL script or to a stored procedure or function that's based on JavaScript is the biggest challenge that most people we've dealt with are having. That's because they have to relearn the language they're writing their logic in.

I would easily rate it an eight out of 10.

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

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.

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.

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.

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

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.

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.

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

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.

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.

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

I have evaluated Eclipse and IBM Netezza.

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

I rate Snowflake a nine out of ten.

I use this solution for actively building out the cloud data warehouse and data platform for enterprise level customers as well as startups. Generally, our clients are looking for a data warehouse on the cloud to enable them to scale infinitely at a lower cost. I've worked for a finance analytical team building their data lake, the data platform on top of Snowflake, as well as for a telehealth team. It's basically about getting data from multiple sources and building out an entire data platform with data governance. We are customers of Snowflake. 

One small company I worked with had a MySQL RTS based instance and were using AWS RDS with MySQL on top of that. As a result they were unable to scale their database because there were around half a million queries being run per second as well as data querying and data updating. The migration to Snowflake helped the company because there are no limitations in the cloud and no longer restrictions on the queries. Performance for end users improved whether they were internal or external clients. They used to sell the data through APIs so this migration helped to grow their business overall as well as the ML team efficiency and the productivity of users who previously used the data platform. 

The most valuable feature of Snowflake is the query performance. Snowflake is the most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer. There are a couple of areas where they have recently improved. One of the key features they introduced is an internal, table-based merch as well as storing of the unstructured data. You can now build a table out of unstructured data, metadata. This hasn't yet been officially announced.

Although the UI has improved lately, they still need to work on their UiPath, the workspace area.

I've been using this solution for two years. 

It's an infinitely scalable system, but if you use terabytes or petabytes of data, then you need to tune the levels. Each day, we get four to five gigs and overall, our data warehouse has 100 gigs plus, it's huge data. 

Our clients previously used the RTS based MySQL and migrated to Snowflake from there. The primary reasons they moved was because of scalability and performance. Other than that, Snowflake reduces costs quite significantly. I also have experience with BigQuery which is particularly used for Google Cloud although these days they have a multicloud enrollment. Snowflake is vendor independent so you don't have to stick everything in Google Cloud. In terms of performance, Snowflake is faster than BigQuery. 

The advantage of Snowflake is that it's easy to deploy and they take care of the setup. Basically, it's a cloud warehouse and doesn't need to be registered on any website. It's easy. It just requires dedicating space and registering. It shouldn't take more than a couple of days. 

Snowflake is reasonably priced, close to half the cost of some other solutions. 

In terms of performance the solution is good when compared to the analytical workloads and good in comparison to Redshift or BigQuery. The performance is on a slightly higher level, but when it comes to real-time performance, NoSQL is better than Snowflake, but that's in rare cases and depends on the particular requirement. Overall, for the analytical use case, Snowflake is a good solution and in terms of availability, it's a cloud data warehouse, so  they do replication and the like. 

It's important to understand your business needs, because these tools need to be properly modeled and they have their own advantages. If you're new to Snowflake, it's worth starting slowly for one month and move gradually, because if it's a complex system and you move everything to Snowflake without good architecture, then you can get stuck with the original problem. It's worth taking the time to make it efficient and then design modeling; there are SnowPro certifications as well. 

I rate this solution an eight out of 10. 

We needed a data warehouse and we made a decision on what is the right tool for us as a data warehousing tool by comparing products. We looked into Microsoft Azure, Red Shift and Snowflake. In the end, we decided on Snowflake because it looks more up to date, it seemed much better purposed as a data cloud solution.

It was developed from scratch and dedicated to being used on the cloud and that was what we were looking for. It was not just an on-premises system which was then converted to use on the cloud. It was completely developed from scratch and purely focus on the cloud.

Because it was programmed with that dedication, it has some significant advantages.

The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.

It has something like a time machine, as it is from Apple it incorporates that feature in a way similar to their operating system. So whenever you need a version of the data to test with, you can just go back and take a copy of what was backed up yesterday. It makes some things very easy. It backs up your data warehouses, so for example in our case, a colleague deleted a complete database and we just need to do an undrop on the database and the data was there again.

This helps you to have a development environment with current data. You can just clone your production environment and you have a development environment. Everything you do you can test it on real production data without destroying the production data itself.

These are significant advantages.

The company is constantly working to improve the product. Now they have a focus on data sharing, which is really great. We already share data with others who do not have Snowflake. That alone is already great. But if the other counterparts also have Snowflake, then it is extremely easy to share data. You can control access at low levels and even on the cell level. It is very secure.

With the improvements they continue to make, there is nothing now that I would say I miss or features that need to be added. Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.

We have been using this product for two years.

The product is very stable. We never had an issue with stability. It is reliable and it is extremely fast. For example, we had a stock procedure that took half an hour to complete on our SQL cluster, and in Snowflake it was running in two minutes. So that is a significant time savings for just one task.

The number of people at our company currently using the solution depends on what we are trying to accomplish. We have four developers in Snowflake and then we also have users who are leaving data with us for our further analysis. That may be around ten other users.

With the growing data set we have and the increase in the size of our business, we will increase the use of Snowflake, but not with respect to the number of users. We are a small company and all the users who need to use it are already using it. We have more data that we need to load and which we want to integrate before we will make more usage of Snowflake.

There is nothing for us to complain about when it comes to technical support. The response time is really great. Whenever we have an issue there is some delay because they are in San Francisco in the United States so there is a time difference. But when we raise an issue, we get answers immediately. We may not get the solution immediately, as that is not always possible. But we get some type of immediate response and days later we have a solution. The tech support is quite responsive.

We use several products together for our framework. We have our data warehouse which is in Snowflake, we use Domo for standard reporting and we use R for data science analysis.

Before we had Snowflake we had a different solution. We switched to Snowflake because we felt the need to modernize our data warehouse architecture. We were also thinking about having other solutions in the cloud to reduce administration costs. With no effort on our part, we could have a stronger system compared to the effort and cost of doing a similar thing on-premises. This was the biggest advantage of Snowflake. We really do not need to have those administrative efforts anymore. Now we don't take care about when we run out of storage or that we need to buy better CPUs because if we need more computing power, we don't worry about it, we just use it and it is there.

The setup for the product was straightforward. For us, it was a little bit of a challenge because when we implemented the data warehouse, we also changed the architectural concept and we implemented a better framework. Because this framework was new to us it complicated our installation. But Snowflake itself, if you want to use and you have a data warehouse already in place with the right framework, then it is straightforward. You just store your data in and that's it. What you use on top is material for orchestrating all the load jobs. But this is other integrations and other choices that are really outside Snowflake itself.

The initial deployment from purchase until it was up and running in production took two months.

We had a consulting company help us for the initial two months of the setup and then afterward we did everything by ourselves. We were quite satisfied working with the consultants and they helped us to implement quickly. We mainly needed them because we implemented this metadata framework. In the beginning, we had this consultancy for analyzing our platform, which to select and which tools should be used. After we completed this initial portion of the project over the two months, we needed them mainly for completing the implementation of the metadata framework.

Snowflake itself is easy to learn. If you know SQL it is really not very hard. Everything is well documented and it is not a problem.

The whole licensing system is based on credit points. That means you commit to using it and you pay for what you use. You can also make a license agreement with the company so that you buy credit points and then you use them. So if you buy credit points that you think will last you for a year, you pay a certain amount of money and then you have these credit points available. What you do not use in one year can be carried over to the next year and it is that easy. The advantage of buying more is that you get a discount when you buy a bigger package with more credits.

There is not really much advice I can give people considering this solution except that they should use it and enjoy it. It really sounds simple but that is it. Of course, you need to be careful with the usage of your credit points. Because there are so many possibilities in configuring the way you build your data warehouse or infrastructure, the data warehouse might seem logical, but it is not the best with respect to using credit points. You need to be careful about this. It probably takes half-a-year experience and then you will know how to do it. If you don't know what you are doing, Snowflake also helps to optimize your usage so that you do don't use too many credits points. After one year, we realized we had spent a huge number of credit points and we talked to Snowfake and then they came to us and we analyzed our systems together and we optimized the usage.

On a scale from one to ten where ten is the best, I would rate Snowflake as at least nine. Why not a ten is only because maybe there is something better on the market which is a ten that I don't know about. For me, it is already a ten.