Lab
A Cloud Guru

Partition Data in Azure Synapse Analytics

In this hands-on lab, you will learn how to provision a Data Synapse Analytics workspace, work with data flows, create and trigger data pipelines, and partition data as data is migrated. The skills learned in this lab are very frequently used by data engineers and data architects. This lab will also touch on critical skills found on the DP-203 exam.

Try for free Contact sales

Path Info

Level

Intermediate

Duration

30m

Published

Nov 10, 2023

Challenge

Prepare the Environment

Create a Synapse Analytics instance in the West US region. It should utilize a new Data Lake Storage Gen 2 account.
Challenge

Create a Data Flow in Azure Synapse Analytics
1. Create a data flow that utilizes the Bing COVID-19 sample dataset. This data flow should migrate the data to your newly created data lake.
2. The data flow should create 5 round-robin partitions.
Challenge

Create a Data Pipeline in Azure Synapse Analytics

Create a data pipeline that includes the newly created data flow.
Challenge

Run the Data Pipeline and Verify Partitioning

Verify and run the data pipeline using Trigger Now. Finish the objective by verifying the partitioning was created correctly.

Author

A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.