DP-203: 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