# How to query usage data from Data Stream

The **workloadConsumptionMetrics** dataset lets you get real-time aggregated data related to consumption and usage of Azion Products, including Data Stream.

The information can be accessed through the GraphQL API, allowing you to transfer this data to a third-party platform, and enabling you to further analyze and review it. Additionally, the data is available for up to *24 months*.

This guide explains how to query the total data streamed by Data Stream using the [GraphiQL Playground](/en/documentation/products/devtools/graphql-playground/).

--- 

## Querying streamed data

To query the total data streamed by Data Stream, proceed as follows:

1. Access the GraphiQL Playground at the following link: `https://api.azion.com/v4/consumption/graphql`.
    - You must be logged in to your Azion account. Otherwise, you'll receive an error message.
2. Send a query following this format:

```graphql
query {
  workloadConsumptionMetrics(
    filter: {
      tsRange: { 
        begin: "2025-02-01T00:00:00",
        end: "2025-03-01T00:00:00",
      }
      productId: 1498670028
      metricName: ["data_streamed", "requests"]
    }
    aggregate: {
      sum: accounted
    }
    limit: 10000
    groupBy: [clientId, workloadId, productId, metricName]
  ) {
    clientId
    workloadId
    productId
    metricName
    total: sum
  }
}
```

Where:

| Field | Description |
|----------|----------|
| `filter` | Defines the criteria used to filter the data returned by the query. |
| `tsRange` | A subfield of `filter`. Specifies a time range for filtering data. It includes `begin` and `end` fields to define the start and end timestamps. Format: `"YYYY-MM-DDTHH:mm:ss"`; example: `"2024-04-11T00:00:00"`. |
| `sum: accounted` | As a subfield of `aggregate`, calculates the total accounted usage for events matching the query’s filters and groups. |
| `limit` | Specifies the maximum number of results to return. System maximum: `10000`. |
| `groupBy` | Specifies the fields by which the query results should be grouped. Example: `[clientId, metricName]`. |
| `productId` | Unique identifier of the product being used. In this case, `1498670028` for Data Stream. |
| `metricName` | Name of the calculated metric for analytics. In this case, `data_streamed` and `requests`. |

:::note
This example retrieves data for the total number of requests processed and data streamed by Data Stream. The results are grouped by `clientId` and `workloadId`. To learn more about the available fields, check the [Consumption GraphQL API Fields](/en/documentation/devtools/graphql-api/features/gql-consumption-fields/) documentation.
:::

3. You'll receive a JSON response similar to this:

```json
{
  "data": {
    "workloadConsumptionMetrics": [
      {
        "clientId": "0000z",
        "workloadId": 7584931026,
        "productId": 1498670028,
        "metricName": "requests",
        "total": 1112
      },
      {
        "clientId": "0000z",
        "workloadId": 7584931026,
        "productId": 1498670028,
        "metricName": "data_streamed",
        "total": 6126218
      },
      {
        "clientId": "0000z",
        "workloadId": 1938475620,
        "productId": 1498670028,
        "metricName": "requests",
        "total": 2310065538
      },
      {
        "clientId": "0000z",
        "workloadId": 1938475620,
        "productId": 1498670028,
        "metricName": "data_streamed",
        "total": 74047917265
      },
      {
        "clientId": "0000z",
        "workloadId": 4829103746,
        "productId": 1498670028,
        "metricName": "data_streamed",
        "total": 4302538389
      }
    ]
  }
}
```

Where:

| Field | Description |
|----------|----------|
| `clientId` | Client unique identifier on Azion. Example: `8437r`. |
| `workloadId` | Identifier for the workload associated with the usage. Example: `4829301746`. |
| `productId` | Unique identifier of the product being used. In this case, `1498670028` for Data Stream. |
| `metricName` | Name of the measured metric for analytics. Example: `data_streamed` and `requests`.  |
| `total` | For `data_streamed`, total number of data streamed by Data Stream. This field is the result of a sum, in bytes. Example: `268675`. <br/> For `requests`: total number of requests processed. This field is the result of a sum. Example: `1112`. |

:::tip
To know more about the available fields, check the [Consumption GraphQL API Fields](/en/documentation/devtools/graphql-api/features/gql-consumption-fields/) documentation.
:::