Query: cosmosdb_account_failover_policy

select
  f ->> 'failoverPriority' as "Failover Priority",
  f ->> 'locationName' as "Location"
from
  azure_cosmosdb_account,
  jsonb_array_elements(failover_policies) f
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);