Query: cosmosdb_account_input

select
  a.title as label,
  lower(a.id) as value,
  json_build_object(
    'subscription',
    sub.display_name,
    'resource_group',
    a.resource_group,
    'region',
    a.region
  ) as tags
from
  azure_cosmosdb_account as a,
  azure_subscription as sub
where
  lower(a.subscription_id) = lower(sub.subscription_id)
order by
  a.title;