Snowflake Reviews

Our company uses the solution for building a data platform, data warehouse, and data transformation.

The product is somewhat used for data analytics, but it is mostly for data engineering.

The tool is good for handling large datasets, and since the tool is fully managed by Snowflake, you can scale up the compute part.

I don't think that the AI tools in Snowflake are good. AI tools in Snowflake can be improved. Even if the AI tools in Snowflake are good, I feel that it would be expensive. The cost of the AI part does not justify what you get from the product.

The price of the product can be lowered.

I think Snowflake should integrate with some tools like ChatGPT.

I have been using Snowflake for a year.

The product is scalable and can be considered a good fit for small and medium businesses.

I haven't directly contacted the technical support team of the product.

I have used Azure Databricks and Azure Data Factory. My company decided to use Snowflake since we wanted to be able to get up and running fast without much configuration-related mess. Snowflake doesn't give you the options with the configuration part since, by default, it is available out of the box. In terms of machine learning, Azure Databricks has the upper hand over other products.

The product's deployment phase was quite okay.

The solution can be deployed in a few days or up to a week.

The product's price range falls between average to a bit expensive range. I think the tool is worth the money if you use it properly. It is difficult for me to speak about the number of users who use the product. My company pays around a couple of thousand dollars a month to 10,000 dollars or more.

I think the main benefit is that with the tool, you can easily get things going without problems since you don't need to configure all the parameters manually. If you buy the tool for a bigger computing purpose, the engineer can pay more attention to the tool, and I guess after that, you can do more with the solution. I would ask others not to think about the data warehouses, as Snowflake takes care of such areas.

The benefits from the use of the product can be realized in around 40 minutes. It is a good technology for getting up and running quickly.

Snowflake is integrated with Azure Data Platform and other ETL tools in our company's ecosystem.

The integration capabilities of the product are good and you get what you pay for when it comes to Snowflake.

I rate the tool a seven to eight out of ten.

The primary use case is data platforms, specifically data warehousing. It involves restoring and moving data within the platform to prepare it for analysis, routing activities, or serving as the backbone for applications. 

Snowflake also advertises different workstreams, but my customers mostly use it as their core platform to ingest data and serve the onward goals of the wider company.

The most valuable feature of Snowflake is consumption-based costs, which means that you only pay for the storage and compute you use. There's a complete separation of storage and computing, so you don't need to add another server to increase storage or computing. From a costing perspective, it's well-positioned. 

Snowflake's time travel is also incredibly useful, and they have a function called "UNDROP," where you can undo a table drop. Data sharing and replication for Snowflake are strong, and they have a data marketplace with public and private data sets available for sharing. Companies can put their data on the marketplace, and anyone can use it by starting the payment model. The data is provided live straight to you, and it appears as if it were just another database in your own environment.

The main thing I'm excited to see at some point with Snowflake, hopefully - I've not seen anything coming out of it yet - is Git integration into the worksheets and the UI. Sometimes it can be tricky to manage multiple environments if you're purely using Snowflake as your scripting and pipeline environment. This is handleable, so if you use third-party tools like DBT, Matillion, etc., those can help. But if you're looking purely within Snowflake itself, it'd be great to have some form of Git support.

For the future releases, I would love it if they one day decided to implement their own GUI-based transformation tool environment. I know that many competitors like Azure have to Sign Up, and Azure Data Factory can sit in. However, Azure is a very different beast that serves all sorts of different processes, and an argument could be made for whether it's the best to each of those or not. Specifically within Snowflake, I would love it if they could get some form of orchestration built-in for transformation that doesn't have to be controlled directly through code all the time.

I have been using Snowflake for five years. 

It is an incredibly stable solution. It will only go down if your cloud provider itself goes down. So, let's say your Snowflake is hosted in Azure London. If the Azure London data center goes down, I would only see Snowflake going down. If that does happen, Snowflake does have plenty of options for failback replication and rollover backups. 

So we have quite a few customers that, for example, need their data restored in AWS London, and they've got a backup or a replication stored in Azure London. If AWS London goes down, then Azure London one will kick in and become the primary account, and all of the URLs, etcetera, remain the same because they've set up failover URLs and connections for it. At least for the end customer, there's no change. It's only for the architecture and developers behind the scene who then have to double-check things and do all the normal due diligence. But it runs very smoothly

