Azure Synapse Analytics
(Azure SQL Data
November 28, 2020 by Meenal Sarda Leave a Comment
Azure Synapse Analytics is the latest enhancement of the Azure SQL Data
Warehouse that promises to bridge the gap between data lakes and data
In this blog, we are going to cover everything about Azure Synapse Analytics
and the steps to create a Synapse Analytics Instance using the Azure portal.
Before we get a better understanding of Azure Synapse, we need to know
what Azure SQL Data Warehouse is!
Azure SQL Data Warehouse
Azure SQL Data Warehouse was released by Microsoft as Gen 1 in 2016,
and Gen 2 in 2018, as a first-rate cloud-native OLAP data warehouse. It is a
managed service having controls to manage computing and storage
independently. Along with flexibility around compute workload elasticity, it
also provides the facility to the users to pause the compute layer while
persisting the data to reduce costs in the pay-as-you-go environment.
Also read: Azure SQL Database is evergreen, meaning it does not need to
be patched or upgraded, and it has a solid track record of innovation and
reliability for mission-critical workloads.
What is Azure Synapse
Azure Synapse Analytics is a scalable and cloud-based data warehousing
solution from Microsoft. It is the next iteration of the Azure SQL data
It provides a unified environment by combining the data warehouse of SQL,
the big data analytics capabilities of Spark, and data integration
technologies to ease the movement of data between both, and from external
Join Over 140k
Subscribers to get
FREE Tips, How-To's,
and Latest Information
on Cloud Technologies
data sources. We can ingest, prepare, manage, and serve data for
immediate BI and machine learning needs easily with Azure Synapse
Read this: Azure Event Hubs streamline your data pipelines for you.
Azure Synapse Architecture
Azure Synapse architecture consists of four components:
Synapse SQL: Complete T-SQL based analytics