Azure Data Lake & Synapse Server less Architecture
summary
Shows a live demo that creates an Azure Data Lake Gen2 workspace, uses the built‑in serverless SQL pool to query CSV, Parquet and JSON files, and builds external tables and views over the lake. Connects a pipeline (copy activity) and a Power BI integration dataset, demonstrates pausing/resizing compute, and notes serverless queries take ~11s in the demo while dedicated pools return results faster. Claims cost examples (~$5/TB storage, charged-per‑query or per‑hour compute) and the setup works end‑to‑end.
AI-written summary · about
chapters (33)
- 0:00Introduction
- 4:50What is Synapse
- 8:52Dedicated Synapse Architecture
- 10:18Synapse Architecture
- 14:08Distribution Components
- 15:11Synapse Serverless
- 20:13Default Serverless
- 20:56Benefits
- 23:20Data Lake
- 25:40Best Practices
- 28:04Demo
- 34:01Pocket File
- 34:31Performance
- 36:11Get Data
- 38:21Add Columns
- 41:01Run Query
- 41:21Simple Query
- 41:41Bulk Query
- 42:06Database
- 42:41Data Source
- 44:01Call Data Set
- 44:56Query Data Set
- 45:26Query Pocket Files
- 46:16csv
- 48:01small detail
- 48:31what you want
- 49:21external table
- 51:06pipeline
- 51:41if condition
- 52:06what it does
- 53:16serverless pool
- 53:36link services
- 54:31Connect to Synapse
related talks
49mAzure Synapse Analytics
53mAzure Synapse Analytics: Evolving Azure SQL Data Warehouse
40mData Lake House in the Cloud: The Azure Solutions
51mSupercharge Power BI with Azure Synapse Analytics
54mAn introduction to Azure Synapse Analytics!
50mPower BI + Azure Synapse Analytics: Beginning your journey
30mProcess large-scale data and computational function in serverless manner
49mHow to start with Azure Synapse Analytics - Power BI Developer Edition