Table of Contents

1. Challenge

   Prepare the Environment

   Create a Synapse Analytics workspace in the West US region. Utilize a SQL Server admin login.

2. Challenge

   Create a Dedicated Pool and a SQL Query

   1. Create a dedicated pool (DW100c).
   2. Create a new SQL query.
3. Challenge

   Create and Populate a New Table

   1. Create a new table called "PieStore1" with four columns (id, name, price, sweet).

   2. Populate that table with this data:

   DECLARE @json NVARCHAR(4000) = N'{ 
       "pies" : {
               "sweet" : [
               { "id" : 1, "name" : "Cherry", "price" : "3.50" },
               { "id" : 2, "name" : "Chocolate", "price" : "4.99" },
               { "id" : 3, "name" : "Pumpkin", "price" : "4.00" }
           ],
               "savory" : [
               { "name" : "Meat", "price" : "6.00" },
               { "name" : "Chicken", "price" : "5.00" },
               { "name" : "Veggie", "price" : "4.00" }
           ]
       }
   }';
   

4. Challenge

   Shred the JSON

   Shred the JSON to display where id=1.