Azure Data Engineer Exercise - Build a pipeline in Azure Synapse Analytics
This video demonstrates the use of Azure Synapse Studio via the Azure Portal to work with data pipelines in Azure Synapse Analytics.
Microsoft Learn Exercise Link: https://microsoftlearning.github.io/d...
Note about costs: This lab cost $3.23 to complete according to the Cost analysis (preview) page on my Azure Portal.
This is just one exercise of dozens that may be required to complete a certification such as the DP-203. Paying for these on your own can add up quickly.
Contents
00:00 Intro
00:32 Provision an Azure Synapse Analytics workspace
06:00 View source and destination data stores
12:10 Implement a pipeline
12:43 Create a pipeline with a data flow activity
15:07 Configure the data flow
15:45 Add sources
22:30 Add a Lookup
24:49 Add an Alter Row
27:10 Add a sink
31:05 Debug the Data Flow
33:01 Publish and run the pipeline
35:53 Delete Azure resources