---
title: "Updates column profiles."
method: PATCH
path: "/profiling/columns"
tags: ["Profiling"]
---

# Updates column profiles.

`PATCH /profiling/columns`

A value is updated only if the relative property is supplied.
In order to delete a value, its property must be set to null in the request.

## Request body

- DataProfilingRequest
  - `columnProfiles` ColumnProfile[]
    - `assetIdentifier` AssetIdentifier, required
      - `id` string, uuid
      - `assetName` string
      - `domainId` string, uuid
      - `communityName` string
      - `domainName` string
    - `columnName` string
    - `technicalDataType` string
    - `dataType` string
    - `columnPosition` integer
    - `counts` Counts
      - `rowCount` integer
      - `emptyValuesCount` integer
      - `distinctValuesCount` integer
      - `mode` string
    - `samples` Samples
      - `samples` string[]
    - `statistics` Statistics
      - `mean` number, double
      - `variance` number, double
      - `standardDeviation` number, double
      - `minimum` string
      - `maximum` string
      - `minimumTextLength` integer
      - `maximumTextLength` integer
    - `databaseMetadata` DatabaseMetadata
      - `defaultValue` string
      - `numberOfDecimalDigits` integer
      - `charOctetLength` integer
      - `columnSize` integer
      - `primaryKeyName` string
      - `isNullable` boolean
      - `isAutoIncremented` boolean
      - `isGenerated` boolean
      - `isPrimaryKey` boolean
    - `categoricalMetadata` CategoricalMetadata
      - `categorical` boolean
      - `categoriesFrequencies` object
    - `quantiles` Quantiles
      - `percentile1` string
      - `percentile5` string
      - `decile1` string
      - `quartile1` string
      - `median` string
      - `quartile3` string
      - `decile9` string
      - `percentile95` string
      - `percentile99` string
    - `distributions` Distributions
      - `distributionDensityEstimation` Point[]
        - `x` number, double
        - `y` number, double
      - `histogram` HistogramBin[]
        - `lowerBound` string
        - `upperBound` string
        - `frequency` integer
        - `lowerBoundInISODateFormat` string
        - `upperBoundInISODateFormat` string

## Response `200`

The profile(s) update was successful.

- DataProfilingResponse
  - `updatedColumnsCount` integer
  - `errors` string[]

## Other responses

- `422` — Errors occurred, no column profile was updated.

---

[API](https://skmtc.net/collibra/apis/collibra-data-governance-center-core-api.md) · [All operations](https://skmtc.net/collibra/apis/collibra-data-governance-center-core-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/collibra/collibra-data-governance-center-core-api/revisions/6d091bc86a33/schema)