Snowflake Reviews

We use Snowflake as a database to store all the data we stream from the source system.

The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power. If I want to change the computation with other tools like Netezza, I would have to add a hard disk to it. With Snowflake, being on the AWS side, changing warehouses provides me with faster execution of my queries.

The real-time streaming feature is limited with Snowflake and could be improved.

Currently, Snowflake doesn't support unstructured data. With Snowflake, you need to be very particular about the type of data in your source systems. It has to be in a proper structure. You cannot push data to Snowflake in any possible way.

I have been using Snowflake for a couple of years.

Snowflake is a stable solution.

Around 400 users are using the solution in our organization.

We previously used IBM Netezza. We switched to Snowflake in 2020 because it provided us control over its scalability and costing model.

The solution’s initial setup is comparatively easier.

Snowflake is a cloud-based, scalable solution that provides strong data security. Handling all the data is much easier in Snowflake, and it has a very nice interface to control user access. The administration of Snowflake is also comparatively easier.

Snowflake is a cost-effective solution.

Choosing Snowflake completely depends on the quantum of data your organization has and the requirements. Snowflake is suitable for someone looking for a scalable and cost-effective solution that provides quick analysis.

Overall, I rate Snowflake a nine out of ten.

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.

We are silver or gold partners. The main use case is that we are building a data lake. We are creating a couple of downstream applications as well that will be used by data scientists. So, we will have a single data lake that will be used across the organization by different business domain users. The data is multi-source. We have data from SAP, JDE, and some Excel files.

The speed of data loading and being able to quickly create the environment are most valuable. 

For data, it provides built-in security and compliance with different standards, such as SOC 2, ISO, etc. So, we don't have to do a separate audit for compliance.

There are some gray areas. For example, there is no clarity on where the data sits exactly. That is their proprietary information, and they are not sharing those details. 

Its price should be improved. On the cost-side, it is more expensive than others.

If they could bring in some tools for data integration, it would be really great.

I have been using this solution for almost two and a half years.

It is pretty stable. Its stability is excellent.

It is scalable. As of now, there are 500 users, but slowly, we are planning to roll out to multiple regions. It is currently in Europe, and we will be rolling it out to the APAC and USA regions. By the year-end, there will be more than 1,000 users.

They're perfect. They're excellent. It could be because we are partners.

It is straightforward. It is not that complex.

Our own team deploys it for customers, but the initial configuration is done only by the Snowflake team because that is their area. 

I have worked with multiple clouds, and cost-wise, it is a bit costlier than others, such as Redshift. Its price should be reduced.

I would rate it an eight out of 10.

We use it as a traditional data warehousing application that we then set all of our reporting tools on top of.

We are able to consolidate multiple databases into one unified table for more complete reporting. That wasn't possible in our legacy tool that we were using because the query time was just too long. Now we're able to create this unified view of our entire organization and refresh it every 15 minutes; using the power of Snowflake's query is pretty much our biggest use case there.

The query speed, and the way that it actually executes its queries is the most valuable aspect of the solution. We had some queries that would take hours upon hours to run, and the Snowflake returns the results in about 15 minutes.

It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well.

One area for improvement would be the stored procedures. Currently, their stored procedures can only be executed at a transactional level versus being able to run and do updates and run things in a sequence.

An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly.

I've been using Snowflake for about four years now.

The stability has been phenomenal up until lately. We haven't had any issues until the last month. For the four years prior it was always on; we didn't have any outages. All in all the stability is great. The availability is extremely high. There's just been something in the last month that has caused outages for some periods of hours.

It's definitely scalable. We're on a very small usage compared to some of the other clients I know Snowflake has, so it's definitely scalable because we have tons of room to grow for our use.

Including myself, we currently have five users and they're data analysts.

I've only used their customer service in one or two instances, and they were very supportive and helpful. The tool is so user-friendly and straightforward that I've never really had to engage their professional services.

