Snowflake Reviews

I use this solution to create a proof of concept. I also create training for companies on Snowflake.

It is a very easy-to-use solution. It is user-friendly, and its setup time is very less.

They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better.

I started using Snowflake three months ago. 

It is stable.

It is scalable.

It is so easy that I didn't have to look for technical support. Its documentation is amazingly simple.

I also use Databricks for proof of concept and training. I have used Databricks much longer than Snowflake. Both have their own pros and cons.

In terms of ease of use, UI, and setup time, Snowflake is good. I would rate Snowflake a nine out of 10 from these aspects. In terms of workload, Databricks has higher points. The underlying infrastructure is faster for Databricks, which is not the case with Snowflake. Snowflake is a cloud database. So, in terms of processing power, Databricks has an advantage over Snowflake. Databricks is more suitable for larger workloads, whereas, for a regular or typical data warehouse that you want to run on the cloud, Snowflake is more suitable. 

Its setup was easy. You can create a connection and be up and running within half an hour.

I set it up myself.

I have not been billed yet, but it should be less. I'm still running the trial version, but it seems to be less than Databricks.

You must try it out. It is a wonderful product. I would also recommend trying out other products, such as Yellowbrick, and doing a comparison. Redshift has also come up with some serverless options. BigQuery is also there. BigQuery is as easy as Snowflake. So, my recommendation or advice is to try out these things and then pick the one that suits you. I don't have any bias towards any of the products. I have an impartial opinion about all the cloud data warehousing products.

I would rate it a nine out of 10.

We are also using Apigee we have various consumption patterns, data enrichment, and few shedding of the data, and everything goes into Snowflake. If it is multiple consumers, it goes into AMQ, Kafka, or multiple streams to consume. There are specific APIs that we offer after we send the data into the S3 bucket. We have Apigee APIs for consumption, and there are three to four different patterns. For example, we enrich the data, flatten it, and structure everything before the customers going to go into Snowflake. 

There are going to be specific clients who need specific data from the overall data lake, those are going to be exposed as APIs. We have multiple customers needing the same data and for this, we move them into the streaming Kafka.

Apigee does not communicate directly with Snowflake. We have data registration, and everything is coming into something that is called the trusted bucket. The  Apigee interface API is written off the S3 bucket. The S3 bucket data is moved into the Delta Lake, and where the data are stored from the Delta Lake, it sends it to Snowflake. We have Apigee going to Delta Lake and S3 bucket, but  Apigee does not go to Snowflake, these are two areas where it goes to. 

We have Kafka consuming directly off Delta Lake, and it sends data to Kafka through the AMQ. We have its setup, and we have interfaces that come directly to Snowflake to pull the data. It is then flattened and enriched, and it is used for many purposes, such as reporting.

Snowflake's most valuable features are data enrichment and flattening.

I have used Snowflake within the last 12 months.

The complexity of the initial setup of Snowflake depends on the use case. However, Snowflake itself, we don't set it up. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. There have been some challenges.

Snowflake has multiple implementations. For example, it can be implemented on Amazon AWS and on-premise. The data between these two cannot work together because they have different time zones. That's where the integration can be difficult because it is similar to them being on separate islands, they are completely separate. At some point, everything is going to go into the Amazon AWS Snowflake, but right now there are two islands that are completely different. We have to pull the data out and send it out again separately through a different pipeline.

In the future, this type of implementation should be easier. The integration could be better. 

I rate Snowflake an eight out of ten.

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 work with multiple customers who were asking for this and other similar solutions. We've since had several team members certified in Snowflake and we have a certified team working with that solution and keeping up to date with developments. I'm the general manager of the company and we are implementers. 

Snowflake has its own features in comparison to other similar solutions like Exadata. This gives it huge competitive power. It has a very good interface tool with its own benefits and features which are really useful for our needs from a computation and storage perspective. I think this solution provides the best potential of any data warehousing product where they choose to use Snowflake instead of Oracle or DBII. The product can be leveraged with respect to better performance, auto tuning, competition and performance. From an architectural perspective, the solution has all the ingredients it requires. 

