We just raised a $30M Series A: Read our story
2019-07-29T10:11:00Z

What advice do you have for others considering Snowflake?

113

If you were talking to someone whose organization is considering Snowflake, what would you say?

How would you rate it and why? Any other tips or advice?

ITCS user
Guest
4242 Answers

author avatar
Top 5LeaderboardUser

Snowflake is probably the best data warehouse solution on the market. AWS is playing catch up with S3 Data Lake and Redshift AR3 but they are nowhere close to where SF is. 


Of course, SF's true compute and storage capabilities make it unique. Being able to scale query processing power using SQL within milliseconds is brilliant, no other company can do that. This means I can in my SQL code, invoke a warehouse unit (CPU power) to process some heavy SQL, then invoke a smaller warehouse unit when done. 
These warehouse units are sleeping power, they can be awakened by SQL, do their job, then go back to sleep a few seconds after you're done. That is unprecedented.


Back in time feature, (being able to select a query AS OF (up to 90 days) is also awesome. 


Another big point is SF uses S3 as storage layer, so why not use it for your data lake. The price of storage is similar to S3 (unless you turn on retentions for back in time) still at $45/month/ TB compressed, that's a great deal. 


Nothing prevents you from archiving data into Glacier and bringing it back into S3 which SF can ingest via Snowpipe.


Finally, the Data Marketplace platform they're trying to build is going to revolutionize how we share data. 


There is a big reason why investors poured billions into the IPO for SF. 

2020-12-03T18:17:09Z
author avatar
Top 5LeaderboardReal User

Snowflake is an amazing Product. It is one of the best Warehouses currently in for Cloud. Separation of store and compute and the Warehouse concept makes this unique and it has lots of features, low maintenance and the cost can be optimised to a great extent if we understand how Snowflake works under the hood. 


Other great feature is the way it handles semi-structured data like JSON and XML which is unique. So we can use it as a data lake if required (keeping in mind to not over complicate or misuse it )

2021-05-04T14:26:16Z
author avatar
Top 5LeaderboardUser

For a data warehouse project, there is nothing on the market today that can compete with SnowFlake. TeraData is trying to play catchup, and AWS Redshift trying to come up with an hybrid. 
Snowflake is already years ahead with Data Share, allow you companies to share a their database or schema from their data warehouse with another account. Think DMV data warehouse sharing their driver profiles with FBI data warehouse, and the data is accessible within your account. What just happened? Elimination of data pipeline. No need to transfer data. You just join : select from dvm.driver_profile JOIN fbi.criminal_profile on ...
Snowflake is also building a "Data Marketplace" where you can bring in your data warehouse "data set", without any import.


Being able to rollback up to 90 days, (undrop table, database) being able to clone a DB in few seconds, etc ...


The list if very long. 


Snowflake is not for real time analytics though. I would suggest SingleStore instead. 

2021-02-09T00:04:25Z
author avatar
Top 10Real User

Advice 1 : If the organization has more than 60 to 70% of data science or ML use cases, I would recommend to them to use Azure data bricks instead of Snowflake.


Advice 2: If the organization is heavily into business applications and does not have much ML systems and contains standard reporting, Snowflake is a good choice.


Advice 3: There are other cloud data warehouses in the market (Firebolt) which can be looked by customers to gauge the long term OPEX and ROI in comparison to snowflake.

2021-02-05T17:47:21Z
author avatar
Top 20Real User

SnowFlake is useful to merge all kinds of data, no bother if you have heterogeneous or dis-paired data sources. Try to check every requirement to connect with the data warehouses and be careful with the data federation and cost of resources.

2020-06-03T13:26:32Z
author avatar
Top 5Real User

My advice to those wanting to implement Snowflake is it is easy. However, the way to choose to implement your data in the warehouse matters. When we started to implement our data with Snowflake, we also switched to a metadata-driven approach, but the method depends on the people involved in the implementation. Overall, the implementation of Snowflake follows similar principles as any other data-warehouse implementation except many aspects are a lot easier and helpful. I rate Snowflake an eight out of ten.

2021-09-28T09:30:44Z
author avatar
Top 10MSP

One of the concerns related to Snowflake is about longevity in terms of how long can we use Snowflake. It is a big question in the market. It is a new baby in the market, and we don't know for how long will it trend. It has some big competitors. Firebolt claims to be the number one in this area. They have much better features than Snowflake. I would not say that Snowflake is the best and in the right position at this point in time. Snowflake is good for the next year, but Firebolt is going to bring it down. I would rate Snowflake an eight out of 10.

2021-08-11T15:04:39Z
author avatar
Top 20Real User

The solution is very easy and flexible to integrate with any type of API. I rate Snowflake a nine out of ten.

2021-06-29T06:07:18Z
author avatar
Top 5LeaderboardReal User

We're customers and end-users. We're using the latest version of the solution. I can't speak to the exact version number. I'd rate the solution at a nine out of ten. We've been mostly very happy with its capabilities. I'd recommend the solution to other users and companies.

2021-06-24T13:47:09Z
author avatar
Top 20Real User

It is a good solution. At the moment, I can't find another product that is better than Snowflake, but it needs better ETL functionality, easier configuration, and cheaper support. All products have got some limitation. I would rate Snowflake an eight out of ten.

2021-06-03T12:06:30Z
author avatar
Top 20Real User

On a scale from one to ten, I would give Snowflake an eight.

2021-04-15T07:17:20Z
author avatar
Top 5LeaderboardReal User

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.

2021-04-09T16:28:22Z
author avatar
Top 5LeaderboardReal User

I would recommend this solution to others and we are going to keep using the solution in the future. I rate Snowflake an eight out of ten.

2021-04-01T16:05:50Z
author avatar
Top 20Real User

We are a direct customer and end-user. We've been using the solution during a POC for the last year or so. It's a pilot project to test its feasibility for our company. We're just starting to get performance stats and stuff like that. I'm not sure which version of the solution we are currently using. I don't recall the exact version number. Usually, people are running the latest version. Whatever the latest available option is is likely the number we are on. I'd rate the solution at an eight out of ten. We're still in the POC phase, however, based on what we have seen, we are quite satisfied.

2021-03-02T18:05:02Z
author avatar
Top 20Real User

We don't recommend a cloud typically. We leave it to the customer. If the customer has AWS, and then we sell Snowflake on AWS. If the customer has Google, we sell Snowflake on Google or Azure, or if they have Azure, we sell Azure. They may even have a private cloud. We don't force the customer to buy a particular cloud. We go with the customer's preference from their cloud services because Snowflake works on all three clouds. In general, I would rate the solution eight out of ten. It does what it says it will, and I have yet to hear of customers complaining about its capabilities.

2021-02-25T21:50:48Z
author avatar
Top 20Real User

We are implementors of the solution. We are using previous versions of the solution. It may not necessarily be the latest version all the time. I'd advise other organizations to try it out and play with it a bit to see if it would fit their needs. Overall, I would rate the solution at a nine out of ten. We've been mostly very happy with it.

2021-02-23T05:38:53Z
author avatar
Top 10Real User

I would advise looking at your environment. Look at the workload and what you are trying to migrate. There is no one size fits all model. If you are a transaction system and you want to go with Snowflake, I would not advise this solution. If you are a reporting system and you want to migrate, Snowflake is the best choice. You also need to look at what kind of queries people are running. Don't assume that just because you are moving to Snowflake, you are going to cut down the cost by some factor. That is not going to happen. You need to really do a lot of homework and groundwork to know what kind of queries you're running and how can you avoid the compute costs. There is a lot of metadata available in Snowflake. You have to look at all that and then consciously try to improve the numbers. It is definitely a good tool and a good database without any adoption problems. Users who are SQL savvy can immediately adopt this solution. User onboarding is not really a huge exercise. It is a very simple exercise. I would rate Snowflake an eight out of ten.

2021-02-23T05:18:17Z
author avatar
Top 10Real User

I would advise others to check themselves how fast its implementation can be and how responsive it is. I would also recommend evaluating it before choosing other solutions, such as Microsoft Synapse or Amazon Redshift. You can test it yourself by using a test case. You can try to load the data on each platform, which can take a few weeks, but you will get to know the advantages of this solution. It is very different from other solutions. I would rate Snowflake a nine out of ten.

2021-02-15T18:58:49Z
author avatar
Top 5LeaderboardReal User

I would recommend this solution to others. We plan to keep using it. I would rate Snowflake a nine out of ten.

2021-02-01T10:35:32Z
author avatar
Top 20Real User

My advice is to consider Snowflake when you have more customers. I wouldn't consider Snowflake until I have sufficient customers. Whether we will consider Snowflake in the future depends on how BigQuery behaves. If the cost of BigQuery starts increasing and becomes similar to Snowflake, we're going to switch. If not, we're going to remain with BigQuery. We might also consider other similar solutions, such as Yellowbrick, or switch to another cloud solution, such as Azure or AWS, depending on the price. Right now, we are paying about $2,000 per month. Our goal is to have the total cost of everything to be around $3,000 per month. It is more or less our goal for KPI kind of thing. I would rate Snowflake an eight out of ten.

2021-01-28T11:53:32Z
author avatar
Top 20Real User

If time to value is your primary goal, then I would recommend going for Snowflake over one of the other cloud providers. I would rate Snowflake a ten out of ten. It is one of the few products in which everything demos well. It actually did everything they showed in the demos. We really couldn't find any gotchas in it. It kind of delivered as promised.

2021-01-24T15:56:01Z
author avatar
Top 10Real User

I would definitely recommend Snowflake. On a scale of one to ten, I would give Snowflake an eight. I give it an eight out of 10 due to its room for improvement in the user interface for the monitoring of the credit consumption and that the user experience is not friendly. And also because the machine learning is lacking some advanced analytic features.

2021-01-24T08:53:00Z
author avatar
Top 5Real User

I would recommend this solution. I would rate Snowflake an eight out of ten.

2020-12-24T16:27:45Z
author avatar
Top 10MSP

We're partners with Snowflake. We've been partners for just under a year at this point. I'd definitely recommend the product. It's worked quite well for us. A new customer needs to understand, however, that they need a roadmap of at least five years when they are deciding on their data warehouse. They should compare costs and sizing to make sure they are getting the solution that makes sense for their current and future needs. The solution integrates well with other applications, and if you need it to integrate with existing applications, you still should check to make sure it's possible. I wouldn't necessarily recommend Azure over Snowflake, as they aren't really a good comparison. Snowflake is more focused on data repositories and data warehouses. AWS does give you many options, however.

2020-12-18T10:47:37Z
author avatar
Top 20Real User

Personally, if I have the choice, I would rather recommend Snowflake to my clients over a product from Microsoft, for example. They have some overlapping functionality, but they also have some separate stuff. Snowflake does not have the size to develop at that pace but personally, I find them a more sympathetic company than Microsoft. I would rate this solution an eight out of ten.

2020-12-07T18:54:40Z
author avatar
Top 5Real User

I would rate Snowflake an eight out of ten.

2020-11-10T06:36:00Z
author avatar
Top 10Real User

The best advice I would give is to push for a POC. Pick a couple of use cases where you think you could quickly get value and just see how quickly you can get it implemented. One of the key features of Snowflake is that you can get it up and running straight away.

2020-11-09T14:15:42Z
author avatar
Top 10Real User

I would definitely recommend this solution. I would rate this solution a nine out of 10.

2020-10-29T13:02:21Z
author avatar
Top 20Real User

My advice for anybody who is implementing Snowflake is to start small, then prove out the value and you can grow. I would rate this solution an eight out of ten.

2020-10-07T07:04:36Z
author avatar
Top 5Real User

My advice for anybody who is considering Snowflake is that it is a really good product, especially if you are having issues with Big Data. It is not good for a typical OLTP environment, such as a small table. I would rate this solution an eight out of ten.

2020-10-06T06:57:48Z
author avatar
Top 10MSP

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.

2020-10-04T06:40:21Z
author avatar
Top 20Real User

My advice for anybody who is considering implementing Snowflake is that from a user's standpoint, it is a good product. Having a database in a cloud setup means that you don't have to scale and it has got many features already included. For our use case, we found this Snowflake was good enough and did not need any enhancements. I recommend using it. I would rate this solution a ten out of ten.

2020-08-06T06:44:48Z
author avatar
Top 5Real User

We're a customer. We don't have a business relationship with the solution. Users considering adding the solution should understand that Snowflake can be used only for transactional processing, not for analytical processing. If they want to go for transaction processing, they can go for Snowflake and if they want to go for analytical processing, they should look at or go for an Oracle database. I'd rate the solution seven out of ten.

2020-07-26T08:19:11Z
author avatar
Top 20Consultant

We're partners with Snowflake. The difference between Snowflake, and, for example, Azure, is that there is real separation between the computer and storage. Snowflake is the only one that's really separate and it's much simpler to scale or shift data. It makes everything much easier. One of the best options on the market right now is to have a cloud-only setup. Not everyone is using the cloud, but everyone will catch up. I'd rate the solution nine out of ten. If the user interface was better and they had a few more features and did some useability tweaks it would be perfect. Also, it's hard to get the data out of Snowflake, and that's a real issue design-wise.

2020-06-15T07:33:54Z
author avatar
Top 20Real User

Analyze your user scenario. If your scenario is managing large amounts of data in extremely, different environments in a structured way, then this is a good option. I would rate this solution as an eight (out of 10).

2020-01-15T08:03:00Z
author avatar
Top 20Real User

This is an awesome tool, but there is room for improvement in terms of integration. Also, in terms of management, nothing is perfect and everything can be improved. I would rate this solution an eight out of ten.

2020-01-09T06:15:00Z
author avatar
Top 10Real User

My advice to someone who is looking at Snowflake is that if they are looking at analytics tools in addition to warehousing and certain advantages of cloud computing, then I would suggest Snowflake. But if they are just looking for the warehousing part where you will later just use another solution on top of it, then I would not suggest Snowflake. On a scale from one to ten where one is the worst and ten is the best, I would rate Snowflake as an eight or nine. Let's say 8.5.

2019-12-30T06:00:00Z
author avatar
Top 5Real User

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.

2019-12-12T07:48:00Z
author avatar
Top 20Real User

The solution is deployed on the cloud using Azure, where there's a data warehouse. We primarily use SQL scripts. For those considering implementing, I'd advise that they understand the business very deeply first. Not every business would have a demand for Snowflake, so it's not for everyone. It's important to understand the requirements and then, if it makes sense, to implement Snowflake. I'd rate the solution eight out of ten. I'd rate it higher if it had a better user interface.

2019-12-05T11:14:00Z
author avatar
Top 10Real User

We are system integrators, so for all our customers, we offer different solutions. We only use the cloud deployment model. Snowflake doesn't offer on-premises deployments. Snowflake on cloud is the best right now. There are only a few other options. Redshift is not scalable. With SQL Data Warehouse the concurrency is an issue, as well as scalability. Also, it does not have all the features that you see in an on-premises SQL Server. Snowflake a good database. I'd recommend the solution to others. I'd rate the solution seven out of ten. We are still new to the solution. There are a few things we still have to explore before we would give it 10. Typically, I come from a Hadoop background, so compared to Hadoop I think everything looks good before the data warehouse side. We're quite pleased with Snowflake and moving from Hadoop into Snowflake has been a very good transformation.

2019-10-21T17:16:00Z
author avatar
Top 20Consultant

I would suggest being careful with selecting resources. Each customer case can be completely different and each can require different resources. It's not only the database itself but also how you integrate it with the analytics and the resources. The estimation of the resources is something that you have to pay a lot of attention to when selecting the resources because sometimes you will need EPL or ELT integration, which requires a tool, as does analytics. For an end to end solution, you have to include other products. I would rate this solution an eight out of ten.

2019-10-06T16:38:00Z
author avatar
Real User

Because most of the issues you come across can be dealt with on the user's sites, it's important to educate the users and understand their requirements. The best advice I can give is to understand the product and to try to stick to what is required. From the business side, you need to monitor usage and monitor the space because of on-premises constraints. If it gets filled up then you will have to react. However, this solution is very scalable. I would rate this solution between seven and eight out of ten. The solution still has some constraints that need to be addressed.

2019-07-29T10:11:00Z
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: September 2021.
541,108 professionals have used our research since 2012.