Azure Synapse is an integrated analytics service that accelerates time to insight across data warehouses and big data systems
Azure Synapse provides an out-of-the-box solution designed to accelerate time-to-insight and empower business agility. Azure Synapse is the only end-to-end platform that unifies data ingestion, big data analytics, and data warehousing.
It offers turnkey setup and configuration options on fully managed infrastructure to help you get results fast. It offers greater control and flexibility in terms of pricing by enabling you to choose the best pricing option for each workload with both serverless and dedicated options.
Since its preview announcement, Microsoft have documented incredible excitement and adoption of Azure Synapse.
Azure Synapse unifies data integration, enterprise data warehousing, and big data analytics—at cloud scale. Bringing together these workloads allows ISVs to reduce development time and accelerate insight. Azure Synapse also provides both no-code and code-first experiences for critical tasks E.G data ingestion, preparation, and transformation.
The management and monitoring of ISV analytics system is made easier. Teams can secure their entire analytics system and prevent data exfiltration by simply selecting the managed virtual network feature when creating a Synapse workspace. Giving ISVs valuable time back to their teams.
Microsoft have also rearchitected and created the a new generation of query processing engine and data management with the new cloud-native, distributed SQL engine which powers Azure Synapse. It can scale from queries on a handful of cores to thousands of nodes—all depending on your workload needs.
By deeply integrating Apache Spark and its new SQL engine, Azure Synapse enables a level of productivity and collaboration for ISVs that wasn’t possible until now. Azure Synapse also supports a variety of popular languages including; T-SQL, Python, Scala, and Java.
The new flexible service model for query processing allows data teams to use both serverless and dedicated options. ISVs can now choose the most cost-effective option for each use case—enjoying the advantages of a data lake for quick data exploration with pay-per-query pricing and/or a dedicated data warehouse for more predictable and mission-critical workloads.
Azure Synapse is also deeply integrated with Microsoft Power BI and Azure Machine Learning.
Power BI is integrated in the Synapse Studio. This means that BI professionals can work in the same service that houses data pipelines, data lakes, and data warehouses. Therefore, reducing the amount of time required to access, clean and secure data for dashboards. Additionally, the new Power BI performance accelerator for Azure Synapse automates the creation and optimization of materialized views with just a few clicks.
For predictive analytics, ISVs can deploy machine learning models from the Azure Machine Learning model registry directly to Azure Synapse using a simple, guided user experience. The in-engine ML scoring can generate millions of predictions in seconds all while maintaining full data security as data doesn’t leave the platform. And with AutoML, all data teams—even those without highly trained data scientists—can automatically apply machine learning models to their data and generate predictive insights.
The code-free and programmatic integration—including CI/CD support with Git integration—enables seamless version control, collaboration, and code management between data engineers, data scientists, and BI professionals, allowing them to be highly productive across a variety of use cases.
Want to learn more?
Join our upcoming webinar!