2019-07-29T10:11:00Z
it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees
  • 3
  • 204

What advice do you have for others considering Snowflake?

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?

53
PeerSpot user
53 Answers
Data Sleek - PeerSpot reviewer
Owner at a consultancy with 1-10 employees
Real User
Top 5
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. 

Search for a product comparison
NitinKumar - PeerSpot reviewer
Director of Enginnering at Sigmoid
Real User
Top 5Leaderboard
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 )

Data Sleek - PeerSpot reviewer
Owner at a consultancy with 1-10 employees
Real User
Top 5
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. 

SreenivasanRamanujam - PeerSpot reviewer
Director -Data Architecture and Engineering at Decision Minds
Real User
Top 10
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.

Jesus Carroll - PeerSpot reviewer
Data Engineer at Prodxia
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.

Luis Miguel Goez - PeerSpot reviewer
Senior Manager Information Technology Infrastructure at SURA
Real User
Top 10
2022-10-25T17:55:23Z
Oct 25, 2022

I rate this solution nine out of 10.

Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
655,774 professionals have used our research since 2012.
it_user1251369 - PeerSpot reviewer
Principal IT Technologist- BI Platform Architect at Medtronic
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
Technical Lead at Wipro Limited
Real User
Top 20
2022-05-26T13:46:16Z
May 26, 2022

I would rate this solution 8 out of 10.

MedhaValvekar - PeerSpot reviewer
Sr Manager at Cognizant
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
Big Data & Cloud Manager at a tech services company with 1,001-5,000 employees
Real User
Top 20
2022-03-18T12:43:18Z
Mar 18, 2022

I would rate it a 10 out of 10.

RN
Consultant at a financial services firm with 1,001-5,000 employees
Consultant
2022-03-16T18:39:35Z
Mar 16, 2022

I rate Snowflake an eight out of ten.

Biraja Mishra - PeerSpot reviewer
Senior Principal Consultant at Genpact - Headstrong
MSP
Top 10
2022-02-22T09:32:00Z
Feb 22, 2022

I would rate it an eight out of 10.

HarishAjjarapu - PeerSpot reviewer
Associate Director at Accenture
Real User
Top 5
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
Data Architect at a tech services company with 201-500 employees
Real User
Top 10
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
Director Consultoria at tecnoscala consulting
Real User
Top 5
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
director of business operations at a logistics company with 51-200 employees
Real User
Top 20
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
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees
Real User
Top 20
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.

RAHULVERMASIR - PeerSpot reviewer
Director - Data Analytics at Sunera Technologies
MSP
Top 5
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
Senior Snowflake Data Architect @ COOP Financials NC at a tech services company with 1,001-5,000 employees
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
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
Real User
Top 5Leaderboard
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
General Manager of Data Science at a non-profit with 501-1,000 employees
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
CEO at a computer software company with 51-200 employees
Real User
Top 20
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
Vice President at Tech Mahindra Limited
Real User
Top 5Leaderboard
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.

Anoop Anoop SLK - PeerSpot reviewer
Enterprise architect at a computer software company with 201-500 employees
Real User
Top 5Leaderboard
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
Sr. Solution Architect at a insurance company with 1,001-5,000 employees
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
Enterprise BDM and Solutions Speacialist at a tech services company with 10,001+ employees
Real User
Top 20
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
Founder & CIO at a computer software company with 11-50 employees
Real User
Top 20
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.

SreenivasanRamanujam - PeerSpot reviewer
Director -Data Architecture and Engineering at Decision Minds
Real User
Top 10
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.

Yaniv Meir - PeerSpot reviewer
BI & BIG DATA Director at Malam-Team
Real User
Top 10
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
Associate Manager at a consultancy with 501-1,000 employees
Real User
Top 5Leaderboard
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
Lead Data Analyst at a wholesaler/distributor with 1,001-5,000 employees
Real User
Top 20
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
AVP Enterprise Architecture at a financial services firm with 501-1,000 employees
Real User
Top 20
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.

Mauricio Ruiz Falcón - PeerSpot reviewer
Senior Information Management Architect at Raken
Real User
Top 20
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.

Subhrajit Mitra - PeerSpot reviewer
Sr. Technical Architect - Business Intelligence / Data Warehouse at a computer software company with 1,001-5,000 employees
Real User
Top 10
2020-12-24T16:27:45Z
Dec 24, 2020

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

VG
Senior Vice President at a tech services company with 201-500 employees
MSP
Top 20
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
Technology & Innovation at a consultancy with 201-500 employees
Real User
Top 20
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
Senior Solutions Architect at NessPRO Italy
Real User
2020-11-10T06:36:00Z
Nov 10, 2020

I would rate Snowflake an eight out of ten.

Tom Bruce - PeerSpot reviewer
Co-founder & Delivery Lead at a tech services company with 1-10 employees
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.

Yash Mittal - PeerSpot reviewer
Lead Data Engineer at a consultancy with 51-200 employees
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
Data Architect and ETL Manager at a manufacturing company with 10,001+ employees
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
DBA Individual Contributor at Aristeia Capital
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.

Veerendra Karnam - PeerSpot reviewer
General Manager at itcinfotech
MSP
Top 20
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
Solutions Architect-AI & ML at a tech services company with 10,001+ employees
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
Senior Software Engineer at a financial services firm with 1,001-5,000 employees
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
Principal Consultant at a tech services company with 51-200 employees
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
R&D Operations Manager at a manufacturing company with 1,001-5,000 employees
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
Sr. Software Developer at Tech Mahindra Limited
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
Principal IT Technologist- BI Platform Architect at Medtronic
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
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees
Real User
Top 20
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
Data Engineer at Celebal Technologies
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
Data & Analytics Practitioner at a tech services company with 1,001-5,000 employees
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
Business Intelligence Consultant at a tech services company with 201-500 employees
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.

Valai Gunapalan - PeerSpot reviewer
Architect at Sony Corporation of America
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.

Related Questions
RK
Head of Data Delivery at Hastings Insurance Services Limited
Dec 2, 2021
Hi peers, I work at an Insurance company with 5000+ employees and I'm interested in the collective view here.  Does anyone have a view on how Matillion ETL functionality compares to ADF for Snowflake integration, when ADF and Snowflake are hosted on Azure? Note: Azure hosting is important, as this appears to offer better integration options than when using ADF on AWS (for example). Thanks f...
NitinKumar - PeerSpot reviewer
Director of Enginnering at Sigmoid
Sep 7, 2021
Hello,  I am using Snowflake for JSON data and we have almost 700 million JSON rows.  Is it possible to achieve a sub-second performance in Snowflake? I am OK to cluster and flatten the JSON data into structured tables if necessary.  Thank you.
See 1 answer
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Sep 7, 2021
Hi @Anoop Anoop SLK , @Subhrajit Mitra ​and @Yash Mittal,  Can you possibly assist @NitinKumar with this question?
Related Articles
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Apr 26, 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias. Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why. You can read user reviews for the Top 5 Data Warehouse Tools to help you d...
Explore this product
Related Articles
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Apr 26, 2022
Top 5 Data Warehouse Tools 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to...
Download Free Report
Download our free Snowflake Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
655,774 professionals have used our research since 2012.