---
title: "(EXPERIMENTAL) Compute column statistics"
method: POST
path: "/api/v1/actions/dataSources/{dataSourceId}/computeColumnStatistics"
tags: ["Computation"]
---

# (EXPERIMENTAL) Compute column statistics

`POST /api/v1/actions/dataSources/{dataSourceId}/computeColumnStatistics`

## Request

- Base URL: `https://www.gooddata.ai`
- URL: `https://www.gooddata.ai/api/v1/actions/dataSources/{dataSourceId}/computeColumnStatistics`
- Auth: none declared

(EXPERIMENTAL) Computes the requested statistical parameters of a column in a data source.

## Path parameters

- `dataSourceId` string, required

## Request body

- ColumnStatisticsRequest: A request to retrieve statistics for a column.
  - `columnName` string, required
  - `frequency` FrequencyProperties
    - `valueLimit` integer: The maximum number of distinct values to return.
  - `from` union, required
    - SqlQuery
      - `sql` string, required
    - Table
      - `tableName` string, required
  - `histogram` HistogramProperties
    - `bucketCount` integer, required
  - `statistics` string[]

## Response `200`

OK

- ColumnStatisticsResponse
  - `frequency` Frequency
    - `buckets` FrequencyBucket[], required
      - `count` integer, required
      - `value` string
  - `histogram` Histogram
    - `buckets` HistogramBucket[], required
      - `count` integer, required
      - `lowerBound` number, double, required
      - `upperBound` number, double, required
  - `statistics` ColumnStatistic[]
    - `type` 'COUNT' | 'COUNT_NULL' | 'COUNT_UNIQUE' | 'AVG' | 'STDDEV' | 'MIN' | 'MAX' | 'PERCENTILE_25' | 'PERCENTILE_50' | 'PERCENTILE_75', required
    - `value` string
  - `warnings` ColumnStatisticWarning[]
    - `action` string, required
    - `message` string, required

---

[API](https://skmtc.dev/gooddata/apis/gooddata-cn-oapi-all-api.md) - [All operations](https://skmtc.dev/gooddata/apis/gooddata-cn-oapi-all-api/llms.txt) - [OpenAPI document](https://skmtc.dev/gooddata/apis/gooddata-cn-oapi-all-api/revisions/c728ef303bfb?raw)