I want to store below json data to azure table.

[
  {
    "device1": [
      {
        "name": "temperature",
        "value": 50
      },
      "name": "voltage",
      "value": 220
    }
  ],
  "device2": [
    {
      "name": "temperature",
      "value": 10
    },
    "name": "voltage",
    "value": 200
  }
]
}
]

final result would look like below image

I tried with simple json formate

  [{
    "messageId": messageId,
    "name": "temperature"
   }]



SELECT
    i.messageId AS messageId,
    i.name AS name,
    i.PartitionId,
    i.EventProcessedUtcTime,
    i.EventEnqueuedUtcTime
INTO
    [table]
FROM
    [input] i
    

But for nested and dynamic key data i am confused.