Scribd
Upload
77 views22 pages

Azure Synpase Analytics Service

The document discusses Azure Synapse Analytics, a next generation cloud data warehousing service. It provides advantages of cloud warehousing like scalability, no hardware maintenance, and time to market benefits. Synapse Analytics is described as a game changer, blending big data analytics, data warehousing, and integration into a single service with limitless scale. Traditional and modern data warehouse architectures are compared to the Synapse Analytics architecture. A demo is provided on provisioning a Synapse SQL pool, pausing/resuming compute nodes, and creating firewall rules in the unified Synapse Studio experience.

Uploaded by

reliable business
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
77 views22 pages

Azure Synpase Analytics Service

The document discusses Azure Synapse Analytics, a next generation cloud data warehousing service. It provides advantages of cloud warehousing like scalability, no hardware maintenance, and time to market benefits. Synapse Analytics is described as a game changer, blending big data analytics, data warehousing, and integration into a single service with limitless scale. Traditional and modern data warehouse architectures are compared to the Synapse Analytics architecture. A demo is provided on provisioning a Synapse SQL pool, pausing/resuming compute nodes, and creating firewall rules in the unified Synapse Studio experience.

Uploaded by

reliable business
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 22

Eshant Garg

Data Engineer, Architect, Advisor


eshant.garg@gmail.com
Introduction

Why Warehousing in Cloud


Azure Synapse Service – a Game Changer
Traditional vs Modern DW Architecture
Modern vs Synapse DW Architecture
Azure Synapse Studio – Unified Experience
Demo – Provision, Scale, Pause, Firewall settings
Why Warehousing in Cloud?

No large
capital
expense
No
Time to hardware
market maintenan
ce

Benefits of
Cloud DW
MPP Scalability

Integration
with other Cost
services
Source: Microsoft
Source: Microsoft
Source: Microsoft
Azure SQL Data warehouse

•Generation 1
2018 •Generation 3
(Azure SQL (Azure Synapse
•Generation 2
Data Analytics)
(Azure SQL
Warehouse)
Data
Warehouse)
2015 2019
"Synapse is the next generation of Azure SQL Data Warehouse, blending big
data analytics, data warehousing, and data integration into a single unified
service that provides end-to-end analytics with limitless scale."
Azure Synapse Analytics

Source: Microsoft
Azure Synapse Analytics

Source: Microsoft
Unparalleled price-performance

Up to 14x faster
Costs 94% less than other cloud providers
Azure Synapse Analytics

Source:Microsoft
Source: Microsoft
Azure Synapse Analytics

Powerful Insight Unified Experience


Limitless Scale

Security Code free data Choice of Language


orchestration

Source: Microsoft
Modern vs Synapse Architecture

Modern Data Warehouse Architecture Synapse Analytics Architecture

Source: Microsoft
Source: Microsoft
Source: Microsoft
Source: Microsoft
Demo – Provision Azure Synapse Service

1. Create SQL Server


2. Create Synapse SQL Pool (Azure SQL Data Warehouse)
3. Pause/Resume Compute Node
4. Create Firewall Rule
5. Connect with Microsoft SQL Server Management Studio
Azure Synapse Analytics

Source: Microsoft
Azure Synapse Analytics
Unified experience for all data professionals

Data Engineer

IT
Data Scientist
Professionals

Business Database
Analysts Administrator
Summary
Advantages of Cloud Warehousing
Synapse Analytics - advantages
Why Synapse Analytics is Game changer in Cloud Analytics
Traditional vs Modern DW Architecture
Modern vs Synapse DW Architecture
Synapse Studio – Unified experience
Demo – Provision, Pause, Scale, Firewall settings etc.

You might also like