Microsoft Azure Synapse Analytics Review

Good documentation and does not incur costs when not in use, but needs support for query caching

What is our primary use case?

We are a consulting agency and the Microsoft Azure SQL Data Warehouse is what we use for general BI reporting and visualization.

What is most valuable?

The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs. This is better than Amazon Redshift, where the costs continue to accumulate.

The documentation is good.

What needs improvement?

This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query. As it is now, you still have to use compute for each query.

We would like to have integration with the data lake so that we can avoid retrieving the data from it, just to store it in Synapse before we can use it. From an architectural perspective, avoiding this replication would be good.

For how long have I used the solution?

I have been using this product for about one year.

What do I think about the stability of the solution?

Stability-wise, this is a good product.

What do I think about the scalability of the solution?

This solution is scalable, although I don't expect that we will expand it beyond the current usage.

How are customer service and technical support?

We have not had to reach out to support. Rather, we have relied on the documentation. It is easy to solve your own problems.

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

I also have experience with using Snowflake. It has the option to cache query results, which is helpful. 

Amazon Redshift is another similar solution that I have experience with, although it lacks the ability to suspend the computer to save costs when it is not being used.

How was the initial setup?

The initial setup is straightforward.

What other advice do I have?

The Azure SQL Data Warehouse has been renamed to Synapse, although not all of the features have been implemented yet. I am looking forward to a more mature version of this product in the future.

I would rate this solution 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: My company has a business relationship with this vendor other than being a customer: Partner
More Microsoft Azure Synapse Analytics reviews from users
...who work at a Manufacturing Company
...who compared it with Snowflake
Add a Comment