It is a highly scalable solution. There is no limit on storage or computing. They have everything on consumption-based pricing, but you can have what's known as a multi-cluster warehouse. So, warehouses are what you use for the compute.

The multi-cluster warehouses will sit there originally as a single cluster. But then, if there are enough concurrent queries taking place in that warehouse, it can, as it needs, just spin up another one from another one and another one to meet those current needs. And as soon as they can dive down again, it can switch those clusters off again one by one. And you can create as many clusters, warehouses, as many as you need. There is no scaling issue at all. I've seen it most, like, 10,000 queries a second, and it's run very, very smoothly.

The customer service and support team is very useful and strong. They've got support built directly into the Snowflake UI. So wherever you are on the platform, and you see an issue, you can click into the support area and submit your ticket, including direct things like the query ID that you're using or multiple query IDs and all that stuff. 

I find Snowflake to be very responsive, and if you submit a top-level ticket, you can get a response very quickly. The lowest tier of tickets might take 48 hours sometimes, but overall, they are very helpful.

I personally don't see any of the competing cloud platforms coming close right now to what Snowflake offers. An argument could be made with GCP and Datadog are getting closer. Also, a new AWS Redshift is on the horizon, like a whole new AWS Redshift 2.0. But right now, I've not seen anything that comes close. Snowflake, to my understanding, is the only platform that fully separates your storage and computing, essentially. And it's the only platform I've seen with things like time travel. It's got a whole bunch of great features that I don't know if other tools also have, but it supports semi-structured data. It supports automated tasks, alerts, and reporting. And the data sharing is a massive one. GCP now also has its own data-sharing potential, where you can share data with other GCP accounts. I've not used it myself, but to my knowledge, whilst they have the sharing, they don't have anything that even comes close to the Snowflake data marketplace that allows customers to sell or share their data outside the wider world. And it doesn't have anything that comes close to the kind of private equipment where customers might share their own data internally or to their own. And I think there was one more thing. 

Snowflake also have some really good support for Python, Scalar, and Java through what they call Snowpark, which was launched last year. But more recently, this year, it was announced they're really pushing forward with their StreamLINK integration. It will allow customers to host applications on Snowflake and share those applications with other users in a very similar kind of marketplace environment they use for data sharing. I don't think there's anything that any of the other competitors have right now.

The deployment model is delivered as a service. So the most deployment you have to do yourself is by deciding which cloud provider and region you want it to be hosted in. But Snowflake will actually host it themselves, so there's no deployment beyond clicking from a dropdown and clicking okay, and it'll magically appear.

Moreover, it's very easy to maintain because it's delivered entirely as a service. Snowflake takes care of all the patches, upgrades, maintenance, security tweaks, etc.

We have many long-term customers who have been using Snowflake for years, and they wouldn't continue to use it if they weren't seeing a strong return on investment.

There are many options for starting a Snowflake deployment, but I recommend working with a partner who can provide best practices and guidance. It could be through Snowflake directly or another service partner. Working with a partner can save you time and prevent mistakes down the road.

Overall, I would rate the solution a ten out of ten. 

I am using Snowflake for migrating data and table backups.

The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data.

The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data.

I have been using Snowflake for approximately three years.

The stability of Snowflake is good.

Snowflake is a scalable solution.

We have approximately 200 to 300 people using the solution.

The initial setup of Snowflake is easy.

If the use case fits the solution then I would recommend it. For example, if you have large data and want the rational database backed up, this solution would be a good choice.

I rate Snowflake an eight out of ten.

In our organization, data is often spread out over multiple on-premise and cloud-based platforms. Snowflake is an agnostic platform, meaning it can be used regardless of which cloud provider we use and can serve as a single source for all of our data. Our use case then is to ensure that all data is located in one place, utilizing Snowflake as the platform.

With Snowflake, productivity can be increased. Snowflake is faster than on-premise systems and allows for variable compute power based on need. We are currently experimenting with ways to reduce processing time from eight hours to six hours or even less.

The vendor claims that the provision of warming sensors quickly enables warmth to compute nodes, which is their Unique Selling Point. From my experience, this has proven to be true.

