41 Azure Synapse Analytics Reviews

The main factror to which I enjoy implementing and using MS Azure Databases is due to the ease of integration within other technologies and the reporting properties. Review collected by and hosted on G2.com.
There are no areas of dislike. I would like to obtain more available certifications. Review collected by and hosted on G2.com.
It is fast and has every feature that a team needs, My team has been using it for the last 2 years, it's easy to use and its customer support is great Review collected by and hosted on G2.com.
it's costly and sometimes has some bugs, but it does not have many extensions. Review collected by and hosted on G2.com.

Azure Synapse Analytics had a wonderful UI calles Synapse Studio which makes it extremely easy to use. It is highly scalable which makes it easier to find insights of important data. It allows linking resources and working with scripts as well as spark notebooks. It's feature of integrating Spark pools makes data processing and analytics hassle free. It has security that of Azure so there is no compromise on that too. All in all, it is a go to cloud ETL and data analytics tool. Review collected by and hosted on G2.com.
There is nothing that I dislike about Sunapse analytics as such. Just an improvement that I would like to see is addition of drag and drop feature in it's UI. Review collected by and hosted on G2.com.

Microsoft have a vide varieties of data bases for the differnt use case and all are good efficient. Review collected by and hosted on G2.com.
Some databases of Microsoft like Azure MS SQL database. I'm not able to install SSMS in macbook. They only provided management studio for window user Review collected by and hosted on G2.com.

It provides Deep integration of Azure Machine Learning, Cognitive Services, and Power BI
It has the big data analytical capabilities of spark and data integration to move data between both.
It is the overcome of Azure Data factory tool, it provides the independent storage and compute cluster.
It provides the SQL pools which are Dedicated SQL pools and Serverless SQL pools we can work according to data.
It provides Hybrid data integration by using this we can connect with on-prem SQL and cloud-based storage. It provides a complete solution.
It offers cloud data warehousing, dashboarding, and machine learning analytics in single workspace which makes Synapse more powerful than ADF.
It can ingest all types of data including Relation data and non-relation data and can see data in SQL.
It provides parallel processing which manages analytical workload and processes large volumes of data. Review collected by and hosted on G2.com.
Overall Synapse is okay, but there are some problems -
There is no way to migrate data from a Dedicated SQL pool to a Serverless SQL pool, which increases manual intervention and this can be hectic for large data. Review collected by and hosted on G2.com.

Easy to use, connectivity from all technologies, easily integrated Review collected by and hosted on G2.com.
Cost is little high, it will be expensive for daily tasks Review collected by and hosted on G2.com.
Realize cost savings, stronger security. Confidential computing and hotpatching. Review collected by and hosted on G2.com.
Price is the only downside. It costs a little more, but does more for the dough. Review collected by and hosted on G2.com.
Scalable, Secure, and Seamlessly Integrated Review collected by and hosted on G2.com.
Cost, complexity, and occasional downtime Review collected by and hosted on G2.com.

Uified Analytics Platform
Scalability and Performance
Advanced Analytics Capabilities
Security and Compliance
Cost Optimization
Integration with Azure Services Review collected by and hosted on G2.com.
Maturity of Features: As with any evolving technology, certain features or functionalities within Azure Synapse Analytics might still be maturing or undergoing improvements. This could result in occasional limitations or gaps in certain areas, requiring workarounds or alternative approaches. Review collected by and hosted on G2.com.

The best thing about Azure Synapse analytics platform is that it provides all service under a single umbrella which reduces dependency and also helps in manage all service at once Review collected by and hosted on G2.com.
There are many things to dislike about Azure Synapse analytics. One of the things are CTE doesn't support in SQL pool instance either of them serverless or dedicated Review collected by and hosted on G2.com.