Azure Synapse Analytics: Evolving Azure SQL Data Warehouse
summary
Live demo of Azure Synapse shows a unified platform built on a data lake with Azure Data Factory integration, a provisioned MPP engine (provisioned SQL pool), a pay-per-query engine (serverless SQL on-demand), and a managed Spark service (Spark 2.4 with Delta Lake). Synapse Studio ties them together (Synapse Studio): create workspaces, attach storage and Power BI, spin up spark pools (cold start ~3–4 minutes, warm runs ~3s), auto-pause/scale, create external tables (PolyBase) and query file metadata fast.
AI-written summary · about
chapters (25)
- 0:00Introduction
- 2:00Azure Synapse Analytics
- 6:13Azure Synapse Analytics Preview
- 12:03Create a SQL Data Warehouse
- 14:59Create Spark Pool
- 16:47Synapse Studio
- 19:53Power BI
- 20:38Storage Account
- 21:18Interactive Ordering
- 26:22Using SQL
- 30:07Dynamic SQL
- 31:27Metadata
- 38:17Running the query
- 38:47Rewriting the query
- 40:22Pipeline
- 41:07Notebook to Pipeline
- 41:47Spark
- 42:37SQL Script
- 43:17Managing SQL Pools
- 44:17Linking Services
- 44:47Spark Demo
- 46:37SQL Analytics Demo
- 47:02Behind the Scenes
- 48:57Monitoring
- 50:17Recap
related talks
46mThe Ultimate Jigsaw - Architecting Azure Synapse Analytics
49mHow to start with Azure Synapse Analytics - Power BI Developer Edition
51mSupercharge Power BI with Azure Synapse Analytics
55mAzure SQL database, Azure Synapse Analytics, Azure Databricks?
24mSynapse Analytics
58mAzure Data Lake & Synapse Server less Architecture
52mConnect your data artifacts with Azure Synapse Analytics and Azure Purview
40mData Lake House in the Cloud: The Azure Solutions