Synapse Analytics

on YouTube ↗24m

" summary

Demo of an end-to-end Azure Synapse Analytics pipeline that ties Synapse Link (Cosmos DB operational data indexed to column format) to Spark notebooks, code-free data flows, and embedded Power BI authoring in the Synapse studio. Shows in-engine ONNX scoring via the predict keyword, exposing predictions through a database view and orchestrating retrain jobs with pipelines and triggers. Demonstrates running model scoring over 5 million records in 12 seconds, automatic near‑real‑time data refresh (30–60s), and deploying scheduled retraining and dashboarding that all work inside one managed service.

AI-written summary · about

" chapters (5)

1. 0:00Introduction
2. 2:48Studio
3. 7:25Synapse Link
4. 9:25Predict Keyword
5. 11:39Demo

" related talks

• 54mAn introduction to Azure Synapse Analytics!Mahesh Balija · SQLBits 2020
• 53mAzure Synapse Analytics: Evolving Azure SQL Data WarehouseMark Pryce-Maher, Artur Vieira · SQLBits 2020
• 51mSupercharge Power BI with Azure Synapse AnalyticsMathias Halkjaer · SQLBits 2023
• 49mHow to start with Azure Synapse Analytics - Power BI Developer EditionWolfgang Strasser · Power Platform Virtual Conference 2021
• 46mThe Ultimate Jigsaw - Architecting Azure Synapse AnalyticsHeini Ilmarinen · Women Data Summit 2021
• 49mAzure Synapse AnalyticsJames Serra · SQLBits 2020
• 23mSynapse Link to SQL, bring your on-prem data aliveJosé Barbosa · SQLBits 2022
• 28mArchitecture patterns of Azure Cosmos DB & Azure Synapse AnalyticsHiroyuki Nakazato · Azure Cosmos DB Conf 2022