(4)
4.9 out of 5
Visit Website
Sponsored
41 Azure Synapse Analytics Reviews
4.5 out of 5
View 1 Video ReviewsThe next elements are filters and will change the displayed results once they are selected.
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
G2 reviews are authentic and verified.
Here's how.
We strive to keep our reviews authentic.
G2 reviews are an important part of the buying process, and we understand the value they provide to both our customers and buyers. To ensure the value is retained, it's important to make certain that reviews are authentic and trustworthy, which is why G2 requires verified methods to write a review and validates the reviewer's identity before approving. G2 validates the reviewers identity with our moderation process that prevents inauthentic reviews, and we strive to collect reviews in a responsible and ethical manner.
UH
Verified User in Hospital & Health Care
Enterprise(> 1000 emp.)
What do you like best about Azure Synapse Analytics?
What I most like about azure synapse analytics is it gives us end to end manages instance. Be it azure sql Or adf and any other functionality. We don't need to manage any connections they are all managed by synapse. Review collected by and hosted on G2.com.
What do you dislike about Azure Synapse Analytics?
The cost structure is difficult to understand. And the logging metrics are not easy to use. Integrated external 3rd party data sources this capability seems to be missing. Review collected by and hosted on G2.com.
AM
Akshat M.
Senior Data Engineer
Enterprise(> 1000 emp.)
Products used within Microsoft Azure Databases: Azure SQL Database, Azure Synapse Analytics, Azure Cosmos DB, Azure Table Storage, Azure Data Factory
What do you like best about Microsoft Azure Databases?
You have multiple options based on your use cases and it all works. You just need to know when to use what. There's the commonly used Sql Server(which is now hosted on cloud), then you have Sql Warehouses, that they renamed to Synapse and added a whole lot of great functionalities which is appreciated. Review collected by and hosted on G2.com.
What do you dislike about Microsoft Azure Databases?
Their constant renaming and rebranding of stuff is just mind-boggling. Sql warehouses became Azure Synapse. If you ask anyone what Synapse is, they will give you an answer different from another answer that you might get and both of them would be correct. MS just needs to name their products correctly and stick to it without any redundancies. Review collected by and hosted on G2.com.
AG
Anup G.
Corporate Trainer
Small-Business(50 or fewer emp.)
What do you like best about Azure Synapse Analytics?
SQL support, User Interface is quick to learn, Power BI Connectivity Review collected by and hosted on G2.com.
What do you dislike about Azure Synapse Analytics?
Limited SQL features available, Changes and updates can be given a more enhanced explanation Review collected by and hosted on G2.com.
GT
Gavaskar T.
Software Engineer
Small-Business(50 or fewer emp.)
What do you like best about Azure Synapse Analytics?
Better view as a table and insights. Serverless SQL is the best advantage in that. Review collected by and hosted on G2.com.
What do you dislike about Azure Synapse Analytics?
Connecting to the purview from synapse is difficult Review collected by and hosted on G2.com.
OK
Omansh K.
Trainee Decision Scientist - 3
Mid-Market(51-1000 emp.)
What do you like best about Azure Synapse Analytics?
The dynamics of Azure, seamless intergration with all other apps Review collected by and hosted on G2.com.
What do you dislike about Azure Synapse Analytics?
Nothing yet Although the front end could be rebuild again for future Review collected by and hosted on G2.com.
AC
Verified User in Computer & Network Security
Small-Business(50 or fewer emp.)
What do you like best about Azure Synapse Analytics?
Azure Synapse has helped me ease my workload Review collected by and hosted on G2.com.
What do you dislike about Azure Synapse Analytics?
It can be quite overwhelming at times hence it definitely has some learning curve to it. Review collected by and hosted on G2.com.
UU
Verified User in Utilities
Mid-Market(51-1000 emp.)
What do you like best about Azure Synapse Analytics?
I like its scalability and the analytics solution it provides Review collected by and hosted on G2.com.
What do you dislike about Azure Synapse Analytics?
Difficult to manage high volumes of concurrent queries Review collected by and hosted on G2.com.
TG
Tanishq G.
Data Engineer
Mid-Market(51-1000 emp.)
What do you like best about Azure Synapse Analytics?
The serverless pool which can work with external data sources with reference works very well, it gives the option to use Azure databricks to process files and use synapse as SQL frontend for it. User management is also easy, as you can provide access on every level, DB level, schema level etc. We can also import PowerBI datasets into the workspace and gives users one place to view everything which helps a lot. Option to write TSQL, KSQL, notebook, spark job etc also keeps everything at one place with GIT integration they perform very well. Pipelines can also be shifted from ADF to here, hence it becomes a single platform for everything. Logging is also very good, containing SQL query, user and execution time provides great insights about users and helps in data protection. Review collected by and hosted on G2.com.
What do you dislike about Azure Synapse Analytics?
Queries can take several minutes to execute on a serverless pool. sometimes they don't even get cancelled. Indexing is only available in the dedicated server pool. When importing PowerBI datasets the only option is to create reports, we should be allowed to see underlying datasets in raw and fetch data from them using TSQL, then it would be more useful. TSQL is more powerful in SSMS, Synapse doesn't allow some functions and even takes time. Review collected by and hosted on G2.com.
CM
Verified User in Management Consulting
Enterprise(> 1000 emp.)
What do you like best about Azure Synapse Analytics?
It is easy to use, we can create multiple jobs using synapse studio it could be azure data factory, databricks and SQL data warehouse. it supports all the processes and it easily handles a big amount of data we can easily define indexes and dimensions in the synapse analytics platform. Review collected by and hosted on G2.com.
What do you dislike about Azure Synapse Analytics?
Dislike is not specific it is a bit costly and SQL data pool connectivity needs to be improved. It hangs when a large amount of data comes from more than 100K rows also query takes time to run sometimes it gives a timeout error. Review collected by and hosted on G2.com.
UH
Verified User in Hospital & Health Care
Small-Business(50 or fewer emp.)
Pricing
Pricing details for this product isn’t currently available. Visit the vendor’s website to learn more.
Azure Synapse Analytics Categories on G2
