Buyer's Guide
Cloud Data Warehouse
November 2022
Get our free report covering Snowflake Computing, Amazon, Microsoft, and other competitors of Microsoft Azure Synapse Analytics. Updated: November 2022.
653,522 professionals have used our research since 2012.

Read reviews of Microsoft Azure Synapse Analytics alternatives and competitors

Mauricio Ruiz Falcón - PeerSpot reviewer
Senior Information Management Architect at Raken
Real User
Top 20
I like how quickly the solution can be implemented
Pros and Cons
  • "The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
  • "It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."

What is our primary use case?

We are a consulting company so our primary use depends on the niche that we are providing the services to and on which of the different versions they have. I think we are mainly using Snowflake Enterprise.

In general, it is being used for integrating information. Snowflake is a database platform, it gives information to support analytic needs, such as advanced data analytics like machine learning. In some of those cases it is also used for descriptive analytics, for instance BI.

How has it helped my organization?

One of example of how Snowflake has improved a client's organization is the democratization, it makes information available to more of the users.

What is most valuable?

The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also.

What needs improvement?

I think that the area of improvement with Snowflake is to improve the administration. It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud.

I also heard from a company we work for that it could be more user-friendly because it provides some tools but they are not user-friendly.

Additionally, it would be very helpful if Snowflake integrated machine learning and some other advanced analytics features within their language or product capabilities. Right now, they do it through some other company where you have to buy these capabilities from other vendors. There are some customers that don't have complex needs for machine learning or advanced analytics so they don't have to buy it from another vendor but can use it from the product itself if they have it.

For how long have I used the solution?

The whole company has been using Snowflake for about three years.

What do I think about the stability of the solution?

In terms of stability, so far it is very stable.

What do I think about the scalability of the solution?

Snowflake is very scalable. Our client companies where we implement Snowflake are medium to large sized. These companies have offices in different parts of the world, not just some regions, but companies with office users in different parts of the world. We are dealing with international companies. Their tendency is to increase the use of the Snowflake platform. It would serve all the analytical needs in these companies.

How are customer service and technical support?

I have not directly experienced the technical support. It's not part of my job to be involved on those kind of issues, but we constantly receive information as a partner from them and we are very in good touch with them and with the people we are working with, meaning the representatives that are within the Latin American market, which is where I work. They are very open and very fast with communication.

How was the initial setup?

The initial setup is easy. Full deployment takes a few weeks. The initial deployment for the first initiatives might take weeks. It's not complex, really. You may have it loaded after a full day and already providing results or interacting, but there are some other companies that have to be implemented to extract and consume the information from the database. But it's very easy.

Which other solutions did I evaluate?

There have been a couple of other solutions that we've been participating in the evaluation process of and some others that have been included in the decision process, including Redshift from AWS and also Azure Synapse from Microsoft.

For instance, AWS Redshift looked like it was easier to implement and to be adopted by the technical users, the programmers and database programmers. So far it has been far easier to adapt this technology. I'm not saying that AWS is a better technology. It's very complex, but at least what I've seen is that for them, it looks like it's been easier to use the first time.

We liked that Snowflake is able to be used as a multi-Cloud service - it can be used in AWS Cloud, Azure Cloud, or Google Cloud. Whereas AWS, or even Synapse, can only be used in their corresponding networks.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Dan_McCormick - PeerSpot reviewer
Chief Strategist & CTO at a consultancy with 11-50 employees
Real User
Top 10
Secure and reasonably priced, but documentation could be improved and visibility is lacking
Pros and Cons
  • "The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring."
  • "They require more detailed error reporting, data normalization tools, easier connectivity to other services, more data services, and greater compatibility with other commonly used schemas."

What is our primary use case?

We use Azure Data Factory for data transformation, normalization, bulk uploads, data stores, and other ETL-related tasks.

How has it helped my organization?

Azure Data Factory allows us to create data analytic stores in a secure manner, run machine learning on our data, and easily adapt to changing schema.

What is most valuable?

The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring.

What needs improvement?

The documentation could be improved. They require more detailed error reporting, data normalization tools, easier connectivity to other services, more data services, and greater compatibility with other commonly used schemas.

I would like to see a better understanding of other common schemas, as well as a simplification of some of the more complex data normalization and standardization issues.

It would be helpful to have visibility, or better debugging, and see parts of the process as they cycle through, to get a better sense of what is and isn't working.

It's essentially just a black box. There is some monitoring that can be done, but when something goes wrong, even simple fixes are difficult to troubleshoot.

For how long have I used the solution?

I have been working with Azure Data Factory for a couple of years.

There is only one version.

