Query: compute_virtual_machine_data_disks

select
  disk ->> 'name' as "Name",
  disk ->> 'caching' as "Caching",
  disk ->> 'createOption' as "Create Option",
  (disk ->> 'toBeDetached') :: boolean as "To Be Detached",
  (disk ->> 'writeAcceleratorEnabled') :: boolean as "Write Accelerator Enabled",
  lower(disk -> 'managedDisk' ->> 'id') as "Managed Disk ID"
from
  azure_compute_virtual_machine,
  jsonb_array_elements(data_disks) as disk
where
  lower(id) = $1;