Issue with cosmosDB AzureDiagnostics query

H Mahida 21 Reputation points
2021-01-15T21:03:23.527+00:00

I am performing AzureDiagnostics query for cosmosDB and getting the below error.

' operator: Failed to resolve table or column or scalar expression named 'requestCharge_s'

If issue persists, please open a support ticket. Request id: 11cf0dd1-2183-4a50-be12-XXXXXXXX

Query: (24hrs RU usage)

AzureDiagnostics
| where TimeGenerated >= ago(24hr)
| where Category == "DataPlaneRequests"
//| where collectionName_s == "CollectionToAnalyze" //Replace to target the query to a collection
| summarize ConsumedRUsPerMinute = sum(todouble(requestCharge_s)) by collectionName_s, _ResourceId, bin(TimeGenerated, 1m)
| project TimeGenerated, ConsumedRUsPerMinute, collectionName_s, _ResourceId
| render timechart

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,469 questions
0 comments No comments
{count} votes

Accepted answer
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-01-18T04:30:42.82+00:00

    @H Mahida Thank you for reaching out.
    Platform metrics and logs collection is not enabled by default.

    On the Azure portal, from your Cosmos DB account page, use the Diagnostic settings blade and Add the diagnostic setting.
    You will be able to choose the logs you want to monitor and send them to a Log Analytics workspace for analysis

    57404-image.png

    Once you have the logs, you can run the diagnostic queries.

    Please let me know if you have further questions.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful