Get record count in Azure DocumentDb

This is possible in the same way you write SQL query now,

SELECT VALUE COUNT(1) FROM myCollection

enter image description here

NOTE: COUNT(1) won't work for a huge datasets.

You can read more about supported queries from here

Actually works at this point:

SELECT COUNT(c.id) FROM c

This is now possible in the year 2017 of our lord.

SELECT VALUE COUNT(1) FROM c

[ 1234 ]

Related