Query: compute_virtual_machine_scale_set_data_disks

select
  disk ->> 'caching' as "Caching",
  disk ->> 'createOption' as "Create Option",
  disk ->> 'diskSizeGB' as "Disk Size (GB)",
  disk ->> 'lun' as "Logical Unit Number",
  disk -> 'managedDisk' ->> 'storageAccountType' as "Storage Account Type",
  (disk -> 'writeAcceleratorEnabled')::boolean as "Write Accelerator Enabled"
from
  azure_compute_virtual_machine_scale_set,
  jsonb_array_elements(virtual_machine_storage_profile -> 'dataDisks') as disk
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);