Azure Synapse Series1: Demystifying The Power Of Azure Synapse Analytics

A cloud-based integrated analytics service that brings together big data and data warehousing.

With the increased demand for big data processing Azure Synapse helps us to bring spark, SQL, azure data factory and Azure data bricks all together at a common workspace called as Azure Synapse Analytics Workspace.

Before my readers get loaded with a lot of questions on Synapse. Hold on!!! Let’s understand more details on synapse it works, how we query data, how data is stored etc.…

• Similar to how we create other services in Azure same way just goes for creating the synapse workspace.
• While creating the synapse workspace we have to provide gen2 details so while creating the workspace we have the storage as well.
• Synapse storage will be the same as the Azure storage account.

Types of workload in azure synapse

1. Synapse pipeline(ADF): Synapse pipeline is the same as Azure data factory just here the pipeline will be in Synapse workspace.
2. Synapse spark(Notebook + Monitoring): Synapse spark provides a facility to deal with big data processing.
3. SQL Pool(Serverless/Built-in & Dedicated): We can query our data using SQL Pool.