The Ultimate Jigsaw - Architecting Azure Synapse Analytics
summary
Azure Synapse maps as a workspace backed by Azure Data Lake Storage, pipelines (ADF codebase) and three engines: serverless SQL pool for ad hoc queries over files, Spark pools for Python notebooks and transformations, and a dedicated SQL pool (the old MPP data warehouse) for serving star schemas. Secure options include a managed workspace VNet with managed private endpoints plus a Synapse Private Link Hub when UI must stay private. Example builds: ingest to ADLS via pipelines, explore with serverless SQL, transform in Spark, load to dedicated SQL and report with Power BI — a working, end-to-end pattern.
AI-written summary · about
chapters (25)
- 0:00Start
- 2:50Overview of Azure Synapse Analytics
- 4:52Overview of Azure Synapse Analytics
- 5:44Phases of a Data Project
- 7:09Transformation
- 7:24Transformations
- 8:31Azure Synapse Analytics
- 10:10The Management Layer
- 13:58Sequel Pools
- 15:14Dedicated Sequel Pools
- 15:36Dedicated Sql Pool
- 16:52Apospark Pools
- 20:16Secure Azure Synapse Analytics
- 22:00Networking
- 27:57Access Control
- 28:49Azure Rbac
- 31:01The Azure Synapse Workspace Roles
- 31:26Workspace Admin Role
- 31:44Workspace Admin
- 33:20How Do We Really Use Azure Synapse Analytics
- 34:31Sample Scenario
- 35:43Workflow of the Project
- 39:19Power Bi
- 44:41Plan Your Architecture
- 45:12Take the First Step
related talks
54mAn introduction to Azure Synapse Analytics!
53mAzure Synapse Analytics: Evolving Azure SQL Data Warehouse
52mConnect your data artifacts with Azure Synapse Analytics and Azure Purview
49mAzure Synapse Analytics
51mSupercharge Power BI with Azure Synapse Analytics
50mPower BI + Azure Synapse Analytics: Beginning your journey
55mAzure SQL database, Azure Synapse Analytics, Azure Databricks?
24mSynapse Analytics