Datadog Connector for Metrics only Ingest Metadata instead of Actual Metrics

[mengying-braintrust]

Hi, I set up the datadog connector but it only ingested the metadata of individual metric aka I have a table of one metric per row without the actual value. I would like to ingest for example a metric by org id. This is my current set up

{
 "name": "Datadog",
 "workspaceId": "xxxxx",
 "definitionId": "xxxx",
 "configuration": {
   "site": "us5.datadoghq.com",
   "api_key": "******",
   "queries": [
     {
       "name": "test_metrics",
       "query": "sum:api.log_data.num_bytes{env:production} by {org_id}.as_rate()",
       "data_source": "metrics"
     }
   ],
   "start_date": "2025-08-06T00:00:00Z",
   "application_key": "******",
   "max_records_per_request": 5000
 }
}