Cloud data simplified: a great all-in-one tool for all your data analytics needs
December 20, 2022
Cloud data simplified: a great all-in-one tool for all your data analytics needs
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Azure Synapse Analytics (Azure SQL Data Warehouse)
Our data warehouse was growing at a 1TB/year rate, and we needed a solution that would be both cheap and effective.
Previously we were using Azure SQL Database with its JSON capabilities and various Azure serverless services to manage our data, but at that growth rate, time and cost were becoming limiting factors.
Previously we were using Azure SQL Database with its JSON capabilities and various Azure serverless services to manage our data, but at that growth rate, time and cost were becoming limiting factors.
- Build, schedule and monitor complex data pipelines (Azure Data Factory component)
- Access your data lake using the familiar T-SQL syntax and TDS-enabled tools (SSMS, ADS, ...). This is especially useful for business people that are used to a specific workflow.
- Support a wide range of data transformation tools, from low-code (DataFlows) to full-code (Spark), all integrated in a single central orchestrator (Azure Data Factory-like)
- Provide all these services as a single very convenient package, without the need to know beforehand all the configuration behind
- There's no support for Synapse Serverless objects (e.g., views) in SSDT - the VCS-friendly approach to schema deployments from Microsoft. SSDT is available for almost all other SQL Server and Azure SQL products, including Synapse Dedicated SQL Pools.
- There are lots of ways to accomplish the same task, and it's not very clear which one is best suited for a given scenario other than trial and error. Also, some scenarios (e.g., efficient management of late arrivals) don't have a clear solution path.
- I think it would be cool to have a tighter integration of the product with the Azure Data Studio client, not only for connecting to SQL Serverless or Dedicated Pools. For example, PySpark development and debugging would be much easier if done from ADS.
- Synapse Serverless Pools
- Pipeline orchestration (Azure Data Factory-style)
- PySpark support
- Reduce operative costs by switching from VLDB on Azure SQL to a data lake architecture
- Improve data reliability by providing timely monitoring and alerting
They're all part of the Microsoft Azure family, so they are not exactly competitors. They overlap in functionality, but they're targeted at different levels of customers.
Azure Data Factory is an excellent stand-alone PaaS (included in Synapse Analytics) for writing, scheduling, and monitoring pipelines.
Azure SQL Database (and all the Azure SQL family) is excellent for traditional, SQL-based data warehouses, especially if you're migrating from on-premises. Combined with Azure Data Factory (that can run SSIS packages), it's a perfect solution for a simple path to the cloud.
Azure Databricks is effectively the only internal "competitor" to Synapse Analytics but targeted more to a "platform-agnostic" audience. On the other hand, Synapse is more of a proprietary mix of products that are more tightly related to Microsoft technologies.
Azure Data Factory is an excellent stand-alone PaaS (included in Synapse Analytics) for writing, scheduling, and monitoring pipelines.
Azure SQL Database (and all the Azure SQL family) is excellent for traditional, SQL-based data warehouses, especially if you're migrating from on-premises. Combined with Azure Data Factory (that can run SSIS packages), it's a perfect solution for a simple path to the cloud.
Azure Databricks is effectively the only internal "competitor" to Synapse Analytics but targeted more to a "platform-agnostic" audience. On the other hand, Synapse is more of a proprietary mix of products that are more tightly related to Microsoft technologies.
Do you think Azure Synapse Analytics delivers good value for the price?
Yes
Are you happy with Azure Synapse Analytics's feature set?
Yes
Did Azure Synapse Analytics live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of Azure Synapse Analytics go as expected?
Yes
Would you buy Azure Synapse Analytics again?
Yes