I am trying to reason about what would be a realistic estimate of a cost for SUM aggregate within same logical partition that contains up to a few hundred thousands of documents each being up to 5kb size where query would do SUM of a single day data.

for example, a container has documents for lets say orders. each document has property amount and date.

i am wondering what might be the cost of query like:

select SUM(c.amount) where c.date =someDate ? (again, all documents are in same logical partition)

could someone post a practial example?

CodePudding user response：

You can try the CosmosDB RU calculator for this case to get a rough estimation. Since you're about to perform Point Reads the RU charges will be minimal.

Regarding the sample dataset, download a dataset from Kaggle and insert to Cosmosdb using the Data Migration Tool.