3

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?

Artanis
  • 561
  • 1
  • 7
  • 26
  • Possible duplicate of [Get record count in Azure DocumentDb](https://stackoverflow.com/questions/27745346/get-record-count-in-azure-documentdb) – Sajeetharan Apr 17 '19 at 15:26
  • answers from that link: "SELECT COUNT(c.id) FROM c" , "SELECT VALUE COUNT(1) FROM c" – Artanis Apr 17 '19 at 19:35

1 Answers1

2

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.

Jim Wartnick
  • 1,974
  • 1
  • 9
  • 19