Azure Synapse Analytics Reviews & Product Details

Better view as a table and insights. Serverless SQL is the best advantage in that. Review collected by and hosted on G2.com.

Connecting to the purview from synapse is difficult Review collected by and hosted on G2.com.

The dynamics of Azure, seamless integration with all other apps Review collected by and hosted on G2.com.

Nothing yet Although the front end could be rebuilt again for future Review collected by and hosted on G2.com.

Azure Synapse has helped me ease my workload Review collected by and hosted on G2.com.

It can be quite overwhelming at times hence it definitely has some learning curve to it. Review collected by and hosted on G2.com.

I like its scalability and the analytics solution it provides Review collected by and hosted on G2.com.

Difficult to manage high volumes of concurrent queries Review collected by and hosted on G2.com.

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.

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.

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.

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.

PySpark notebooks and easy connectivity to my Data Lake Review collected by and hosted on G2.com.

Time to spin up resources with PySpark notebooks Review collected by and hosted on G2.com.

Synapse being a one stop shop for SQL Stored Procedures, Python/ Spark Notebooks, Orchestration Pipeline etc. Review collected by and hosted on G2.com.

Not enough telemetry for Notebooks failure and stored procedure logs Review collected by and hosted on G2.com.

More Powerful than Azure data factory. The computation power is more because we have notebook option. Desired language can be selected and notebook can be written. Excellent service Review collected by and hosted on G2.com.

Since the product is not yet fully developed many features are still in developing phase. Cost factor is also a pros for Azure synapse. UI is not so interactive. Review collected by and hosted on G2.com.

I love the easy of data transfer between on premise and cloud capabilities. Review collected by and hosted on G2.com.

It can be costly if you don't watch your data processes tightly. Review collected by and hosted on G2.com.