Query: compute_virtual_machine_tags

select
  tag.key as "Key",
  tag.value as "Value"
from
  azure_compute_virtual_machine,
  jsonb_each_text(tags) as tag
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3)
order by
  tag.key;