Table of Contents

1. Challenge

   Create the Resources Needed for the Lab

   1. Create a Synapse Analytics workspace:

      • in West US region
      • Create a new Azure Data Lake Storage Gen2
      • Utilize an SQL Server admin login

   2. Create an SQL Database instance and server:

      • All in West US region
      • Basic tier
      • Make sure to choose sample data as the data source
2. Challenge

   Create the Linked Service and Datasets

   In Azure Synapse Analytics:

   1. Create a linked service for your Azure SQL Database.
   2. Create a dataset for the customer table in your Azure SQL Database.
   3. Create a dataset for the sales order detail table in your Azure SQL Database.
   4. Create a linked service for your Azure Blob Storage customer container.
   5. Create a dataset for your Azure Blob Storage target folder.
3. Challenge

   Create the Data Pipeline

   1. Two ingestion activities (one for each dataset). Source and sink will be completed in the next objective.
   2. Make sure that one only kicks off upon success of the other.
   3. On failure of either activity, make sure to create a Get MetaData activity using a new created database.
      • Save to Customer table in SQL DB.
      • For fields, capture column count only.
4. Challenge

   Create a Failure Alert and Run the Pipeline

   Run the completed pipeline.