We've come to realize that for many customers, pricing of this solution is an issue. Maintaining Snowflake clusters is challenging and cost intensive. Reporting could also be improved. Any data that moves out of Snowflake is being cached. If I have 400 to 500 end users, with 100 or 200 reports on a daily basis, all the reports will be cached. It's a matter of ensuring that costs can be optimized. The combination of Red Warescape plus Snowflake is a combination from the design and development perspective. But the combination from the reporting perspective to micro strategy on top of Snowflake could be a better feature, so there's a combination that has to be considered.

I've been using this solution for about 10 months. 

Our customers tell us that it is a stable solution. 

We're working in 32 countries with enterprise size customers. We're still waiting to see what happens with that level of scalability and how the solution performs. If this product can be further fine-tuned or optimized in such a way that it becomes a very good fit for the Azure platform, that would be great. 

They provide very good documentation on implementation design and development perspectives. 

I think the initial setup is straightforward. Anyone who has worked on these types of solutions will pick it up quickly.

It really depends on the nature of the implementation. If it's a small or medium sized company, we focus more on the pricing. If that can be brought down, I think Snowflake has a high potential that it can meet and can create a big name for itself in the big data cloud implementation platform. It has all the features. It already has all the complementary features to deal with the challenges. Those are built in and taken care of. It could be on Google cloud, or it could be on Azure or it could be on Amazon.

I'll rate this solution a nine out of 10. 

We use the product as a data warehouse.

The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool.

Snowflake needs to improve its programming part. Though the tool has Snowpath, it doesn’t support all features like its competitor, Databricks. Snowflake doesn’t support external data ingestion capabilities. You need to have third-party tools for that. Also, the tool needs to incorporate data integration features in its future releases.

I have been working with the solution for two years.

The solution is stable.

The product is scalable. You can scale the solution’s computation and storage features separately.

My company is a direct partner of the product. We have a lot of Snowflake experts who can resolve any doubts. Hence, I haven’t felt the need to contact customer service and support.

The solution’s setup is easy since it's a SaaS product. The tool’s deployment is fast and wouldn’t take more than two minutes.

Snowflake’s pricing is transparent. It is one of the cheapest cloud database warehouse providers. The tool follows a credit cost model. Everything on Snowflake is charged on the basis of credits. The credits depend on the cloud region and the public cloud provider that we use. Hence, the cost per credit will be different for AWS in Frankfurt and AWS in India. I think North Virginia is the cheapest region in terms of cost per credit. You will be consuming around 16 credits for large data warehouses.

I would rate the solution a nine out of ten. Snowflake is the market leader in data warehousing and cloud database. I don’t think that it has a direct competitor. I would suggest you give Snowflake a try if it fits your use case. You can open up a trial version for 45 days and convert it to a regular account. There are different tiers in the solution like business critical, standard, etc. The tool gets updates every week.

We use the solution to migrate data from old legacy ERP systems into Snowflake which reduces our work by 70 percent.

The solution is easy to use. We have third-party integrations, which make it easy to migrate from our landing to our warehouse. Inside Snowflake, we can convert what we create, unlike other hyperscalers.

The price could be improved. The more data we consume, the higher the cost becomes. Our licensing will also increase. How can we use our licensing system effectively? We have expertise and experience in different implementations, and we have control of our licensing. Therefore, there is an accelerator that allows us to control these effective methods of licensing.

I have been using the solution for three years.

We have had no issues with the stability.

I give the scalability an eight out of ten.

The initial setup is not complex.

The solution is costly, making it unsuitable for midsize organizations due to its price.

I give the cost of the solution a seven out of ten.

I give the solution an eight out of ten.

For organizations that do not wish to be confined to one type of hyperscalar, such as VM Azure, I recommend Snowflake as it provides greater flexibility.