Azure CosmosDB - How to get costs report for db account

Yuriy L 1 Reputation point
2021-03-18T11:03:56.997+00:00

I'd like to create a report in the Azure portal that will cumulatively show the following information:

Column names:

DB account
Collection name
Provisioned RU Throughput
RUs price per hour
Monthly cost

Rows must contain values.
Totals should be displayed for column 5 .
Default order by DB column 1 ASC.

I've found standard representation on the CosmosDB account's overview tab. Monthly cost column is missing there.

The solution with calculated monthly costs suits me. For example:

DB account Coll. name Prov RU Throug RUs price per hour Monthly cost
db houses 5000 $0.00012/RU 0.00012*5000*24*30=432

Column 'RUs price per hour' could be hardcoded.

I'd appreciate it very much if somebody could share any thoughts on how I can get this report.
I'd like to place it into a workbook or dashboard.

Thank you.

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,076 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. SadiqhAhmed-MSFT 38,551 Reputation points Microsoft Employee
    2021-03-24T19:16:05.93+00:00

    @Yuriy L Thank you for your post and I apologize for the delayed response.

    Unfortunately, Azure Cost Management doesn't expose Cosmos DB costs down to the container/collection level. This is feature in work with no confirmed ETA.

    The formula to use to convert provisioned throughput into monthly $ costs depends whether you're using autoscale or not.
    For autoscale: <throughput> / 100 * 0.012 * 730
    For manual provisioned throughput: <throughput> / 100 * 0.008 * 730

    Hope this helps!

    ----------------------------------------------------------------------------------------------------------------------

    If the response helped, do "Accept Answer" and up-vote it

    0 comments