# Azure Synapse Analytics Reviews **Vendor:** Microsoft **Category:** [Big Data Analytics Software](https://www.g2.com/categories/big-data-analytics) **Average Rating:** 4.4/5.0 **Total Reviews:** 38 ## About Azure Synapse Analytics Azure Synapse Analytics is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. ## Azure Synapse Analytics Pros & Cons **What users like:** - Users value the **unified platform** of Azure Synapse Analytics for seamless data integration and efficient analytics solutions. (1 reviews) - Users appreciate the **automation capabilities** of Azure Synapse Analytics, enhancing efficiency and simplifying data analytics processes. (1 reviews) - Users appreciate the **seamless cloud integration** of Azure Synapse Analytics, enhancing efficiency and unifying data workflows. (1 reviews) - Users value the **cost-effective** features of Azure Synapse Analytics, benefiting from on-demand scaling and serverless querying. (1 reviews) - Users appreciate the **seamless data integration** of Azure Synapse Analytics, enhancing analytics solutions with a unified platform. (1 reviews) - Data Pipelining (1 reviews) - Ease of Use (1 reviews) - Easy Integrations (1 reviews) - Efficiency (1 reviews) - Features (1 reviews) **What users dislike:** - Users find **cost estimation complex** due to the intricacies of monitoring across multiple services and governance setups. (1 reviews) - Users face challenges with **cost management** , particularly in monitoring and optimizing across various analytics resources. (1 reviews) - Users often face challenges with **debugging issues** due to lack of transparency in error messages, hindering troubleshooting efforts. (1 reviews) - Users find **difficult debugging** challenging due to steep learning curves and inadequate error transparency in Azure Synapse Analytics. (1 reviews) - Users find Azure Synapse Analytics to be **expensive** , with complex cost management and optimization challenges impacting their experience. (1 reviews) - Learning Curve (1 reviews) - Poor Performance (1 reviews) - Slow Performance (1 reviews) ## Azure Synapse Analytics Reviews ### 1. Efficient Data Engineering, Needs Better Git Integration **Rating:** 3.0/5.0 stars **Reviewed by:** Adarsh C. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** April 16, 2026 **What do you like best about Azure Synapse Analytics?** I use Azure Synapse Analytics for ETL/Data Engineering flows, and I appreciate its ability to process large amounts of data, similar to Databricks or MS Fabric. I like the major connections it offers with Azure Data Lake and other Azure solutions, which aid in saving ingested data efficiently. Another aspect I enjoy is the ease of use with data pipelines, especially the low-code approach that allows me to create a prototype and basic ETL flow in minutes. **What do you dislike about Azure Synapse Analytics?** I believe it needs to improve its git integration features; I don't like the fact that every change is a commit with no clear commit message. Faster Spark Pool start time. Better Git integration framework. Implementation similar to Databricks is the best. Also, it's impossible to review code and pipelines in Azure DevOps, since all the files are JSONs. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** I use Azure Synapse Analytics for ETL and data engineering, ingesting and processing data with PySpark. It processes large data volumes efficiently like Databricks. The connection with Azure Datalake and low-code pipelines simplify workflows, enabling quick prototyping and ETL flows. ### 2. Unified Data Warehousing and Big Data in One Powerful Platform **Rating:** 4.5/5.0 stars **Reviewed by:** Daniel H. | Cloud Enginner, Telecommunications, Mid-Market (51-1000 emp.) **Reviewed Date:** March 03, 2026 **What do you like best about Azure Synapse Analytics?** is how it unifies data warehousing and big data into a single platform, making it easier to query and analyze large datasets efficiently. It integrates SQL for structured queries, Apache Spark for big data processing, and pipelines for seamless data ingestion and transformation. **What do you dislike about Azure Synapse Analytics?** What I dislike about Azure Synapse Analytics is that the initial setup and configuration can be complex, often requiring extra expertise to get everything working smoothly. Debugging and monitoring can also feel limited, especially when managing large pipelines or Spark workloads. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** is solving the challenge of bringing together massive amounts of structured and unstructured data into one place, so I don’t have to juggle multiple tools. It helps streamline data integration, transformation, and analysis, which saves me time and reduces complexity. ### 3. Unified Analytics Platform with Seamless Azure Integration **Rating:** 4.0/5.0 stars **Reviewed by:** Ashish D. | Cloud Engineer, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** February 12, 2026 **What do you like best about Azure Synapse Analytics?** I use Azure Synapse Analytics primarily for building end-to-end data analytics solutions as it helps integrate data ingestion, transformation, storage, and analytics into a single unified platform. I love its unified experience which combines data engineering, big data processing, and enterprise data warehousing within a single workspace, significantly improving efficiency and reducing architectural complexity. I appreciate that I can switch between serverless SQL, dedicated SQL pools, and Spark environments seamlessly. The integration with data lakes and tools like Power BI is smooth, enabling faster insight generation. I value its scalability and performance optimization capabilities, along with the built-in pipeline orchestration suited for handling large-scale analytics workloads. I also appreciate how it integrates with the broader Azure ecosystem, like Azure Data Lake Storage and Azure Machine Learning, facilitating the building of end-to-end data pipelines. The flexibility, operational efficiency, and cost efficiency offered by serverless querying and on-demand scaling are truly beneficial. **What do you dislike about Azure Synapse Analytics?** The learning curve can be steep, especially for teams that are new to distributed data processing or hybrid architectures involving SQL pools and Spark. Debugging complex pipeline failures can sometimes lack detailed error transparency, which increases troubleshooting time. Performance tuning in dedicated SQL pools also requires careful resource management and distribution design, which may not be intuitive for all users. Additionally, cost monitoring and optimization across serverless queries, Spark jobs, and dedicated pools can become complex if governance is not properly established. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Azure Synapse Analytics solves fragmented data system issues by integrating data ingestion, processing, and analytics on one platform. It reduces operational complexity, improves productivity, streamlines data workflows, and enhances decision-making. Seamless integration with BI tools and scalability optimize performance and cost-efficiency. ### 4. All-in-One Data Workspace with a Clean, Easy-to-Use UI **Rating:** 4.5/5.0 stars **Reviewed by:** Nikolay N. | Data engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** April 23, 2026 **What do you like best about Azure Synapse Analytics?** I like that all data is in one place, notebooks, code, tables, it is easy to use and the UI is nice. **What do you dislike about Azure Synapse Analytics?** Sometimes there are small bugs. When I make changes to notebooks, I have to commit every time; otherwise I lose those changes. Also, when I run a notebook, it gets detected as a change in version control. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Everyday I use it for data engineering purposes, I fix code bugs, query tables, perform deploys ### 5. Azure Synapse Analytics - Best ETL Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Varad V. | AI/ML Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 17, 2024 **What do you like best about Azure Synapse Analytics?** 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. **What do you dislike about Azure Synapse Analytics?** 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. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Azure synapse analytics solves my day to day needs with work. As a Data Engineer, I have to do lots of extract, transform and load for data that holds a lot of importance. Azure synapse analytics makes this taks easier for me. It's features of integration and linking with other resources makes it a go to option for any analytics or data preocessing task too. Especially, it's integration with spark pools makes it the most prefered choice for data precessing. So, synapse analytics is benefitting me a lot in my day to day routing work. ### 6. Azure Synapse Analytics a complete solution for data **Rating:** 5.0/5.0 stars **Reviewed by:** Tej P. | DevOps Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 17, 2024 **What do you like best about Azure Synapse Analytics?** 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. **What do you dislike about Azure Synapse Analytics?** 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. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** It provides a data warehouse, computing power, and dedicated and serverless SQL pools which make Synapse more advanced than the ADF. In this ETL pipeline, we can create a Notebook and provide them separate computing power and storage to the notebook which processes and ingests data easily. by using this we can integrate data from various sources like SQL server pools and data warehouses which work efficiently for big data and large amounts of data. Scaleability which makes this cost-effective and provides seamless computing according to data, and it supports parallel processing ### 7. Unleashing the Power of Data: A Comprehensive Review of Azure Synapse Analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Sunny T. | Associate Process Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** June 21, 2023 **What do you like best about Azure Synapse Analytics?** Uified Analytics Platform Scalability and Performance Advanced Analytics Capabilities Security and Compliance Cost Optimization Integration with Azure Services **What do you dislike about Azure Synapse Analytics?** 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. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Data Integration: One of the key challenges in data analytics is integrating data from disparate sources and formats. Azure Synapse Analytics provides seamless integration with various data sources and supports data ingestion from structured, semi-structured, and unstructured data. This enables organizations to bring all their data together in a unified platform, making it easier to extract insights and gain a holistic view of their data. Scalability and Performance: Traditional data analytics solutions often struggle to handle large-scale data processing and complex queries efficiently. Azure Synapse Analytics leverages distributed processing capabilities, allowing organizations to scale their analytics workloads as needed. This scalability, combined with its optimized query execution engine, enables faster processing and analysis of massive datasets, accelerating decision-making processes. ### 8. Azure Synapse for HTAP implementation **Rating:** 4.5/5.0 stars **Reviewed by:** Anshul G. | Decision Scientist II, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2023 **What do you like best about Azure Synapse Analytics?** 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 **What do you dislike about Azure Synapse Analytics?** 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 **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Azure Synapse analytics as a platform is serving well in streaming data with millions of touch points stream through IoT hub and then being processed in synapse platform ### 9. Azure synapse analytics review **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** June 20, 2023 **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. **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. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** So in my project it is working as a centre point to collect all the data and perform the necessary etl operations to transform and send it to external vendors for further actions. ### 10. Azure Synapse - Analytics Service Review **Rating:** 4.5/5.0 stars **Reviewed by:** Anup G. | Corporate Trainer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 15, 2023 **What do you like best about Azure Synapse Analytics?** SQL support, User Interface is quick to learn, Power BI Connectivity **What do you dislike about Azure Synapse Analytics?** Limited SQL features available, Changes and updates can be given a more enhanced explanation **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Data Integration and Analysis. Combining data and performing analytics on the data. ### 11. I used that for my data engineering project. It has best user experience to view as table and chart **Rating:** 4.5/5.0 stars **Reviewed by:** Gavaskar T. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 20, 2023 **What do you like best about Azure Synapse Analytics?** Better view as a table and insights. Serverless SQL is the best advantage in that. **What do you dislike about Azure Synapse Analytics?** Connecting to the purview from synapse is difficult **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Viewing the data in storage account ### 12. Best experience ever **Rating:** 5.0/5.0 stars **Reviewed by:** Omansh K. | Trainee Decision Scientist - 3, Mid-Market (51-1000 emp.) **Reviewed Date:** June 15, 2023 **What do you like best about Azure Synapse Analytics?** The dynamics of Azure, seamless intergration with all other apps **What do you dislike about Azure Synapse Analytics?** Nothing yet Although the front end could be rebuild again for future **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Customer incide t management ### 13. So far so good **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.) **Reviewed Date:** June 29, 2023 **What do you like best about Azure Synapse Analytics?** Azure Synapse has helped me ease my workload **What do you dislike about Azure Synapse Analytics?** It can be quite overwhelming at times hence it definitely has some learning curve to it. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Sometimes clients do share information which is really hard to comprehend but the use of Azure helps me simplify that ### 14. It was good **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Utilities | Mid-Market (51-1000 emp.) **Reviewed Date:** June 22, 2023 **What do you like best about Azure Synapse Analytics?** I like its scalability and the analytics solution it provides **What do you dislike about Azure Synapse Analytics?** Difficult to manage high volumes of concurrent queries **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Azure synapse successfully integrates analytical services to bring enterprise data warehouse and big data analytics helping me over using Data bricks ### 15. Nice ETL tool with many different integrations **Rating:** 3.5/5.0 stars **Reviewed by:** Tanishq G. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 11, 2022 **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. **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. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** We are using it for EDW solutions, we have also built many pipelines in it for data task. Data is used mainly for reporting which is used in PowerBI, after creating a dataset it again comes back in Synapse allowing users to build reports. It is also used by businesses as it doesn't require downloading any software. ### 16. Supports multiple Resources- ADF, Databricks Notebooks and Warehouse **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Management Consulting | Enterprise (> 1000 emp.) **Reviewed Date:** August 18, 2022 **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. **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. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** I used synapse to handle the polybase-related data transformation through ADF and It has direct connectivity with databricks using JDBC connector so to store a result directly in the warehouse table I used it. It has fast processing and easily supports all applications. ### 17. Decent tool if already working in Azure env **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** April 27, 2023 **What do you like best about Azure Synapse Analytics?** PySpark notebooks and easy connectivity to my Data Lake **What do you dislike about Azure Synapse Analytics?** Time to spin up resources with PySpark notebooks **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Creating Data Science notebooks atop data stored in Azure resources ### 18. Best Distributed Big Data Cloud Computing Platform **Rating:** 5.0/5.0 stars **Reviewed by:** Shubham S. | Lead Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 13, 2022 **What do you like best about Azure Synapse Analytics?** Synapse being a one stop shop for SQL Stored Procedures, Python/ Spark Notebooks, Orchestration Pipeline etc. **What do you dislike about Azure Synapse Analytics?** Not enough telemetry for Notebooks failure and stored procedure logs **Recommendations to others considering Azure Synapse Analytics:** Best tool for big data distributed processing **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Big data processing at large scale along with single pane of glass for ADLS, ADF, Databricks capabilities together ### 19. Azure Synapse Analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** April 05, 2022 **What do you like best about Azure Synapse Analytics?** 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 **What do you dislike about Azure Synapse Analytics?** 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. **Recommendations to others considering Azure Synapse Analytics:** Good product and a must use service. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** From extraction of raw data and loading final transformed data. Azure synapse analytics allows me to perform transformation for big data. Notebook code for data orchestrion. ### 20. Azure SQL DW works great especially when you have an on premise SQL instance as well. **Rating:** 4.5/5.0 stars **Reviewed by:** Scott K. | Director, eCommerce Analytics and Digital Marketing, Mid-Market (51-1000 emp.) **Reviewed Date:** July 16, 2020 **What do you like best about Azure Synapse Analytics?** I love the easy of data transfer between on premise and cloud capabilities. **What do you dislike about Azure Synapse Analytics?** It can be costly if you don't watch your data processes tightly. **Recommendations to others considering Azure Synapse Analytics:** If you are a Microsoft shop already this is a nice fit. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Our SQL users like being able to access the cloud database from their local computers instead of logging on to a virtual machine to get behind a firewall. ### 21. Perfect data orchestration and migration tool **Rating:** 4.5/5.0 stars **Reviewed by:** Shruti J. | Salesforce Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** September 22, 2021 **What do you like best about Azure Synapse Analytics?** Azure synapse analytics helps data migration, data orchestration and helps analyse huge amount of data and supports multiple functionality for petabytes of data at organization level. It supports to create data pipeline which functions like ssis tool but it's cloud version. **What do you dislike about Azure Synapse Analytics?** Sometimes to rectify an error is very difficult. Although it has multiple functionalities still some features are being missed like data flow isn't supported in all regions. **Recommendations to others considering Azure Synapse Analytics:** If you want to migrate data from onprem to cloud using azure environment synapse and it's performance is best. You can analyse petabytes of data within seconds. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** We migtated the client's onprem Oracle data to synapse swl dedicated pool. It took few minutes to run a pipeline to migrate approx 90 tables with billion and million records. ### 22. Cloud based Data warehousing Solution **Rating:** 4.5/5.0 stars **Reviewed by:** Abhishek C. | Senior Technology Architect, Enterprise (> 1000 emp.) **Reviewed Date:** January 15, 2021 **What do you like best about Azure Synapse Analytics?** Supports native SQL and cloud based no code approach to connect systems, create data warehouse and run analytics and reports **What do you dislike about Azure Synapse Analytics?** Challenge implementing outside Azure in a multi cloud environment **Recommendations to others considering Azure Synapse Analytics:** Recommended for storing and analyzing big data for your IT needs **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Ability to generate multiple reports and analyse historical data in landscape ### 23. Synapse - limitless analytics service **Rating:** 4.5/5.0 stars **Reviewed by:** Preeti J. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** June 23, 2021 **What do you like best about Azure Synapse Analytics?** I'm fan of it when we need to do data migration, orchestration - pipeline for ETL/ELT, spark technologies for big data, integration with other services like powerbi ,cosmos db and azure ML or need to use best of sql technologies. **What do you dislike about Azure Synapse Analytics?** Sometimes it doesn't support some of the scenarios or some dataset. Throws some weird errors which sometimes are unable to sort out. **Recommendations to others considering Azure Synapse Analytics:** If You're looking for data migration of heavy database go for it with polybase and manymire functionality which enables you to integrate this with powerbi logicapps etc **What problems is Azure Synapse Analytics solving and how is that benefiting you?** For migrating on prem database to azure and increasing performance on-fly with integration with powerbi and scheduling the pipeline. ### 24. Azure Synapse Analytics helps with data warehousing, integration and business intelligence! **Rating:** 4.5/5.0 stars **Reviewed by:** Anshul J. | Scrum Master, Mid-Market (51-1000 emp.) **Reviewed Date:** June 23, 2021 **What do you like best about Azure Synapse Analytics?** Azure Synapse Analytics helps with providing insights and analytics of stored data which can be used for decision making It gives you the freedom to query data on your terms, using either serverless or dedicated resources at scale **What do you dislike about Azure Synapse Analytics?** Not much they should have a better UI and customer support should be extended to 24*7 **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Azure Synapse Analytics helps with cleansing of our data and make it relevant and its benefitting us with business intelligence and taking informed decisions and make business grow in correct and right direction with the help of insghts we get from analytics of Azure Synapse ### 25. Azure SQL Data Warehouse Review1 **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.) **Reviewed Date:** July 30, 2020 **What do you like best about Azure Synapse Analytics?** Operates as a PaaS with data warehouse features **What do you dislike about Azure Synapse Analytics?** I dislike the cost of the system. Even when not using it they charge you **Recommendations to others considering Azure Synapse Analytics:** Review your market choices. But if you are an Azure or Microsoft client, the migration to Azure SQL Data Warehouse is fairly painless and the level of integration and the breadth of offerings is strong. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Data warehousing without the capital costs and ability to expand resources quickly ### 26. Best Data Warehouse With Great Features! **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** April 23, 2020 **What do you like best about Azure Synapse Analytics?** Really it is very decent software for storing and retrieving data . it is very simple and responsive . it is same as sql server. it is robust and integrated software . it is very secure . l like pAAS and data mining. **What do you dislike about Azure Synapse Analytics?** nothing ! really it is good sometimes it lags when RAM is less. **Recommendations to others considering Azure Synapse Analytics:** Really it is very good TOOL for running queries .so I highly recommend this to everyone **What problems is Azure Synapse Analytics solving and how is that benefiting you?** decent warehouse ever I have used for sql queries I have used for data mining I have used for ETL. ### 27. High volume store of data for different sources integration **Rating:** 5.0/5.0 stars **Reviewed by:** Srini P. | Solutions Consultant - Data Governance- Professional Services, Enterprise (> 1000 emp.) **Reviewed Date:** March 11, 2020 **What do you like best about Azure Synapse Analytics?** I work with implementations where Azure SQL DWH is used and the scalability it provides is best in the market **What do you dislike about Azure Synapse Analytics?** Pricing . The pricing is high considering the open source competitors, **What problems is Azure Synapse Analytics solving and how is that benefiting you?** With Azure SQL DWH I am resolving the scalability issues which I saw with other vendors ### 28. I worked with Azure SQL Data Warehouse for three years **Rating:** 4.0/5.0 stars **Reviewed by:** Sunney S. | Senior Sql Server developer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 15, 2018 **What do you like best about Azure Synapse Analytics?** I like below features of azure sql data warehouse. 1)It support cloud computing. This makes it high availability. 2) It allows to create Virtual machine. It is easy and saves time. 3)Its GUI is simple. It is easy to use. **What do you dislike about Azure Synapse Analytics?** 1) It do not support some features of T-SQL like Error_LIne. 2)It do not provide support for entity framework. 3) The column store tables do not support secondary non-clustered indexes. 4)SQL azure database do not support sql jobs as provided by sql agent . **Recommendations to others considering Azure Synapse Analytics:** If you need 24/7 availability of database with high performance then this is a good choice. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** We have huge data distributed at different locations. It helps us to analyze this data. I consider below benifit's of using azure sql data warehouse. 1) It provides 24/7 availability . 2) It provides lost data by using backups. 3) It provides inbuilt support for optimized performance. ### 29. Can do same work with less money **Rating:** 4.0/5.0 stars **Reviewed by:** Nikunj A. | Solutions Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** November 20, 2018 **What do you like best about Azure Synapse Analytics?** Flexibility, and scalability also dont have to worry about maintaining it can also do schedule maintenance **What do you dislike about Azure Synapse Analytics?** Security still seems like not up to the mark also security and role vould be more simlar to setup and it would have been great if i could setup a securoty based on region **What problems is Azure Synapse Analytics solving and how is that benefiting you?** We can move out all data warehouse to azure and so far i can say it can save you a big amount of money rather doing in house ### 30. Jumpstarts users. Needs improvement but is progressing... **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** August 18, 2018 **What do you like best about Azure Synapse Analytics?** I like how all Azure technologies work side-by-side. Having Azure Storage and Azure Functions setup in our cloud enabled us to deliver solutions to our clients faster. With Azure SQL Data Warehouse, data management becomes a walk in a park in our team. It's easy to use. I feel safe when I'm experimenting with it for the first time. Support is awesome. **What do you dislike about Azure Synapse Analytics?** There is a learning curve to managing data and security. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** With all the confusing configuration and setup, Azure SQL Data Warehouse eliminated all those issues by providing an intuitive and powerful tool for the job. ### 31. Better performance and improved analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** September 17, 2018 **What do you like best about Azure Synapse Analytics?** 1. This is very high in performance and lower in cost. 2. Provides secure cloud data warehouse. 3. This processes huge amount of data even parallel processing. 4. Native connectivity with data integration and visualization. 5. This uses intelligent caching to accelerate the data. 6. Significant query performance improvement. 7. Very good for OLAP environment. 8. Provides Platform as a service cloud based solution. 9. Built in automated database backups. 10. Combines relational data with cloud scale capabilities. **What do you dislike about Azure Synapse Analytics?** Azure data warehouse Supports only 1024 active connections. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** 1. Handled large volume data with massive storage. No storage limit. 2. Performance improvement even for large and complex queries. 3. Reduced dependency on IT team. ### 32. Best data warehouse sofware **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 28, 2018 **What do you like best about Azure Synapse Analytics?** Azure SQL has a high-performance, globally available, and lower-cost secure cloud data warehouse. It has independently scale compute and storage. It has Combine with leading data integration and BI solutions. **What do you dislike about Azure Synapse Analytics?** it can improve the user interface and can adds some more shortcuts. some times its hard to find the right function key. **Recommendations to others considering Azure Synapse Analytics:** It has a high-performance, globally available, and lower-cost secure cloud data warehouse. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** used for independently scale compute and storage. data integration and visualization services ### 33. Azure SQL Data Warehouse is a high-performance, secure tool to storing and accessing data. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** April 24, 2018 **What do you like best about Azure Synapse Analytics?** Azure SQL Data Warehouse has been an amazing tool for our small company. We started collecting data just a few years ago and we were constantly running our of space. We migrated our data to Azure SQL Data warehouse and it had been our best move. We now have unlimited space and access to the data. We now are using the data on a daily basis to help make vital decisions. **What do you dislike about Azure Synapse Analytics?** The set up process was a long and tedious process that was an exhausting experience. I would never want to leave because I would never want to go through the process again. **Recommendations to others considering Azure Synapse Analytics:** Give better assistance with the implementation process of the product. **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Using Azure SQL data warehouse has allowed our organization to have access to the data which has helped us make important business decisions. Also as our business grows Azure can grow with us. We now do not face the problem of running out of storage space. ### 34. Azure SQL DWH is for the future. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Construction | Enterprise (> 1000 emp.) **Reviewed Date:** September 28, 2018 **What do you like best about Azure Synapse Analytics?** SQL Data Warehouse provides a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. **What do you dislike about Azure Synapse Analytics?** The limitation on the number of connections **Recommendations to others considering Azure Synapse Analytics:** It's a perfect solutions **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Trying to build a cloud based system for 3 clients for my org. Really amazed by the product ### 35. Cool product !! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 28, 2018 **What do you like best about Azure Synapse Analytics?** Azure sql is better performance than on Prem version and this anlystics engine is improved lot..security is very much improved **What do you dislike about Azure Synapse Analytics?** Their integrations are more with enterprises products and limitations with open source **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Bi analytics and reports ### 36. Fast and user friendly access to database management and warehousing **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 17, 2018 **What do you like best about Azure Synapse Analytics?** - Auto querying - Good UI - Fast and seamless **What do you dislike about Azure Synapse Analytics?** - It crashes sometimes - Can be a lighter version on the system **What problems is Azure Synapse Analytics solving and how is that benefiting you?** Data warehousing (ETL) SQL Querying ### 37. It's good tool - with limited experience **Rating:** 4.0/5.0 stars **Reviewed by:** Zil S. | Business Analyst/Product Owner, Food & Beverages, Small-Business (50 or fewer emp.) **Reviewed Date:** April 06, 2018 **What do you like best about Azure Synapse Analytics?** It has friendly version like SQL server. **What do you dislike about Azure Synapse Analytics?** The functions are bit complex to understand (at least for me). **What problems is Azure Synapse Analytics solving and how is that benefiting you?** It was regular use as a data warehouse, as such nothing specific/additional requirement ### 38. Very integrated, cover all aspects of data warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Ngoc H. | Business Intelligence Analyst Intern, Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** June 22, 2015 **What do you like best about Azure Synapse Analytics?** integrity, PaaS, Data mining, can use to build a data warehouse from scratch **What do you dislike about Azure Synapse Analytics?** none, very well covered for data warehouse projects **What problems is Azure Synapse Analytics solving and how is that benefiting you?** building data warehouse ## Azure Synapse Analytics Discussions - [Does Azure Synapse include Analysis Services?](https://www.g2.com/discussions/does-azure-synapse-include-analysis-services) - [When should use Azure synapse analytics?](https://www.g2.com/discussions/when-should-use-azure-synapse-analytics) - [What are advantages of Azure synapse analytics?](https://www.g2.com/discussions/what-are-advantages-of-azure-synapse-analytics) - [What is included in Azure synapse analytics?](https://www.g2.com/discussions/what-is-included-in-azure-synapse-analytics) - [View Azure Synapse Analytics pricing details and edition comparison](https://www.g2.com/products/azure-synapse-analytics/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-30+12%3A35%3A08+-0500&secure%5Bsession_id%5D=d1e5197a-bfae-411e-b0ec-8b0f0ada7d02&secure%5Btoken%5D=213c9308ecaeacfc818c6ba8445bb166d0edf57204c9848aebf5e51e2a0b96b8&format=llm_user) ## Azure Synapse Analytics Features **Database** - Real-Time Data Collection - Data Distribution - Data Lake **Data Transformation** - Real-Time Analytics - Data Querying **Integrations** - Hadoop Integration - Spark Integration **Platform** - Machine Scaling - Data Preparation - Spark Integration **Connectivity** - Hadoop Integration - Spark Integration - Multi-Source Analysis - Data Lake **Processing** - Cloud Processing - Workload Processing **Operations** - Data Visualization - Data Workflow - Governed Discovery - Embedded Analytics - Notebooks **Building Reports** - Data Transformation - Data Modeling - WYSIWYG Report Design - Integration APIs **Platform** - Mobile User Support - Customization - User, Role, and Access Management - Internationalization - Sandbox / Test Environments - Performance and Reliability - Breadth of Partner Applications ## Top Azure Synapse Analytics Alternatives - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,147 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (705 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (760 reviews)