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 ▬▬▬▬▬▬

▬▬▬▬▬▬ MEMBERSHIP ▬▬▬▬▬▬
Join this channel to get access to perks:

▬▬▬▬▬▬ 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

[prabhuraghupathi]

Its really a brief introduction to Synapse Analytics and great content to learn !! thanks Tybul!!

[othmane]

Was waiting for the synapse analytics part👍
Thanks

[soumikmishra]

This was amazing and fun session to follow along. Thanks a ton for providing such informative content sir!! I had the same question of dynamic API in keyvault but i checked the comments, its been covered. Thanks again. On to the next one.!!

[fekasng]

much awaited episode have fianlly landed .Thank you very much and remain bless..Please sir, are you going to cover streaming in this series.

[lukaszk]

i actually wanted to skip this episode because I thought that as synapse will be retired at some point in the future will not be needed to know but actually concepts revolves around data factory concepts that every data engineer must know . great video! thanks Tybul

[shilpajbabu]

Great video! Thanks for posting this ! Easily understandable.. I have a question- how to to store the secrets in the key vault dynamically if they need to be generated after a 24hr period

[jakubdurawa]

Hi Piotr, i believe this is the best video of whole series. Data ingestion process was explained so easily. Thanks a lot.

I have a question if i won’t add statement that we shouldnt take pages with null value in “Next” is it possible that we will be trying to ingest multiple null values forever?

[heljava]

Thank you. Will this playlist have content about Stream Analytics and Purview?

[SAJO]

What is your own opinion now about shifting to fabric rather than synapse?
Also, do you recommend taking DP-203 or moving to DP-600 instead (from different perspective aspects)?

[amazhobner]

Excellent video, after the test for viewers episode will you be covering spark/databricks? If possible can you tell what all things will be covered in it?

Ik this is a dp203 playlist but if you can cover just a bit more than what's in certification like say pyspark I think it'll be really helpful for people looking to go in data engineering role. Saying this because the way you teach, the flow, the quality, ease to understand, everything is just phenomenal and you are a very gifted teacher, so leaning from you is a blessing hence want to learn as much as we can from you 😄😄

[omarouaissi_sekouti]

If Azure Synapse is (or will soon be) dead (not much used), why is the DP-203 exam so heavily focused on it?

[omarouaissi_sekouti]

I have a question for students :
How can I get a free Azure account? I had one, but after one month, I couldn't use it anymore because my subscription was disabled.