What do I think about the stability of the solution?

Overall, I believe the stability has been good, but there have been a couple of occasions when Microsoft's resources needed to be allocated were overburdened, and we had to wait for unacceptable amounts of time to get our slot. It has now happened twice which is not ideal.

What do I think about the scalability of the solution?

There is no limit to scalability.

We only have a few users. One is a data scientist, and the other is a data analyst.

We use it to push up various dashboards and reports, it's a transitional product for transferring, transforming, and transitioning data.

It is extensively used, and we intend to expand our use.

How are customer service and support?

You don't really get that kind of support; it's more about documentation and the community support that is available. I would rate it a three out of five compared to others.

You could call them, and pay for their consulting hours directly, but for the most part, we try to figure it out or look through documentation. 

I think their documentation is lagging because it's not as popular of a tool, there's just not a lot, or as much to fall back on.

How would you rate customer service and support?

Neutral

Which solution did I use previously and why did I switch?

We had only our own tools, and we switched because you get to leverage all of the work done in a SaaS or platform as a service, or however they classify it. As a result, you get more functionality, faster, for less money.

How was the initial setup?

The initial setup is straightforward.

It is a working tool. You can start using it within an hour and then make changes as needed.

We only need one person to maintain the solution; it doesn't take much to keep it running.

It's not a problem; it's a platform.

What about the implementation team?

We completed the deployment ourselves.

What was our ROI?

We have seen a return on investment. I can't really share many details, but for us, this becomes something that we sell back to our clients.

What's my experience with pricing, setup cost, and licensing?

You pay based on your workload. Depending on how much data you process through it, the cost could range from a few hundred dollars to tens of thousands of dollars.

Pricing is comparable, it's somewhere in the middle.

There are no additional fees to the standard licensing fee.

Which other solutions did I evaluate?

We looked at some other tools, such as Databricks, AmazonGlue, and MuleSoft.

We already had most of our infrastructure connected to Azure in some way. So the integration of where our data resided appeared to be simpler and safer.

What other advice do I have?

I believe it would be beneficial if they could find someone experienced in some of the tools that are a part of this, such as Spark, not necessarily Data Factory specifically, but some of those other tools that will be very familiar and have a very quick time for productivity. If you're used to doing things in a different way, it may take some time because there isn't as much documentation and community support as there is for some more popular tools.

I would rate Azure Data Factory a seven out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Eli Misael Manjarrez - PeerSpot reviewer
DBA at Kimetrics
Real User
Top 20
Costs less than Oracle Cloud or Microsoft Azure solutions
Pros and Cons
  • "Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
  • "There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."

What is most valuable?

Amazon Redshift is very fast. It has really good response times. It's very user-friendly.

What needs improvement?

Redshift is a multi-tier engine that works like a calculator. There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity. Sometimes I'd like for them to support some special features or some special installations because we need automatic populations. I would like to see more programming outside of the cloud. I would like to see more functionalities under JSON files. the only functionality that they have now with JSON is reports. I would also like to see other data sources like MongoDB.

For how long have I used the solution?

I have used Amazon Redshift for three years. I use the latest version because it is on Amazon's public cloud.

What do I think about the stability of the solution?

The management of the dates for what we can deliver to it, it's always specific to the form that's defined to Amazon Redshift.

How are customer service and technical support?

I have used their technical support only a few times. Before talking to support I usually try to troubleshoot things myself and I'm usually able to resolve any issues. 

Which solution did I use previously and why did I switch?

In the past year, we have used Azure, but the committee has chosen Amazon Redshift because it is better than Azure for our company needs. We have grown around Amazon Redshift and other AWS solutions.

How was the initial setup?

Amazon Redshift is not as straightforward as other AWS tools but it is not that difficult.

What's my experience with pricing, setup cost, and licensing?

Amazon Redshift costs less than Oracle Cloud or Microsoft Azure.

Which other solutions did I evaluate?

I started using Amazon Redshift because I started working for this company that was working with both Azure and Amazon. The company eventually moved all to Amazon. I wasn't sure why they didn't continue to use Azure. My experience was more with Microsoft technology so I prefer Azure. But, there are some interesting features in Amazon Redshift that works better. I have also used Oracle Cloud.

What other advice do I have?

I would recommend Amazon Redshift as it is part of the AWS platform and they are the biggest in the world.

I would give Amazon Redshift a rating of eight on a scale of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Cloud Data Warehouse
November 2022
Get our free report covering Snowflake Computing, Amazon, Microsoft, and other competitors of Microsoft Azure Synapse Analytics. Updated: November 2022.
653,522 professionals have used our research since 2012.