Query: cosmosdb_mongo_database_account_details

select
  a.name as "Name",
  a.kind as "Kind",
  a.server_version as "Server Version",
  database_account_offer_type as "Offer Type",
  a.id as "ID",
  lower(a.id) as lower_id
from
  azure_cosmosdb_mongo_database d,
  azure_cosmosdb_account as a
where
  d.resource_group = a.resource_group
  and d.subscription_id = a.subscription_id
  and account_name = a.name
  and lower(d.id) = $1;