For the past year and a half, I have experimented with different proof of concept. I have wanted to use Snowflake, however, I have not been able to do so. Microsoft Azure is superior to Snowflake in terms of its machine learning and artificial intelligence capabilities. Snowflake has its own unique products, but Azure surpasses it in those areas. Snowflake can improve its machine learning and AI capabilities.

I have been using the solution for one and a half years.

I found that Snowflake is highly stable, which is a reflection of the quality of its network.

I have gone to the extremes from a scalability perspective and I give Snowflake's scalability an eight out of ten.

As a premium customer for all these solutions, we have received excellent support overall with no issues encountered thus far. However, it is possible that some users of the free version may be experiencing some issues. I cannot confirm this, but from my experience, there have been no difficulties.

I give the initial setup a seven out of ten for ease and time required.

We are leveraging Snowflake, a cloud-based platform, both independently and in collaboration with the vendor. Our objectives for utilizing Snowflake are distinct from those of the vendor.

Comparing Snowflake to on-prem options such as Oracle or SAP, it seemed more cost-effective. With Vantage, a one-time purchase allows for use as many times and to a large capacity, whereas Snowflake, Azure, and similar services become increasingly expensive as the scale increases. Determining the best point of cost-effectiveness requires further study.

I have tested all the different alternatives to Snowflake as well. It is hard to determine which one is the most suitable, as each has its own advantages and disadvantages.

I give the solution an eight out of ten.

Deciding between Azure Synapse and Snowflake can be difficult, as the best choice depends on one's own use case. Ultimately, it comes down to the available connectors; the product with more connectors is likely the better option. When making a decision, one should consider which other sources they would want to get data from and where they want to send data to. This can help inform their product selection.

We're using it more for data warehousing and distribution.

Snowflake is a SaaS platform, so I'm using whatever is the latest version.

It's definitely for compute. The best use case of Snowflake is massive compute. With the parallel reads that we can do from Snowflake, we can combine data from disparate sources, consolidate it, and provide it to end clients through custom stored procedures.

It's user-friendly. It's SQL-driven. The fact that business can also go to this application and query because they know SQL is the biggest factor. So, we can provide all the data, and the analysts, data scientists, and product strategists can go and analyze the data themselves.

Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database.

I'd like them to look into the limitations of REST API. Snowflake came up with this native API concept, but it has got a lot of limitations. I'd like to see it provide better service-based APIs so that it can provide data as a service.

I've used Snowflake for over three years.

Its stability is fine, but of late, I get loads of messages saying there's some sort of outage or some sort of issue in the application. I keep getting these notifications from Snowflake, which gives a false impression that something wrong is happening, and it might be underlying in the backend. It doesn't seem that stable.

Its scalability is high. I'd rate it an eight out of ten in terms of scalability.

At this time, we have no plans to increase its usage.

Their support is good.

Prior to Snowflake, it was a completely Greenfield requirement.

It was very straightforward.

It required just two people. One from the Snowflake perspective, and one from my team members' perspective to get the configuration running. That's it.

We haven't yet seen a return on investment because some of the applications are yet to be fruitful and make revenue. We have used Snowflake for the past three years at this point, but we have not yet made great revenue.

It's expensive.

Snowflake is very useful as a data lake and as a data warehouse. Also, it has a lot of features with respect to data science. We are not there yet, but if there are any specific use cases around compute, data distribution, and data sharing, then Snowflake is a tool to be considered.

I'd rate Snowflake a seven out of ten.

Basically, if at all, we wanted to have an interface for data warehouses on the cloud which worked on Azure or AWS. Snowflake, provides a more intuitive, rapid user interface where people can connect and maintain warehouses and share data among the people in the companies easily. Its pricing model and the model have made maintaining virtual warehouses simpler.

I appreciate the Snowflake marketplace, where you can drop data and allow other people throughout the world to access it. You can go to the Snowflake marketplace and connect to some data. If somebody else publishes, for example, COVID-19 data or weather data, you can sign up for new data sets and bring them into your warehouse, which I found very interesting.

You can connect to different cloud sources, including Azure and AWS. 

You can report out, and all the cloud technologies have connected to Snowflake, allowing you to move the data or get the data into Snowflake. 