We didn't really have a traditional data warehouse application. We were just using Microsoft SQL Server, but we didn't actually have a traditional MPP-based data warehouse solution. We were still a very growing organization. As we continue to grow our business and increase in size, we have to get better tools that are meant to actually do what we're trying to do with other tools.

The initial setup was pretty straightforward. The permissioning is a little more complicated than it needs to be. It would be nice if it just assumed permissions when you create new tables or new users, but you do have to go and actually permission to everything for individuals and people rather than when you create something. It's just because there's no default role that applies to new stuff created so it's a little more complicated than it should be.

Our deployment took about one month. I'm the only one involved in the maintenance of the solution now.

We hired an ETL specialist to come in and get us set up, but he really didn't understand our business and what we were trying to accomplish. So everything he did, we pretty much paid for and then redid ourselves. But it was pretty straightforward using tools that are built for ETL processes. Understanding the SnowSQL command line tool to a certain degree also helps.

We don't really have it commercialized or revenue-generating in any way, but what we've seen with it is we've been able to remove all of our reporting and other data needs off of production application. So we're not putting extra stress on things that we need to always have up and running in order to operate the business. That's really our security. It's more of a favorite blanket if you will, is where we're seeing the benefits.

For our licensing, we renew every January by $25,000 in both credits.

Their pricing structure is a pay-per-second usage in terms of credits, but you can get discounts if you buy them in bulk. I think it's $1.10 an hour in terms of usage. We just buy upfront and that gets us taken care of for the whole year.

We did. I evaluated Google BigQuery and Amazon Redshift.

In terms of distinguishing features between each of them, it was really just two things. One was the speed factor of query times. The other thing that really sold us on Snowflake was their ability for data sharing. They have a unique product as part of their solution that you can share information directly with other individuals, either in their own additional private cloud or if they're not Snowflake customers, simply sharing a URL link to where they can receive data themselves.

It's good to use every day. It's the backbone of our entire reporting platform for both internal and external deployments of reports and visibility. We plan on continuing to grow our usage with it, as we put more and more people into our reporting platforms and bring our customers into more self-service that's going to increase the usage of the tool by the way that it actually serves up the information to the BI platform.

It's not at this time a transactional sort of database solution. It's truly only meant for data warehousing or data laking, and there's a lot of different ways to do role-level security. So you've got to have a good plan on that, but if you're looking for it to be the backbone of a transactional application, it's not the right tool for that.

I would rate this solution a ten out of ten.

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're ingesting third-party data analytics into a database held within Snowflake. We have pre-production and production environments with integration to staging and production schemas.

It has improved the way our organization functions. However, we're still pretty elementary in our understanding of how it all works and the complete capabilities of Snowflake.

The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard.

The data sharing capabilities across business units within the organization should be better. There could also be better integration.

I have been using Snowflake for a year and three months.

We have high confidence in it.

We have high confidence in its scalability. In terms of its users, for our solution, we only have a team of 10, but we have plans to increase its usage.

We haven't had any technical contact. All of it has been internal for our organization.

This is a net-new solution. So, it's brand new. We chose Snowflake for a variety of reasons, but mainly, we chose it for its scalability and data sharing capabilities.

I would rate it a three out of five in terms of complexity just because we didn't have any Snowflake developers that were available. The implementation took about three months.

We implemented it on our own.

We have not yet seen an ROI.

We're based on credits. So, we're paying four and a half dollars of credit. There are no additional costs. I would rate it a two out of five in terms of pricing.

I would advise ensuring that you have the expertise with domain knowledge in Snowflake. The time from initial concept to deployment could be expedited extremely fast. Just from our internal learnings, we see that our time to production has increased month over month.

I would rate it a six out of ten just because we're unaware or naive to the full capabilities of the product. However, I would highly recommend it in terms of setting up data warehousing internally over an Azure solution, such as Synapse, or something else.

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.

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.