DP-203: 27 - Azure Synapse Analytics: Overview, Pipelines

Hey data engineers! Let's discuss yet another service for data ingestion - Azure Synapse Analytics, which was promoted as the "one-stop shop for all your data engineering and analytics needs". Join me in the 27th episode of my free DP-203 course where I cover the following topics: • What exactly is Azure Synapse Analytics? • Which component of Synapse is suitable for data ingestion, and how does it compare to ADF? • How to ingest data from a REST API and what does a Lego minifig have to do with it? Enjoy! ▬▬▬▬▬▬ IMPORTANT LINKS ▬▬▬▬▬▬ My LinkedIn profile: https://www.linkedin.com/in/piotr-tybulewicz-81a8793/ GitHub with my drawings: https://github.com/TybulOnAzure/DP-203 "Is Synapse Dead" by Paul Andrew? https://mrpaulandrew.com/2024/02/04/is-azure-synapse-analytics-dead-and-does-it-really-matter/ ADF vs Synapse Pipelines: https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences ▬▬▬▬▬▬ MEMBERSHIP ▬▬▬▬▬▬ Join this channel to get access to perks: https://www.youtube.com/channel/UCLnXq-Fr-6rAsCitq9nYiGg/join ▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬ 00:00 Introduction 00:35 What is Synapse Analytics? 06:38 DP-203 vs Microsoft Fabric 08:34 Provisioning Synapse workspace 13:48 Scenario for today 24:05 Ingesting data from Rebrickable 1:06:11 Summary