Query: cosmosdb_mongo_database_collection_count

select
  'Collections' as label,
  count(*) as value
from
  azure_cosmosdb_mongo_database d,
  azure_cosmosdb_mongo_collection c
where
  lower(d.id) = $1
  and c.database_name = d.name
  and d.subscription_id = split_part($1, '/', 3);