2019-07-29T10:11:00Z

What advice do you have for others considering Snowflake?

Julia Miller - PeerSpot reviewer
  • 3
  • 199
PeerSpot user
Get the report
Helped 765,234 peers since 2012
65

65 Answers

Sushrit Moundekar - PeerSpot reviewer
Real User
Top 5Leaderboard
2024-01-19T08:02:27Z
Jan 19, 2024

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.

Search for a product comparison
Iqbal Hossain Raju - PeerSpot reviewer
Real User
Top 5
2023-09-20T16:36:59Z
Sep 20, 2023

We are working on two solutions for Snowflake, one for the cloud and one for on-premises. It has good documentation. If someone goes through it, they will quickly understand how it works. However, Firebolt's documentation is more comprehensive. If I need faster results, I'll prefer the Firebolt; if I need performance, I'll use Snowflake. Overall, I rate it a nine out of ten.

DominicMackenzie - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-08-25T06:41:00Z
Aug 25, 2023

I would give Snowflake a seven out of ten.

TT
Real User
Top 5Leaderboard
2023-05-09T07:52:00Z
May 9, 2023

I recommend the solution to others and rate it as a nine. It efficiently processes the data and gets reports as well.

Rahul-Sahay - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-04-19T08:33:00Z
Apr 19, 2023

I give Snowflake a nine out of ten. Snowflake is being used at the enterprise level. If an organization is interested in embarking on its cloud journey and Snowflake fulfills its requirements, I would recommend it as a viable solution.

Ankit  Shukla - PeerSpot reviewer
Real User
Top 5
2023-03-17T11:42:28Z
Mar 17, 2023

I would advise other people trying to use this solution to build a skill balance as it's quite difficult to work in Snowflake. I would rate this solution as a whole a nine, on a scale from one to 10, with one being the worst and 10 being the best.

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
KR
Real User
Top 20
2023-03-14T09:35:41Z
Mar 14, 2023

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

MF
Consultant
Top 20
2023-03-01T14:18:18Z
Mar 1, 2023

I give the solution an eight out of ten. My advice is to start Snowflake and not spend too much time thinking about how we could use the solution or what it could be used for. The key is just getting started.

AB
Real User
Top 10
2023-02-09T15:51:31Z
Feb 9, 2023

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.

Sreenivasan Ramanujam - PeerSpot reviewer
Real User
Top 10
2023-02-03T21:20:00Z
Feb 3, 2023

It's a great product. I think people don't need to stick to traditional Oracle systems and rather go for Snowflake. There you don't need to worry about any updates. It is a cloud product, so it automatically updates regularly. The advice is to get used to this way of working as it's new. You have to get familiar with the technology, and a little bit of the terminology. It's a very good product. I would rate it eight out of ten.

DA
Real User
Top 20
2023-02-03T18:34:13Z
Feb 3, 2023

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.

Adnan Shafiq - PeerSpot reviewer
Real User
Top 5
2023-01-13T12:06:53Z
Jan 13, 2023

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

Luis Miguel Goez - PeerSpot reviewer
Real User
Top 10
2022-10-25T17:55:23Z
Oct 25, 2022

I rate this solution nine out of 10.

it_user1251369 - PeerSpot reviewer
Real User
2022-08-12T17:10:40Z
Aug 12, 2022

I would recommend the SaaS version for their organization. It is not complicated to use. Establishing a private link with current cloud services has been challenging so I would recommend having some kind of a block. I would rate this solution a nine out of ten.

Hussain Modu - PeerSpot reviewer
Real User
Top 20
2022-05-26T13:46:16Z
May 26, 2022

I would rate this solution 8 out of 10.

MedhaValvekar - PeerSpot reviewer
Real User
Top 5
2022-05-12T13:24:21Z
May 12, 2022

My past company was a Snowflake customer. This current company is not, however, it may be on the verge of it. I'm using the latest version of the solution. We switched clouds at some point. I was using it on AWS, and now it is on Azure. I'd recommend the solution to others. I would rate it nine out of ten.

OA
Real User
2022-03-18T12:43:18Z
Mar 18, 2022

I would rate it a 10 out of 10.

RN
Consultant
2022-03-16T18:39:35Z
Mar 16, 2022

I rate Snowflake an eight out of ten.

MA
Real User
2020-12-03T18:17:09Z
Dec 3, 2020

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. 

NK
Real User
Top 20
2021-05-04T14:26:16Z
May 4, 2021

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 )

MA
Real User
2021-02-09T00:04:25Z
Feb 9, 2021

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. 

SR
Real User
2021-02-05T17:47:21Z
Feb 5, 2021

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.

JC
Real User
2020-06-03T13:26:32Z
Jun 3, 2020

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.

Biraja Mishra - PeerSpot reviewer
MSP
2022-02-22T09:32:00Z
Feb 22, 2022

I would rate it an eight out of 10.

HarishAjjarapu - PeerSpot reviewer
Real User
2022-01-26T11:31:00Z
Jan 26, 2022