The initial setup was pretty simple. 

It scales really well. 

The solution is stable. 

The solution is reasonably priced. 

I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it.

Overall, they're doing great. I don't have any specific complaints or improvements that need to happen.

I've used the solution for a couple of years now. 

The solution is quite stable since everything is in the cloud, and the data these days has become cheap with storage and everything in the cloud. Through clusters and warehouses, sizes can be increased or decreased based on usage, and they can be turned on and turned off. Sustainability-wise, I think it's a pretty good solution.

It is scalable. The warehouses or auto-scaling features in the warehouses are great. You can go from small to medium to large all the way up to extra large, and there are different auto-scaling tasks that can happen. You can turn it on and turn it off based on the usage or auto-turn it on and turn it off. That's a pretty nice feature to have and we find it both sustainable and scalable for sure.

I work for clients, so last time when I worked for a client, there was a group of 100 people who were actually signed up to use Snowflake. 

I've never dealt with technical support. We did have people from Snowflake working with us directly, and we never ran into any issues that needed troubleshooting. The personnel from Snowflake, of course, would resolve whatever came up. 

I come from an Azure background as well, so Microsoft also comes with Azure Synapse, where it's a similar functionality as Snowflake, where it's warehousing on the cloud. Azure Synapse is also good. I'm unaware of AWS or GCP, and I heard that Google Cloud Platform also has Big Query and big data capabilities, which are tough competitors for Snowflake and other cloud warehousing tools.

The implementation process was pretty straightforward. I didn't set it up, though. I used an already set up version. I just had to connect. I had to push data from Azure to Snowflake, create tables there, and have data loaded into those tables, and that's it. I wasn't doing anything else, so I didn't work on the infrastructure of Snowflake.

You would need a group of two or three people to maintain the product.

I work for a consulting firm, so I don't work for the client, so I really don't know what the company used for deployment.

Licensing was based on the warehouse. I don't recall it being very expensive. 

I'm a consultant and end-user.

I'm not currently using the solution right now and do not recall the last version I was on. 

Now, I'm working for a different client on a different platform altogether. My company, as such, doesn't use Snowflake since we are in consulting. We have expertise in something, and then we help the clients deliver that solution on the technology.

Potential new users should just definitely give it a shot. They should start off with a POC, proof of concept, for the data that they have, and then, if everything works well and they can migrate in a cost-effective way. 

I would recommend Snowflake to start off with since it's just picking up over the last couple of years. If I have to recommend anything, however, it would be more Microsoft tools I would recommend since that all comes as a package. You can do Synapse and Azure Data Factory, which is  for ETL. You can also do Azure Data Lake Storage. There are different things that you can do when you buy something in a package like that. That said, I definitely recommend Snowflake if someone wants to give it a shot.

I'd rate the solution eight out of ten. 

We use this solution to ingest e-commerce advertising and web analytics data and completing an analysis. There are 60 people using this solution in our business. 

We are working with a TV advertising agency and they were able to set up a Snowflake data share to share ad spend with us and it was very quick to integrate.

The most valuable feature has been the Snowflake data sharing and dynamic data masking.

The cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic.

I have been using this solution for three years. 

This is a stable solution. 

This is a scalable solution. 

I would rate the technical support for this solution a four out of five. 

We previously used Amazon Redshift.

 The initial setup was straightforward.

We did have a consultant help us.

We do see a return on investment.

Pricing is based on usage. It is the most expensive of our data tools.

I would advise others to check costs when implementing any changes, such as new BI tools or a new data source. Set up different warehouses for your different tools so that you can track cost.

I would rate this solution a nine out of ten.

The primary use case is for building a database and data link.

I like the ability to work with a managed service on the cloud and that is easy to start with.

From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced.

I have been using Snowflake for three years now.

The stability is reliable and a standard product.

The scalability is very good and we have around two hundred data sets currently operating.

Technical support is good. It is readily available and they are very responsive.

Positive

The initial setup was straightforward.

You can do the implementation in-house since it is a managed service and only takes a few hours.

The pricing is economical as compared to traditional solutions like Oracle and competitive pricing.

I would rate Snowflake a nine out of ten.