Data Engineering on Microsoft Azure - Azure for DE: 47 - Azure Synapse Analytics - Serverless SQL Pool

Hey data engineers! We've all seen the modern data warehouse architecture that uses Dedicated SQL Pool for storing data and serving it to consumers. But do we really need another copy of the data? What if we could just use the lakehouse approach? Well, we can! The key component for this is the Serverless SQL Pool available in Azure Synapse Analytics. Join me in the 47th episode of my free DP-203 course, where I discuss Serverless SQL Pool and highlight three main use cases where it proves useful. Enjoy! ▬▬▬▬▬▬ IMPORTANT LINKS ▬▬▬▬▬▬ My LinkedIn profile: https://www.linkedin.com/in/piotr-tybulewicz-81a8793/ GitHub with my drawings: https://github.com/TybulOnAzure/DP-203 Query Delta Lake with Serverless: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-delta-lake-format OPENROWSET function: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset Accessing external storage: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview?tabs=impersonation Setup script: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-delta-lake-format#data-source-usage ▬▬▬▬▬▬ MEMBERSHIP ▬▬▬▬▬▬ Join this channel to get access to perks: https://www.youtube.com/channel/UCLnXq-Fr-6rAsCitq9nYiGg/join ▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬ 00:00 Introduction 00:47 Synapse components 04:19 What "serverless" means? 08:16 Use case 1: ad-hoc data exploration 28:05 Use case 2: logical data warehouse 50:47 Use case 3: quick transformations 58:00 Summary