Shred JSON in Azure

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

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

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" }
        ]
    }
}';

Shred the JSON to display where id=1.