azure-cosmosdbazure-cosmosdb-sqlapiazure-cosmosdb-cassandra-api

Can I get the count of all records in a Cosmos DB table for a large amount of records?


Assuming I have approximately 10 million documents in a Cosmos DB SQL table, or 10 million collections in a Cosmos DB Cassandra table, is there any way to view the amount of documents/collections in those tables?


Solution

  • If you use data explorer, you can either count them with the count() function or select the id without any filters. That will cost you X RUs though, so be aware of that.