Snowflake is easy for business users to implement, allowing them to start small and grow big. I think people are still debating on whether they should still continue with S3 and add Snowflake or, whether they should take away S3 and completely rely on Snowflake. I would rate this solution an eight out of ten.

CD
Real User
2022-01-05T08:21:44Z
Jan 5, 2022

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.

CR
Real User
2021-12-09T21:07:45Z
Dec 9, 2021

Snowflake has a lot of capabilities and performance. However, the tool is not a silver bullet and can do everything. If you designed what you need according to the tool, then everything is going to be okay. This is true for any tool. Many people start the projects without validating what they are going to expect to have at the end, they receive a big surprise. They were thinking that the tool has this capability and it doesn't have it or perhaps it has the capability but the design you have does not work correctly. If you see the percentage of projects in the different customers in many places, such as in Mexico, Florida, and Miami. Snowflake is a tool that is currently being used but has not been in the past. There is not a lot of history. I rate Snowflake a six out of ten. We have not used Snowflake long enough to better rate it. If we had a lot more formal education or had more information or reference manuals our experience would be better.

TB
Real User
2021-11-07T09:18:00Z
Nov 7, 2021

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.

JH
Real User
2021-09-28T09:30:44Z
Sep 28, 2021

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.

RV
MSP
2021-08-11T15:04:39Z
Aug 11, 2021

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.

AK
Real User
2021-06-29T06:07:18Z
Jun 29, 2021

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

EK
Real User
2021-06-24T13:47:09Z
Jun 24, 2021

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.

JC
Real User
2021-06-03T12:06:30Z
Jun 3, 2021

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.

SM
Real User
2021-04-15T07:17:20Z
Apr 15, 2021

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

Anirban Bhattacharya - PeerSpot reviewer
Real User
Top 5
2021-04-09T16:28:22Z
Apr 9, 2021

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.

AS
Real User
2021-04-01T16:05:50Z
Apr 1, 2021

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.

PC
Real User
2021-03-02T18:05:02Z
Mar 2, 2021

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.

SS
Real User
2021-02-25T21:50:48Z
Feb 25, 2021

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.

CP
Real User
2021-02-23T05:38:53Z
Feb 23, 2021

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.

SR
Real User
2021-02-23T05:18:17Z
Feb 23, 2021

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.

YM
Real User
2021-02-15T18:58:49Z
Feb 15, 2021

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.

KG
Real User
2021-02-01T10:35:32Z
Feb 1, 2021

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

FG
Real User
2021-01-28T11:53:32Z
Jan 28, 2021

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.

ES
Real User
2021-01-24T15:56:01Z
Jan 24, 2021

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.

MR
Real User
2021-01-24T08:53:00Z
Jan 24, 2021

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.

SM
Real User
2020-12-24T16:27:45Z
Dec 24, 2020

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

Varun Garg - PeerSpot reviewer
Reseller
Top 10
2020-12-18T10:47:37Z
Dec 18, 2020

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.

AB
Real User
2020-12-07T18:54:40Z
Dec 7, 2020

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.

MA
Real User
2020-11-10T06:36:00Z
Nov 10, 2020

I would rate Snowflake an eight out of ten.

TB
Real User
2020-11-09T14:15:42Z
Nov 9, 2020

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.

YM
Real User
2020-10-29T13:02:21Z
Oct 29, 2020

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

DE
Real User
2020-10-07T07:04:36Z
Oct 7, 2020

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.

NP
Real User
Top 20
2020-10-06T06:57:48Z
Oct 6, 2020

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.

VK
MSP
2020-10-04T06:40:21Z
Oct 4, 2020

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.

ST
Real User
2020-08-06T06:44:48Z
Aug 6, 2020

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.

SS
Real User
2020-07-26T08:19:11Z
Jul 26, 2020

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.

WM
Consultant
2020-06-15T07:33:54Z
Jun 15, 2020

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.

YR
Real User
2020-01-15T08:03:00Z
Jan 15, 2020

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).

DR
Real User
2020-01-09T06:15:00Z
Jan 9, 2020

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.

it_user1251369 - PeerSpot reviewer
Real User
2019-12-30T06:00:00Z
Dec 30, 2019

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.

JH
Real User
2019-12-12T07:48:00Z
Dec 12, 2019

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.

it_user865563 - PeerSpot reviewer
Real User
2019-12-05T11:14:00Z
Dec 5, 2019

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.

DK
Real User
2019-10-21T17:16:00Z
Oct 21, 2019

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.

it_user1174809 - PeerSpot reviewer
Consultant
2019-10-06T16:38:00Z
Oct 6, 2019

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.

VG
Real User
2019-07-29T10:11:00Z
Jul 29, 2019

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.

Snowflake is a cloud-based data warehousing solution for storing and processing data, generating reports and dashboards, and as a BI reporting source. It is used for optimizing costs and using financial data, as well as for migrating data from on-premises to the cloud. The solution is often used as a centralized data warehouse, combining data from multiple sources. Snowflake has helped organizations improve query performance, store and process JSON and XML, consolidate multiple databases...
Download Snowflake ReportRead more

Related articles