Issue with cosmosDB AzureDiagnostics query

Question

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

Answer 1

@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

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.